public override int DealEndApprove(string approvePkValue, UserInfo sysUser, string viewTitle)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("assetsMergeId", approvePkValue);
string sql = @"select * from AssetsMergeDetail where assetsMergeId=@assetsMergeId";
DataTable dtAssets = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
int rowIndex = 0;
foreach (DataRow dr in dtAssets.Rows)
{
AssetsMerge assetsMerge = new AssetsMerge();
assetsMerge.AssetsId = DataConvert.ToString(dr["newAssetsId"]);
assetsMerge.AssetsNo = DataConvert.ToString(dr["assetsNo"]);
assetsMerge.AssetsValue = DataConvert.ToString(dr["assetsValue"]);
assetsMerge.OriginalAssetsId = DataConvert.ToString(dr["originalAssetsId"]);
if (rowIndex == 0)
{
AddNewAssets(assetsMerge, sysUser.UserId, viewTitle);
}
UpdateAssetsState(assetsMerge.OriginalAssetsId, "M", sysUser.UserId, viewTitle);
rowIndex++;
}
return(1);
}
protected override int AddData(Dictionary <string, object> objs, UserInfo sysUser, string viewTitle)
{
string sql = @"select * from AssetsMerge where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, dbUpdate.cmd).Tables[0];
dt.TableName = "AssetsMerge";
DataRow dr = dt.NewRow();
string assetsMergeId = IdGenerator.GetMaxId(dt.TableName);
int retApprove = InitFirstApproveTask("AssetsMerge", "AssetsMergeId", assetsMergeId, viewTitle);
foreach (KeyValuePair <string, object> kv in objs)
{
if (kv.Key != "gridData" && kv.Key != "upGridData")
{
dr[kv.Key] = kv.Value;
}
}
if (retApprove != 0)
{
dr["approveState"] = "O";
}
dr["AssetsMergeId"] = assetsMergeId;
Create5Field(dr, sysUser.UserId, viewTitle);
dt.Rows.Add(dr);
dbUpdate.Update(dt);
List <AssetsMerge> gridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(objs["gridData"]));
AssetsMerge assetsMerge = gridData[0];
assetsMerge.AssetsId = IdGenerator.GetMaxId("Assets");
List <AssetsMerge> upGridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(objs["upGridData"]));
foreach (AssetsMerge originalAssetsMerge in upGridData)
{
AddDetail(assetsMerge, originalAssetsMerge, assetsMergeId, sysUser.UserId, viewTitle);
if (retApprove == 0)
{
UpdateAssetsState(originalAssetsMerge.AssetsId, "M", sysUser.UserId, viewTitle);
}
else
{
UpdateAssetsState(originalAssetsMerge.AssetsId, "MI", sysUser.UserId, viewTitle);
}
}
if (retApprove == 0)
{
AddNewAssets(assetsMerge, sysUser.UserId, viewTitle);
}
return(1);
}
protected int AddDetail(AssetsMerge AssetsMerge, AssetsMerge OriginalAssetsMerge, string AssetsMergeId, string sysUser, string viewTitle)
{
string sql = @"select * from AssetsMergeDetail where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AssetsMergeDetail";
DataRow dr = dt.NewRow();
dr["AssetsMergeId"] = AssetsMergeId;
dr["originalAssetsId"] = OriginalAssetsMerge.AssetsId;
dr["newAssetsId"] = AssetsMerge.AssetsId;
dr["assetsNo"] = AssetsMerge.AssetsNo;
dr["assetsName"] = AssetsMerge.AssetsName;
dr["assetsValue"] = AssetsMerge.AssetsValue;
dr["remark"] = AssetsMerge.Remark;
dt.Rows.Add(dr);
return(dbUpdate.Update(dt));
}
protected override int EditData(Dictionary <string, object> objs, UserInfo sysUser, string pkValue, string viewTitle, string formMode)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("AssetsMergeId", pkValue);
string sql = @"select * from AssetsMerge where AssetsMergeId=@AssetsMergeId";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
dt.TableName = "AssetsMerge";
string AssetsMergeId = DataConvert.ToString(dt.Rows[0]["AssetsMergeId"]);
foreach (KeyValuePair <string, object> kv in objs)
{
if (kv.Key != "gridData" && kv.Key != "upGridData")
{
dt.Rows[0][kv.Key] = kv.Value;
}
}
if (formMode == "reapply")
{
dt.Rows[0]["approveState"] = "O";
}
Update5Field(dt, sysUser.UserId, viewTitle);
dbUpdate.Update(dt);
DeleteDetail(pkValue);
List <AssetsMerge> gridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(objs["gridData"]));
AssetsMerge AssetsMerge = gridData[0];
List <AssetsMerge> upGridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(objs["upGridData"]));
foreach (AssetsMerge OriginalAssetsMerge in upGridData)
{
AddDetail(AssetsMerge, OriginalAssetsMerge, pkValue, sysUser.UserId, viewTitle);
}
if (formMode == "reapply")
{
InitFirstApproveTask("AssetsMerge", "AssetsMergeId", AssetsMergeId, viewTitle, formMode, sysUser.UserId);
}
return(1);
}
//protected int UpdateOriginalAssets(AssetsMerge assetsMerge, string sysUser, string viewTitle)
//{
// Dictionary<string, object> paras = new Dictionary<string, object>();
// paras.Add("assetsId", assetsMerge.OriginalAssetsId);
// string sql = @"select * from Assets where assetsId=@assetsId";
// DataTable dtAssets = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
// dtAssets.TableName = "Assets";
// dtAssets.Rows[0]["assetsState"] = "M";
// Update5Field(dtAssets, sysUser, viewTitle);
// return dbUpdate.Update(dtAssets);
//}
protected int AddNewAssets(AssetsMerge assetsMerge, string sysUser, string viewTitle)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("assetsId", assetsMerge.OriginalAssetsId);
string sql = @"select * from Assets where assetsId=@assetsId ";
DataTable dtAssets = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
dtAssets.TableName = "Assets";
DataRow drNew = dtAssets.NewRow();
for (int i = 0; i < dtAssets.Columns.Count; i++)
{
drNew[i] = dtAssets.Rows[0][i];
}
drNew["assetsId"] = assetsMerge.AssetsId;
drNew["assetsNo"] = assetsMerge.AssetsNo;
drNew["assetsValue"] = assetsMerge.AssetsValue;
drNew["remark"] = assetsMerge.Remark;
Create5Field(drNew, sysUser, viewTitle);
dtAssets.Rows.Add(drNew);
return(dbUpdate.Update(dtAssets));
}