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 bool SaveOperationAnalysis(OperationAnalysis oa, List <OperationTask> list, ref string err) { string sql = GSqlSentence.GetInsertInfo <OperationAnalysis>(oa); if (SQLBase.ExecuteNonQuery(sql) > 0) { sql = GSqlSentence.GetInsertByList <OperationTask>(list, "OperationTask"); if (SQLBase.ExecuteNonQuery(sql) > 0) { if (UpdateOId(oa.OId)) { return(true); } err = "编号更新失败"; return(false); } err = "任务信息保存失败"; return(false); } err = "保存失败"; return(false); }
public static bool SaveOperationAnalysis(OperationAnalysis oa, List <OperationTask> list, ref string err) { return(MandateInfoPro.SaveOperationAnalysis(oa, list, ref err)); }