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); }
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])); }
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); }