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