int IBaseBLL.Delete(ND_USER user, IDictionary keys, IDictionary values)
{
object key = ClassHelper.ChangeType(keys[KeyName], Ctx.Info.KeyMembers[0].MemberType);
var obj = DbEntry.GetObject <T>(key);
return(ExecuteDelete(user, obj));
}
public DataSet IGetData(ND_USER user, string sqlstr, Condition condition, OrderBy order, int pageSize, int pageIndex, ref int totalRowCount)
{
DataSet ds = new DataSet();
if (sqlstr != "")
{
string s = condition.GetSqlCondition().Replace("'", "''");
sqlstr = sqlstr.Trim().ToUpper();
if (sqlstr.Substring(6) == "SELECT")
{
if (sqlstr.Contains("[GCONDITION]"))
{
sqlstr = sqlstr.Replace("[GCONDITION]", s);
}
else
{
sqlstr = string.Format("select * from ({0}) p where {1}", sqlstr, s);
}
ds = DbEntry.Provider.ExecuteDataset(sqlstr);
totalRowCount = ds.Tables[0].Rows.Count;
}
else
{
sqlstr = string.Format("EXEC {0} '{1}','{2}'", sqlstr, user.USERDM, s);
ds = DbEntry.Provider.ExecuteDataset(sqlstr);
totalRowCount = ds.Tables[0].Rows.Count;
}
}
return(ds);
}
public override int ExecuteUpdate(ND_USER user, SM_SHOPSUPPLY obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.SUPPLYID = BaseExtends.GetNewAutoNo("SP");
obj.OPERATOR = user.USERDM;
}
int lnno = 1;
//foreach (SM_SHOPSUPPLYDTL d in obj.SHOPSUPPLYDTL)
//{
// if (d.ITEMCODE.IsNullOrEmpty()) { obj.SHOPSUPPLYDTL.Remove(d); continue; }
// d.SUPPLYID = obj.SUPPLYID;
// d.SUPLNNO = lnno;
// lnno++;
//}
for (int i = 0; i < obj.SHOPSUPPLYDTL.Count; i++)
{
SM_SHOPSUPPLYDTL d = obj.SHOPSUPPLYDTL[i];
if (d.ITEMCODE.IsNullOrEmpty())
{
obj.SHOPSUPPLYDTL.Remove(d); i--; continue;
}
d.SUPPLYID = obj.SUPPLYID;
d.SUPLNNO = lnno;
lnno++;
}
base.ExecuteUpdate(obj);
return(obj.Id);
}
public void Red(ND_USER user, SM_XSKP obj)
{
if (obj.STATUS == "A" && !G.Core.GConvert.ToBool(obj.ISRED) && !G.Core.GConvert.ToBool(obj.ISREVERSE))
{
DbEntry.UsingTransaction(delegate
{
SM_XSKP redobj = G.Core.Common.EnityClone.Clone <SM_XSKP>(obj);
redobj.ISRED = true;
redobj.STATUS = "C";
redobj.Id = 0;
redobj.SUMQTY = redobj.SUMQTY * -1;
redobj.SUMVAT = redobj.SUMVAT * -1;
redobj.SUMVOT = redobj.SUMVOT * -1;
redobj.SUMTAX = redobj.SUMTAX * -1;
foreach (SM_XSKPDTL xd in redobj.XSKPDTL)
{
xd.Id = 0;
xd.ATMONEY = xd.ATMONEY * -1;
xd.OTMONEY = xd.OTMONEY * -1;
xd.QTY = xd.QTY * -1;
xd.TAXMONEY = xd.TAXMONEY * -1;
}
redobj.Save();
obj.ISREVERSE = true;
obj.STATUS = "C";
obj.Save();
});
}
}
public override int ExecuteUpdate(ND_USER user, SM_POCKET obj)
{
this.ValidPocketData(obj);
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.POCKETDATE = DateTime.Parse(now.ToShortDateString());
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.POCKID = BaseExtends.GetNewAutoNo("PK");
obj.OPERATOR = user.USERDM;
}
int lnno = 1;
foreach (SM_POCKETDTL d in obj.POCKETDTL)
{
d.POCKID = obj.POCKID;
d.POCKLNNO = lnno;
lnno++;
}
DbEntry.NewTransaction(delegate
{
base.ExecuteUpdate(user, obj);
string csql = string.Format("exec SMProc_PocketStatus '{0}' ", obj.ORDERID);
DbEntry.Provider.ExecuteNonQuery(csql);
});
return(obj.Id);
}
public void XD(ND_USER user, string id)
{
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_MergePrePurOrder '{0}','{1}' ", id, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
public void ClearBomtemp(ND_USER user, string orderid)
{
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_ClearBomTemp '{0}','{1}' ", orderid, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
public void AssistAllDown(ND_USER user, string orderid)
{
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_AssistAllDown '{0}','{1}' ", orderid, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
public void PlanFin(ND_USER user, string orderid)
{
DbEntry.UsingTransaction(delegate
{
string sql = string.Format("update SM_SALEORDERSTATUS set ORDSTATUS=2 where OrderID='{0}'", orderid);
DbEntry.Provider.ExecuteNonQuery(sql);
});
}
public void Audit(ND_USER user, int id)
{
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_ApproveShipVoucher {0},'{1}' ", id, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
public override int ExecuteDelete(ND_USER user, SM_SALEORDER obj)
{
if (obj.STATUS == "C")
{
throw new Exception("结清订单不能删除");
}
else
{
return(base.ExecuteDelete(user, obj));
}
}
public override int ExecuteDelete(ND_USER user, SM_POCKET obj)
{
if (obj.STATUS == "N")
{
return(base.ExecuteDelete(user, obj));
}
else
{
throw new Exception("新增单据才能删除");
}
}
public override int ExecuteDelete(ND_USER user, SM_XSKP obj)
{
if (obj.STATUS == "N")
{
return(base.ExecuteDelete(user, obj));
}
else
{
return(0);
}
}
private void Save()
{
try
{
editData = eadapter.GetData();
G.BLL.Sys.ND_UserLogic logic = new BLL.Sys.ND_UserLogic();
logic.ExecuteUpdate(editData);
MessageBox.Show("保存成功！");
}
catch (Exception e) { MessageBox.Show(e.Message); }
}
public SM_SALEORDER GetSaleOrder(ND_USER user, string orderid)
{
SM_SALEORDER order = new SM_SALEORDER();
List <SM_SALEORDER> orders = this.ExecuteSelect(CK.K["ORDERID"].Eq(orderid), OrderBy.Parse("ORDERID"), 0, 0);
if (orders.Count > 0)
{
order = orders[0];
}
return(order);
}
public override int ExecuteUpdate(ND_USER user, DM_CUSTOMER obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.CUSTCODE = GetNewCustCode(obj.AREA);
obj.OPERATOR = user.USERDM;
}
base.ExecuteUpdate(user, obj);
return(obj.Id);
}
public override int ExecuteUpdate(ND_USER user, SM_PREPURORDER obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.PREPURORDID = BaseExtends.GetNewAutoNo("PP");
obj.OPERATOR = user.USERDM;
}
base.ExecuteUpdate(user, obj);
return(obj.Id);
}
public void UnClosed(ND_USER user, SM_PORDER obj)
{
if (obj.Id > 0 && obj.STATUS == "C")
{
obj.STATUS = "A";
obj.Save();
}
else
{
throw new Exception("该订单不是结清状态");
}
}
public override int ExecuteUpdate(ND_USER user, List <SM_SHOPORDER> list)
{
foreach (SM_SHOPORDER mo in list)
{
if (mo.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
mo.OPERDATE = DateTime.Parse(now.ToShortDateString());
mo.SHOPORDID = BaseExtends.GetNewAutoNo("MO");
mo.OPERATOR = user.USERDM;
}
}
return(base.ExecuteUpdate(user, list));
}
public void InValid(ND_USER user, SM_XSKP obj)
{
if (obj.STATUS == "A" && !G.Core.GConvert.ToBool(obj.ISRED) && !G.Core.GConvert.ToBool(obj.ISREVERSE))
{
DbEntry.UsingTransaction(delegate
{
obj.STATUS = "C";
obj.ISINVALID = true;
obj.Save();
string csql = string.Format("update SM_SALEORDERSTATUS set INVOICETAG=0 where ORDERID in (select orderid from SM_XSKPDTL where XSKPID={0})", obj.Id);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
}
public override int ExecuteUpdate(ND_USER user, SM_SHOPIN obj)
{
this.ValidShopInData(obj);
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.SHOPINID = BaseExtends.GetNewAutoNo("WI");
obj.OPERATOR = user.USERDM;
UpdateShoporder(user, obj);
}
base.ExecuteUpdate(user, obj);
return(obj.Id);
}
public virtual int ExecuteUpdate(ND_USER user, List <T> list, List <T> deletelist)
{
int c = 0;
DbEntry.UsingTransaction(delegate
{
foreach (T s in deletelist)
{
this.ExecuteDelete(s);
}
c = this.ExecuteUpdate(list);
});
return(c);
}
public void Audit(ND_USER user, SM_SHOPIN obj)
{
if (obj.STATUS == "N")
{
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_ApproveShopIn {0},'{1}' ", obj.Id, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
else
{
throw new Exception("订单已审核！");
}
}
public void Audit(ND_USER user, SM_PORDER obj)
{
if (obj.STATUS == "N")
{
DateTime now = BaseExtends.GetServerDate();
obj.STATUS = "A";
obj.AUDITDATE = now;
obj.AUDITOR = user.USERDM;
this.ExecuteUpdate(obj);
}
else
{
throw new Exception("订单已审核！");
}
}
public override int ExecuteUpdate(ND_USER user, SM_SALEORDER obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.ORDERDATE = DateTime.Parse(now.ToShortDateString());
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.ORDERID = BaseExtends.GetNewAutoNo("SO");
obj.OPERATOR = user.USERDM;
}
decimal allqty = 0, allamount = 0, addamount = 0, baseamount = 0;
int ordindex = 0;
foreach (SM_SALEORDERDTL d in obj.SALEORDERDTL)
{
ordindex++;
d.ORDERID = obj.ORDERID;
allqty += (decimal)d.LNQTY;
d.LNAMOUNT = d.LNPRICE * d.LNQTY;
addamount += (decimal)(d.LNQTY * d.ADDPRICE);
baseamount += (decimal)(d.LNQTY * d.BASICPRICE);
allamount += (decimal)d.LNAMOUNT;
d.ORDLNNO = ordindex;
}
obj.ORDQTY = allqty;
obj.ORDAMOUNT = allamount;
obj.ORDDISCOUNT = 0;
if (baseamount != 0)
{
obj.ORDDISCOUNT = decimal.Round((allamount - addamount) / baseamount, 3);
}
if (obj.STATUS == "A")
{
string csql = string.Format("SMProc_SaleOrderChange '{0}','{1}'", obj.ORDERID, user.USERDM);
DbEntry.UsingTransaction(delegate
{
DbEntry.Provider.ExecuteNonQuery(csql);
obj.STATUS = "B";
base.ExecuteUpdate(user, obj);
});
}
else
{
base.ExecuteUpdate(user, obj);
}
return(obj.Id);
}
public ND_USER CheckLogin(string logname, string pwd)
{
ND_USER user = null;
List <ND_USER> list = G.Data.DbEntry.From <ND_USER>().Where(ExpressionParser <ND_USER> .Parse(u => u.USERDM == logname && u.PASSWORD == pwd)).Select();
if (list.Count == 1)
{
user = list[0];
ND_LOG log = new ND_LOG();
log.ENTERTIME = DateTime.Now;
log.COMPUTERNAME = G.Core.Common.Usually.GetMachineName();
log.IP = G.Core.Common.Usually.GetIp();
log.Save();
}
return(user);
}
public List <ND_MENU> GetMenusByAuthority(ND_USER user)
{
int totalRowCount = 0;
List <ND_MENU> mlist = this.ExecuteSelect(ExpressionParser <ND_MENU> .Parse(m => m.SYSTEMNAME == "ERP" && m.ISVISIBLE == true), OrderBy.Parse("sortid"), 0, 1, ref totalRowCount);
if (user.ISMANAGER == true)
{
return(mlist);
}
else
{
ND_USER_MENUACCESSLogic acclogic = new ND_USER_MENUACCESSLogic();
List <ND_USER_MENUACCESS> alist = acclogic.GetMenusAccess(user.Id);
return(mlist.FindAll(m => { return alist.Exists(n => n.MENUID == m.Id); }));
}
}
public override int ExecuteUpdate(ND_USER user, DM_SUPPLIER obj)
{
if (obj.Id <= 0)
{
DateTime now = BaseExtends.GetServerDate();
obj.OPERDATE = DateTime.Parse(now.ToShortDateString());
obj.OPERATOR = user.USERDM;
}
if (obj.SUPPCODE == "")
{
obj.SUPPCODE = GetNewSuppCode(obj.PY.PadRight(3, 'A').Substring(0, 3));
}
base.ExecuteUpdate(user, obj);
return(obj.Id);
}
private void UpdateShoporder(ND_USER user, SM_SHOPIN shopin)
{
if (shopin.SHOPORDERID != "")
{
G.BLL.ERP.Shop.SM_SHOPORDERLogic shoporderlogic = new G.BLL.ERP.Shop.SM_SHOPORDERLogic();
List <SM_SHOPORDER> shoporderlist = shoporderlogic.ExecuteSelect(CK.K["SHOPORDID"].Eq(shopin.SHOPORDERID), OrderBy.Parse("SHOPORDID"), 0, 0);
if (shoporderlist.Count > 0)
{
SM_SHOPORDER shoporderobj = shoporderlist[0];
if (shoporderobj.FINQTY == null)
{
shoporderobj.FINQTY = 0;
}
shoporderobj.FINQTY += shopin.INQTY;
shoporderlogic.ExecuteUpdate(user, shoporderobj);
}
}
}
public void Audit(ND_USER user, SM_POCKET obj)
{
if (obj.STATUS == "N")
{
//DateTime now = BaseExtends.GetServerDate();
//obj.STATUS = "A";
//obj.AUDITDATE = now;
//obj.AUDITOR = user.USERDM;
//this.ExecuteUpdate(obj);
DbEntry.UsingTransaction(delegate
{
string csql = string.Format("exec SMProc_ApprovePocket {0},'{1}' ", obj.POCKID, user.USERDM);
DbEntry.Provider.ExecuteNonQuery(csql);
});
}
else
{
throw new Exception("订单已审核！");
}
}
