Beispiel #1
0
        public static OperationAnalysis getOperationAnalysis(int month)
        {
            string            sql = "select top(1) OId, Year, Month, Overview, BusinesAnalysi, BusinesContent, PayableAnalysi, PayableContent, Experience, Other, Unit, CreateUser, CreateTime from OperationAnalysis where year=" + DateTime.Now.ToString("yyyy") + " and Month = " + month + " and unit='" + GAccount.GetAccountInfo().UnitName + "' order by CreateTime";
            OperationAnalysis oa  = new OperationAnalysis();

            GSqlSentence.SetTValueD <OperationAnalysis>(oa, SQLBase.FillTable(sql).Rows[0]);
            return(oa);
        }
Beispiel #2
0
        public static PayInfo GetPayInfo(string PayId)
        {
            string    sql     = "select PayId, PaymentMethod, PayMoney, hkhorzph, PayCompany, PayType, SFKP, RendingReason, Remark, PayTime, CreateTime, CreateUser, Validate from PayInfo where PayId='" + PayId + "'";
            DataTable dt      = SQLBase.FillTable(sql);
            PayInfo   payInfo = new PayInfo();

            return(GSqlSentence.SetTValueD <PayInfo>(payInfo, dt.Rows[0]));
        }
Beispiel #3
0
        public static tk_Product_Plan IndexAllupdatePlan(string JHID)
        {
            string    str = "select  JHID, UnitID, Plannedyear, Plannedmonth, convert(varchar(100),Specifieddate,23) Specifieddate, Formulation, Remarks, State, Approvalstatus, CreateUser, CreateTime, Validate from BGOI_Produce.dbo.tk_Product_Plan where JHID='" + JHID + "'";
            DataTable dt  = SQLBase.FillTable(str, "MainProduce");

            if (dt == null)
            {
                return(null);
            }
            tk_Product_Plan Task = new tk_Product_Plan();

            GSqlSentence.SetTValueD <tk_Product_Plan>(Task, dt.Rows[0]);
            //foreach (DataRow item in dt.Rows)
            //{
            //    DataRowToPlan(item, Task);
            //}
            return(Task);
        }