public override int DealEndApprove(string approvePkValue, UserInfo sysUser, string viewTitle)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("assetsSplitId", approvePkValue);
string sql = @"select * from AssetsSplitDetail where assetsSplitId=@assetsSplitId";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
int rowIndex = 0;
foreach (DataRow dr in dt.Rows)
{
AssetsSplit assetsSplit = new AssetsSplit();
assetsSplit.AssetsId = DataConvert.ToString(dr["newAssetsId"]);
assetsSplit.AssetsNo = DataConvert.ToString(dr["assetsNo"]);
assetsSplit.AssetsValue = DataConvert.ToString(dr["assetsValue"]);
assetsSplit.OriginalAssetsId = DataConvert.ToString(dr["originalAssetsId"]);
paras.Clear();
paras.Add("assetsId", assetsSplit.OriginalAssetsId);
sql = @"select * from Assets where assetsId=@assetsId";
DataTable dtAssets = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];
if (rowIndex == 0)
{
UpdateAssetsState(assetsSplit.OriginalAssetsId, "S", sysUser.UserId, viewTitle);
}
AddNewAssets(assetsSplit, dtAssets, sysUser.UserId, viewTitle);
rowIndex++;
}
return(1);
}
//protected int UpdateOriginalAssets(AssetsSplit AssetsSplit, DataTable dtAssets, string sysUser, string viewTitle)
//{
// DataTable dtNew = dtAssets.Clone();
// foreach (DataRow drNew in dtAssets.Rows)
// {
// dtNew.ImportRow(drNew);
// }
// dtNew.TableName = "Assets";
// dtNew.Rows[0]["assetsState"] = "S";
// Update5Field(dtNew, sysUser, viewTitle);
// return dbUpdate.Update(dtNew);
//}
protected int AddNewAssets(AssetsSplit AssetsSplit, DataTable dtAssets, string sysUser, string viewTitle)
{
DataTable dtNew = dtAssets.Clone();
DataRow drNew = dtNew.NewRow();
for (int i = 0; i < dtAssets.Columns.Count; i++)
{
drNew[i] = dtAssets.Rows[0][i];
}
drNew["assetsId"] = AssetsSplit.AssetsId;
drNew["assetsNo"] = AssetsSplit.AssetsNo;
drNew["assetsValue"] = AssetsSplit.AssetsValue;
drNew["remark"] = AssetsSplit.Remark;
Create5Field(drNew, sysUser, viewTitle);
dtNew.TableName = "Assets";
dtNew.Rows.Add(drNew);
return(dbUpdate.Update(dtNew));
}
protected int AddDetail(AssetsSplit AssetsSplit, string AssetsSplitId, string sysUser, string viewTitle)
{
string sql = @"select * from AssetsSplitDetail where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AssetsSplitDetail";
DataRow dr = dt.NewRow();
dr["AssetsSplitId"] = AssetsSplitId;
dr["newAssetsId"] = AssetsSplit.AssetsId;
dr["assetsNo"] = AssetsSplit.AssetsNo;
dr["assetsName"] = AssetsSplit.AssetsName;
dr["assetsValue"] = AssetsSplit.AssetsValue;
dr["remark"] = AssetsSplit.Remark;
dr["originalAssetsId"] = AssetsSplit.OriginalAssetsId;
dt.Rows.Add(dr);
return(dbUpdate.Update(dt));
}
