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