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