protected int AddDetail(AssetsCheck AssetsCheck, string AssetsCheckId, UserInfo sysUser, string viewTitle, string updateType)
{
string sql = @"select * from AssetsCheckDetail where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AssetsCheckDetail";
DataRow dr = dt.NewRow();
dr["AssetsCheckId"] = AssetsCheckId;
dr["assetsId"] = AssetsCheck.AssetsId;
dr["remark"] = AssetsCheck.Remark;
dr["departmentId"] = AssetsCheck.DepartmentId;
dr["storeSiteId"] = AssetsCheck.StoreSiteId;
dr["actualDepartmentId"] = AssetsCheck.ActualDepartmentId;
dr["actualStoreSiteId"] = AssetsCheck.ActualStoreSiteId;
dr["isFinished"] = AssetsCheck.IsFinished;
dr["checkResult"] = AssetsCheck.CheckResultId;
dr["checkDate"] = DataConvert.ToDBObject(AssetsCheck.CheckDate);
dr["actualCheckDate"] = DataConvert.ToDBObject(AssetsCheck.ActualCheckDate);
dr["setBooksId"] = sysUser.MySetBooks.SetBooksId;
dt.Rows.Add(dr);
if (DataConvert.ToString(AssetsCheck.CreateId) != "")
{
if (updateType == "Reapply")
{
dr["approveState"] = "O";
}
else
{
dr["approveState"] = AssetsCheck.ApproveState;
}
dr["createId"] = AssetsCheck.CreateId;
dr["createTime"] = AssetsCheck.CreateTime;
Update5Field(dt, sysUser.UserId, viewTitle);
}
else
{
if (updateType == "ApproveAdd")
{
dr["approveState"] = "O";
}
Create5Field(dt, sysUser.UserId, viewTitle);
}
return(DbUpdate.Update(dt));
}
protected int UpdateDetail(AssetsCheck AssetsCheck, string AssetsCheckId, UserInfo sysUser, string viewTitle, string updateType)
{
string sql = string.Format(@"select * from AssetsCheckDetail where AssetsCheckId='{0}' and assetsId='{1}' ", AssetsCheckId, AssetsCheck.AssetsId);
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AssetsCheckDetail";
if (dt.Rows.Count > 0)
{
dt.Rows[0]["actualDepartmentId"] = AssetsCheck.ActualDepartmentId;
dt.Rows[0]["actualStoreSiteId"] = AssetsCheck.ActualStoreSiteId;
dt.Rows[0]["isFinished"] = AssetsCheck.IsFinished;
dt.Rows[0]["checkResult"] = AssetsCheck.CheckResultId;
dt.Rows[0]["checkDate"] = DataConvert.ToDBObject(AssetsCheck.CheckDate);
dt.Rows[0]["actualCheckDate"] = DataConvert.ToDBObject(AssetsCheck.ActualCheckDate);
}
Update5Field(dt, sysUser.UserId, viewTitle);
return(DbUpdate.Update(dt));
}