public SalesOrdersModel AddEntity(SalesOrdersModel entity)
{
string sql = string.Format("insert into salesOrders(orderNumber,customerId,customerName,telphone,address,contract,orderDate) values('{0}',{1},'{2}','{3}','{4}','{5}','{6}')",
entity.OrderNumber, entity.CustomerId, entity.CustomerName, entity.Tel, entity.Address, entity.Contract, entity.OrderDate);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('salesOrders')", null).ToString());
entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
public Model.PurchaseOrdersModel AddEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("insert into purchaseOrders(orderNumber,supplier,person,telphone,address,contract,OrderDate) values({0},'{1}','{2}','{3}','{4}','{5}','{6}')",
entity.OrderNumber, entity.SupplierName, entity.Person, entity.Tel, entity.Address, entity.Contract, entity.OrderDate);
int resRows = MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null);
if (resRows > 0)
{
int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('purchaseOrders')", null).ToString());
entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
private int GetNewID()
{
string sql = "select s_commodity.nextval from dual";
return(int.Parse(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, sql, null).ToString()));
}
internal int GetVerifyLogCountByComId(string comid)
{
string sqltxt = "select count(1) from b2b_etcket_log where action=1 and a_state=1 and jsid=0 and com_id=" + comid;
return((int)MSSqlHelper.ExecuteScalar(sqltxt));
}
