ykgy.cs

基于C/S的医疗卫生管理系统

using System;
using System.Collections.Generic;
using System.Text;

using Qeb.DBProxy;
using Qeb.Support;

namespace Qeb.YK
{
    public class YkGy
    {
        public static string KfLx2DwDropDownItem(string kfLx)
        {
            string itemValue = "";
            if (kfLx.Substring(0,1) =="1")
                itemValue = "西药~t1";
            
            if (kfLx.Substring(1, 1) == "1")
                itemValue += "/成药~t2";
            
            if (kfLx.Substring(2,1) == "1")
                itemValue += "/草药~t3";

            return itemValue;
        }

        public struct YkKjRl
        {
            public string kjQj;
            public DateTime KsRq;
            public DateTime JsRq;
        }
        public static YkKjRl GetDqKjQj()
        {
            string sql = "SELECT KJQJ||'&'||TO_CHAR(KSRQ,'YYYY-MM-DD')||'&'||TO_CHAR(JSRQ,'YYYY-MM-DD') FROM YK_KJQJ";
            sql += " WHERE YYID='" + App.yyId + "' AND DQBZ=1";

            DbProxyClient proxy = App.DbProxy;
            proxy.Clear();
            string ret = proxy.ExecuteScalar(sql);
            if (string.IsNullOrEmpty(ret))
            {
                throw new Exception("没有取会计期间信息，请检查会计期间是否已正确设置");
            }

            try
            {
                string[] value = ret.Split(new char[] { '&' });
                YkKjRl ykKjRl ;
                ykKjRl.kjQj = value[0]; //会计期间
                ykKjRl.KsRq = Convert.ToDateTime(value[1]); //开始日期
                ykKjRl.JsRq = Convert.ToDateTime(value[2]); //结束日期
                return ykKjRl;
            }
            catch
            {
                throw new Exception("返回的字符串格式不正确:"+ret);
            }
        }
    }
}