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)); }