private List <TKS_FAS_CustomColDesExt> CodeBindValue(List <TKS_FAS_CustomColDes> customColDes, TKS_FAS_CaculateHelperDetail data) { #region foolish bind List <TKS_FAS_CustomColDesExt> result = new List <TKS_FAS_CustomColDesExt>(); foreach (var item in customColDes) { TKS_FAS_CustomColDesExt newData = new TKS_FAS_CustomColDesExt(); newData.Id = item.Id; newData.AccountId = item.AccountId; newData.ColumnCode = item.ColumnCode; newData.ColumnName = item.ColumnName; newData.ParentId = item.ParentId; if (item.ColumnCode == "1") { newData.Value = data.Custom1; } else if (item.ColumnCode == "2") { newData.Value = data.Custom2; } else if (item.ColumnCode == "3") { newData.Value = data.Custom3; } else if (item.ColumnCode == "4") { newData.Value = data.Custom4; } else if (item.ColumnCode == "5") { newData.Value = data.Custom5; } else if (item.ColumnCode == "6") { newData.Value = data.Custom6; } else if (item.ColumnCode == "7") { newData.Value = data.Custom7; } else if (item.ColumnCode == "8") { newData.Value = data.Custom8; } result.Add(newData); } return(result); #endregion }
public void CustomDataImport(DataTable dt, string token, string itemId) { using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(token, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); BalanceBLL balanceBLL = new BalanceBLL(cnn); PeriodBLL periodBLL = new PeriodBLL(cnn); string sql = string.Empty; sql = @"delete from TKS_FAS_CaculateHelperDetail where AccountId=@AccountId and ParentId=@ParentId"; cnn.Execute(sql, new { AccountId = user.AccountId, ParentId = itemId }, ts); if (dt.DefaultView.ToTable(true, "Name").Rows.Count < dt.Rows.Count) { throw new NormalException("名称不能重复"); } for (var i = 0; i < dt.Rows.Count; i++) { var rowItem = dt.Rows[i]; TKS_FAS_CaculateHelperDetail fix = new TKS_FAS_CaculateHelperDetail(); fix.Id = Guid.NewGuid().ToString("N"); fix.AccountId = user.AccountId; fix.ParentId = itemId;//当前期间为录入期间 fix.IsValid = 1; fix.Code = (i + 1).ToString().PadLeft(3, '0'); fix.Name = rowItem["Name"].ToString(); fix.Memo = rowItem["Memo"].ToString(); fix.Custom1 = "#nodata#"; fix.Custom2 = "#nodata#"; fix.Custom3 = "#nodata#"; fix.Custom4 = "#nodata#"; fix.Custom5 = "#nodata#"; fix.Custom6 = "#nodata#"; fix.Custom7 = "#nodata#"; fix.Custom8 = "#nodata#"; cnn.Insert <TKS_FAS_CaculateHelperDetail>(fix, ts); } ts.Commit(); } catch (Exception ex) { ts.Rollback(); throw ex; } } }
private TKS_FAS_CaculateHelperDetail LoadByDic(Dictionary <string, string> saveData) { TKS_FAS_CaculateHelperDetail data = new TKS_FAS_CaculateHelperDetail(); data.Id = Guid.NewGuid().ToString(); data.Code = saveData["Code"]; data.Name = saveData["Name"]; data.Memo = saveData["Memo"]; data.Custom1 = saveData.ContainsKey("Custom1") ? saveData["Custom1"] : "#nodata#"; data.Custom2 = saveData.ContainsKey("Custom2") ? saveData["Custom2"] : "#nodata#"; data.Custom3 = saveData.ContainsKey("Custom3") ? saveData["Custom3"] : "#nodata#"; data.Custom4 = saveData.ContainsKey("Custom4") ? saveData["Custom4"] : "#nodata#"; data.Custom5 = saveData.ContainsKey("Custom5") ? saveData["Custom5"] : "#nodata#"; data.Custom6 = saveData.ContainsKey("Custom6") ? saveData["Custom6"] : "#nodata#"; data.Custom7 = saveData.ContainsKey("Custom7") ? saveData["Custom7"] : "#nodata#"; data.Custom8 = saveData.ContainsKey("Custom8") ? saveData["Custom8"] : "#nodata#"; data.IsValid = saveData.ContainsKey("IsValid") ? 1 : 0; return(data); }
public ResponseCustomDataAdd CustomDataAdd(RequestCustomDataAdd request) { ResponseCustomDataAdd response = new ResponseCustomDataAdd(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { Dictionary <string, string> saveData = List2Dic(request.Data); var user = this.UserInfoGet(request.Token, ts); var item = cnn.QueryFirst <Max_CaculateHelperDetailCode>( @"select isnull(max(code),0) Code from TKS_FAS_CaculateHelperDetail where accountId=@AccountId and parentId=@ParentId", new { AccountId = user.AccountId, ParentId = request.Head.Id }, ts); saveData["Code"] = (item.Code + 1).ToString().PadLeft(3, '0'); #region code ,name verification //var d = cnn.Query(@"select * from TKS_FAS_CaculateHelperDetail // where code=@Code and accountId=@AccountId and parentId=@ParentId", // new // { // Code = saveData["Code"], // AccountId = user.AccountId, // ParentId = request.Head.Id//item id // }, ts); //if (d.Count() > 0) //{ // throw new NormalException("编码已经存在"); //} var d = cnn.Query(@"select * from TKS_FAS_CaculateHelperDetail where name=@Name and accountId=@AccountId and parentId=@ParentId", new { Name = saveData["Name"], AccountId = user.AccountId, ParentId = request.Head.Id//item id }, ts); if (d.Count() > 0) { throw new NormalException("名称已经存在"); } #endregion TKS_FAS_CaculateHelperDetail detail = new TKS_FAS_CaculateHelperDetail(); detail = LoadByDic(saveData); detail.ParentId = request.Head.Id; detail.AccountId = user.AccountId; cnn.Insert <TKS_FAS_CaculateHelperDetail>(detail, ts); ts.Commit(); response.Id = request.Head.Id; response.IsSuccess = true; response.Message = "新增成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseCustomDataAdd); } } }