/// <summary> /// 增加一条数据,数据源为DataTable /// </summary> public int AddByDt(DataTable dt) { List <Hownet.Model.CompanyLog> li = DataTableToList(dt); if (li.Count > 0) { Hownet.BLL.Bas_KJKM bllKJ = new Bas_KJKM(); List <Hownet.Model.Bas_KJKM> liKJ = bllKJ.DataTableToList(bllKJ.GetList("(CompanyID=" + li[0].CompanyID + ")").Tables[0]); if (liKJ.Count > 0) { if (li[0].TypeID == (int)Enums.MoneyTableType.BackMoney) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.OutMoney) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } else if (li[0].TypeID == (int)Enums.MoneyTableType.Back) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } else if (li[0].TypeID == (int)Enums.MoneyTableType.Sell) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.SellBack) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.StockBackSupp) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } } return(dal.Add(li[0])); } else { return(0); } }
/// <summary> /// 删除一条数据 /// </summary> public void DeleteLog(int CompanyID, int TypeID, int TableID) { List <Hownet.Model.CompanyLog> li = DataTableToList(GetList(" (CompanyID=" + CompanyID + ") And (TypeID=" + TypeID + ") And (TableID=" + TableID + ") ").Tables[0]); dal.DeleteLog(CompanyID, TypeID, TableID); try { Hownet.BLL.Bas_KJKM bllKJ = new Bas_KJKM(); List <Hownet.Model.Bas_KJKM> liKJ = bllKJ.DataTableToList(bllKJ.GetList("(CompanyID=" + li[0].CompanyID + ")").Tables[0]); if (liKJ.Count > 0) { if (li[0].TypeID == (int)Enums.MoneyTableType.BackMoney) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.OutMoney) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } else if (li[0].TypeID == (int)Enums.MoneyTableType.Back) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } else if (li[0].TypeID == (int)Enums.MoneyTableType.Sell) { liKJ[0].Money -= li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.SellBack) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(1122); } else if (li[0].TypeID == (int)Enums.MoneyTableType.StockBackSupp) { liKJ[0].Money += li[0].ChangMoney; bllKJ.Update(liKJ[0]); bllKJ.UpMoney(2202); } } } catch (Exception ex) { } }