/// <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)
{
}
}
