/// <summary> /// ����һ������ /// </summary> public int Add(DTcms.Model.sys_channel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_channel("); strSql.Append("model_id,name,title,sort_id)"); strSql.Append(" values ("); strSql.Append("@model_id,@name,@title,@sort_id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@model_id", SqlDbType.Int,4), new SqlParameter("@name", SqlDbType.NVarChar,100), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@sort_id", SqlDbType.Int,4)}; parameters[0].Value = model.model_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.sort_id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Customer("); strSql.Append("Code,Name,LinkMan,LinkTel,LinkAddress,Email,Fax,Status,Remark"); strSql.Append(") values ("); strSql.Append("@Code,@Name,@LinkMan,@LinkTel,@LinkAddress,@Email,@Fax,@Status,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Code", SqlDbType.VarChar,254) , new SqlParameter("@Name", SqlDbType.VarChar,254) , new SqlParameter("@LinkMan", SqlDbType.VarChar,254) , new SqlParameter("@LinkTel", SqlDbType.VarChar,254) , new SqlParameter("@LinkAddress", SqlDbType.VarChar,254) , new SqlParameter("@Email", SqlDbType.VarChar,254) , new SqlParameter("@Fax", SqlDbType.VarChar,254) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.Code; parameters[1].Value = model.Name; parameters[2].Value = model.LinkMan; parameters[3].Value = model.LinkTel; parameters[4].Value = model.LinkAddress; parameters[5].Value = model.Email; parameters[6].Value = model.Fax; parameters[7].Value = model.Status; parameters[8].Value = model.Remark; return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0; }
/// <summary> /// ����һ������ /// </summary> public int Add(DTcms.Model.photo_attribute model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_photo_attribute("); strSql.Append("channel_id,title,remark,type,default_value,sort_id,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@title,@remark,@type,@default_value,@sort_id,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@type", SqlDbType.Int,4), new SqlParameter("@default_value", SqlDbType.NVarChar,500), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.title; parameters[2].Value = model.remark; parameters[3].Value = model.type; parameters[4].Value = model.default_value; parameters[5].Value = model.sort_id; parameters[6].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DTcms.Model.Attach model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Attach("); strSql.Append("StoreWaitingGoodsId,FilePath,CreateTime,Admin,Remark"); strSql.Append(") values ("); strSql.Append("@StoreWaitingGoodsId,@FilePath,@CreateTime,@Admin,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@StoreWaitingGoodsId", SqlDbType.Int,4) , new SqlParameter("@FilePath", SqlDbType.VarChar,254) , new SqlParameter("@CreateTime", SqlDbType.DateTime) , new SqlParameter("@Admin", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.StoreWaitingGoodsId; parameters[1].Value = model.FilePath; parameters[2].Value = model.CreateTime; parameters[3].Value = model.Admin; parameters[4].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.Vehicle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Vehicle("); strSql.Append("PlateNumber,Driver,LinkTel,LinkAddress,Remark"); strSql.Append(") values ("); strSql.Append("@PlateNumber,@Driver,@LinkTel,@LinkAddress,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@PlateNumber", SqlDbType.VarChar,254) , new SqlParameter("@Driver", SqlDbType.VarChar,254) , new SqlParameter("@LinkTel", SqlDbType.VarChar,254) , new SqlParameter("@LinkAddress", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.PlateNumber; parameters[1].Value = model.Driver; parameters[2].Value = model.LinkTel; parameters[3].Value = model.LinkAddress; parameters[4].Value = model.Remark; return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DTcms.Model.ReceivedUnitPrice model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ReceivedUnitPrice("); strSql.Append("ReceivedMoneyId,BeginTime,Price,EndTime,Remark"); strSql.Append(") values ("); strSql.Append("@ReceivedMoneyId,@BeginTime,@Price,@EndTime,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ReceivedMoneyId", SqlDbType.Int,4) , new SqlParameter("@BeginTime", SqlDbType.DateTime) , new SqlParameter("@Price", SqlDbType.Decimal,9) , new SqlParameter("@EndTime", SqlDbType.DateTime) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.ReceivedMoneyId; parameters[1].Value = model.BeginTime; parameters[2].Value = model.Price; parameters[3].Value = model.EndTime; parameters[4].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
public void Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.StoreOutUnitPrice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreOutUnitPrice("); strSql.Append("StoreOutOrderId,BeginTime,Price,EndTime,Remark"); strSql.Append(") values ("); strSql.Append("@StoreOutOrderId,@BeginTime,@Price,@EndTime,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@StoreOutOrderId", SqlDbType.Int,4) , new SqlParameter("@BeginTime", SqlDbType.DateTime) , new SqlParameter("@Price", SqlDbType.Decimal,9) , new SqlParameter("@EndTime", SqlDbType.DateTime) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.StoreOutOrderId; parameters[1].Value = model.BeginTime; parameters[2].Value = model.Price; parameters[3].Value = model.EndTime; parameters[4].Value = model.Remark; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); }
public void Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.StoreOutGoods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreOutGoods("); strSql.Append("StoreOutOrderId,StoreInOrderId,StoreInGoodsId,StoreOutWaitingGoodsId,Remark,Status,Count"); strSql.Append(") values ("); strSql.Append("@StoreOutOrderId,@StoreInOrderId,@StoreInGoodsId,@StoreOutWaitingGoodsId,@Remark,@Status,@Count"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StoreOutOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreInGoodsId", SqlDbType.Int,4) , new SqlParameter("@StoreOutWaitingGoodsId", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@Count", SqlDbType.Decimal,9) }; parameters[0].Value = model.StoreOutOrderId; parameters[1].Value = model.StoreInOrderId; parameters[2].Value = model.StoreInGoodsId; parameters[3].Value = model.StoreOutWaitingGoodsId; parameters[4].Value = model.Remark; parameters[5].Value = model.Status; parameters[6].Value = model.Count; new StoreInGoods().UpdateField(conn, trans, model.StoreInGoodsId, " Count = Count - " + model.Count + " "); new StoreOutWaitingGoods().UpdateField(conn, trans, model.StoreOutWaitingGoodsId, " Status = 1 "); DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.Store model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Store("); strSql.Append("StoreDomainId,Name,Manager,Address,Remark"); strSql.Append(") values ("); strSql.Append("@StoreDomainId,@Name,@Manager,@Address,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@StoreDomainId", SqlDbType.Int,4) , new SqlParameter("@Name", SqlDbType.VarChar,254) , new SqlParameter("@Manager", SqlDbType.VarChar,254) , new SqlParameter("@Address", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.StoreDomainId; parameters[1].Value = model.Name; parameters[2].Value = model.Manager; parameters[3].Value = model.Address; parameters[4].Value = model.Remark; return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0; }
public void Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.StoreInGoods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreInGoods("); strSql.Append("StoreInOrderId,StoreId,StoreWaitingGoodsId,CustomerId,Status,Count,StoredInTime,Remark,GoodsId"); strSql.Append(") values ("); strSql.Append("@StoreInOrderId,@StoreId,@StoreWaitingGoodsId,@CustomerId,@Status,@Count,@StoredInTime,@Remark,@GoodsId"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreId", SqlDbType.Int,4) , new SqlParameter("@StoreWaitingGoodsId", SqlDbType.Int,4) , new SqlParameter("@CustomerId", SqlDbType.Int,4) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@Count", SqlDbType.Decimal,9) , new SqlParameter("@StoredInTime", SqlDbType.DateTime) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@GoodsId", SqlDbType.Int,4) , }; parameters[0].Value = model.StoreInOrderId; parameters[1].Value = model.StoreId; parameters[2].Value = model.StoreWaitingGoodsId; parameters[3].Value = model.CustomerId; parameters[4].Value = model.Status; parameters[5].Value = model.Count; parameters[6].Value = model.StoredInTime; parameters[7].Value = model.Remark; parameters[8].Value = model.GoodsId; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.AllotOrder model) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AllotOrder("); strSql.Append("AllotTime,Status,Remark,CreateTime,Admin"); strSql.Append(") values ("); strSql.Append("@AllotTime,@Status,@Remark,@CreateTime,@Admin"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AllotTime", SqlDbType.DateTime) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@CreateTime", SqlDbType.DateTime) , new SqlParameter("@Admin", SqlDbType.VarChar,254) }; parameters[0].Value = model.AllotTime; parameters[1].Value = model.Status; parameters[2].Value = model.Remark; parameters[3].Value = model.CreateTime; parameters[4].Value = model.Admin; object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务 model.Id = Convert.ToInt32(obj); #region 调拨货物==================== if (model.AllotGoods.Count > 0) { AllotGoods allotGoodsDAL = new AllotGoods(); foreach (Model.AllotGoods allotGoods in model.AllotGoods) { allotGoods.AllotOrderId = model.Id; allotGoodsDAL.Add(conn, trans, allotGoods); } } #endregion trans.Commit(); } catch { trans.Rollback(); return false; } } } return model.Id > 0; }
public int Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.AllotGoods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AllotGoods("); strSql.Append("AllotOrderId,StoreInOrderId,StoreInGoodsId,Remark,Count,Status,SourceStoreId,PurposeStoreId "); strSql.Append(") values ("); strSql.Append("@AllotOrderId,@StoreInOrderId,@StoreInGoodsId,@Remark,@Count,@Status,@SourceStoreId,@PurposeStoreId"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AllotOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreInGoodsId", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@Count", SqlDbType.Decimal,9) , new SqlParameter("@Status", SqlDbType.Int,4), new SqlParameter("@SourceStoreId", SqlDbType.Int,4) , new SqlParameter("@PurposeStoreId", SqlDbType.Int,4) }; parameters[0].Value = model.AllotOrderId; parameters[1].Value = model.StoreInOrderId; parameters[2].Value = model.StoreInGoodsId; parameters[3].Value = model.Remark; parameters[4].Value = model.Count; parameters[5].Value = model.Status; parameters[6].Value = model.SourceStoreId; parameters[7].Value = model.PurposeStoreId; object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); StoreInGoods storeInGoodsDAL = new StoreInGoods(); Model.StoreInGoods storeInGoods = storeInGoodsDAL.GetModel(model.StoreInGoodsId); if (storeInGoods != null) { storeInGoodsDAL.UpdateField(conn, trans, model.StoreInGoodsId, " Count = Count - " + model.Count + ""); Model.StoreInGoods newStoreInGoods = new Model.StoreInGoods(model.PurposeStoreId, storeInGoods.StoreWaitingGoodsId, storeInGoods.CustomerId, storeInGoods.GoodsId, model.Count, "调拨货物"); newStoreInGoods.StoreInOrderId = model.StoreInOrderId; newStoreInGoods.Status = 1; storeInGoodsDAL.Add(conn, trans, newStoreInGoods); } if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// ����һ������,�����ӱ����� /// </summary> public int Add(DTcms.Model.sys_model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_model("); strSql.Append("title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys)"); strSql.Append(" values ("); strSql.Append("@title,@sort_id,@inherit_index,@inherit_list,@inherit_detail,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@inherit_index", SqlDbType.NVarChar,255), new SqlParameter("@inherit_list", SqlDbType.NVarChar,255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar,255), new SqlParameter("@is_sys", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; foreach (DTcms.Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@nav_url", SqlDbType.NVarChar,255), new SqlParameter("@sort_id", SqlDbType.Int,4)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[6].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.attributes model) { int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into dt_attributes("); strSql.Append("channel_id,title,remark,type,default_value,sort_id,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@title,@remark,@type,@default_value,@sort_id,@add_time)"); OleDbParameter[] parameters = { new OleDbParameter("@channel_id", OleDbType.Integer,4), new OleDbParameter("@title", OleDbType.VarChar,100), new OleDbParameter("@remark", OleDbType.VarChar,500), new OleDbParameter("@type", OleDbType.Integer,4), new OleDbParameter("@default_value", OleDbType.VarChar,500), new OleDbParameter("@sort_id", OleDbType.Integer,4), new OleDbParameter("@add_time", OleDbType.Date)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.title; parameters[2].Value = model.remark; parameters[3].Value = model.type; parameters[4].Value = model.default_value; parameters[5].Value = model.sort_id; parameters[6].Value = model.add_time; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return -1; } } } return newId; }
public void Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.CheckCost model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CheckCost("); strSql.Append("CheckRecordId,Name,Count,UnitPrice,TotalPrice,Status,PaidTime,Admin,Customer,HasBeenInvoiced,InvoicedTime,InvoicedOperator,Remark"); strSql.Append(") values ("); strSql.Append("@CheckRecordId,@Name,@Count,@UnitPrice,@TotalPrice,@Status,@PaidTime,@Admin,@Customer,@HasBeenInvoiced,@InvoicedTime,@InvoicedOperator,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@CheckRecordId", SqlDbType.Int,4) , new SqlParameter("@Name", SqlDbType.VarChar,254) , new SqlParameter("@Count", SqlDbType.Decimal,9) , new SqlParameter("@UnitPrice", SqlDbType.Decimal,9) , new SqlParameter("@TotalPrice", SqlDbType.Decimal,9) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@PaidTime", SqlDbType.DateTime) , new SqlParameter("@Admin", SqlDbType.VarChar,254) , new SqlParameter("@Customer", SqlDbType.VarChar,254) , new SqlParameter("@HasBeenInvoiced", SqlDbType.Bit,1) , new SqlParameter("@InvoicedTime", SqlDbType.DateTime) , new SqlParameter("@InvoicedOperator", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.CheckRecordId; parameters[1].Value = model.Name; parameters[2].Value = model.Count; parameters[3].Value = model.UnitPrice; parameters[4].Value = model.TotalPrice; parameters[5].Value = model.Status; parameters[6].Value = model.PaidTime; parameters[7].Value = model.Admin; parameters[8].Value = model.Customer; parameters[9].Value = model.HasBeenInvoiced; parameters[10].Value = model.InvoicedTime; parameters[11].Value = model.InvoicedOperator; parameters[12].Value = model.Remark; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.StoreInGoods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreInGoods("); strSql.Append("StoreInOrderId,StoreId,StoreWaitingGoodsId,CustomerId,Status,Count,StoredInTime,Remark"); strSql.Append(") values ("); strSql.Append("@StoreInOrderId,@StoreId,@StoreWaitingGoodsId,@CustomerId,@Status,@Count,@StoredInTime,@Remark"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreId", SqlDbType.Int,4) , new SqlParameter("@StoreWaitingGoodsId", SqlDbType.Int,4) , new SqlParameter("@CustomerId", SqlDbType.Int,4) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@Count", SqlDbType.Decimal,9) , new SqlParameter("@StoredInTime", SqlDbType.DateTime) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.StoreInOrderId; parameters[1].Value = model.StoreId; parameters[2].Value = model.StoreWaitingGoodsId; parameters[3].Value = model.CustomerId; parameters[4].Value = model.Status; parameters[5].Value = model.Count; parameters[6].Value = model.StoredInTime; parameters[7].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.StoreMode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreMode("); strSql.Append("Name,Remark"); strSql.Append(") values ("); strSql.Append("@Name,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.Name; parameters[1].Value = model.Remark; return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DTcms.Model.ReceivedOfStoreInGoods model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ReceivedOfStoreInGoods("); strSql.Append("ReceivedMoneyId,StoreInGoodsStoreInOrderId,StoreInGoodsId"); strSql.Append(") values ("); strSql.Append("@ReceivedMoneyId,@StoreInGoodsStoreInOrderId,@StoreInGoodsId"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ReceivedMoneyId", SqlDbType.Int,4) , new SqlParameter("@StoreInGoodsStoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@StoreInGoodsId", SqlDbType.Int,4) }; parameters[0].Value = model.ReceivedMoneyId; parameters[1].Value = model.StoreInGoodsStoreInOrderId; parameters[2].Value = model.StoreInGoodsId; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DTcms.Model.attributes model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update dt_attributes set "); strSql.Append("channel_id=@channel_id,"); strSql.Append("title=@title,"); strSql.Append("remark=@remark,"); strSql.Append("type=@type,"); strSql.Append("default_value=@default_value,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@type", SqlDbType.Int,4), new SqlParameter("@default_value", SqlDbType.NVarChar,500), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.title; parameters[2].Value = model.remark; parameters[3].Value = model.type; parameters[4].Value = model.default_value; parameters[5].Value = model.sort_id; parameters[6].Value = model.add_time; parameters[7].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.InvoicedRecord model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into InvoicedRecord("); strSql.Append("ReceivedMoneyId,StoreInOrderId,CustomerId,Remark,CreateTime,Admin,Price"); strSql.Append(") values ("); strSql.Append("@ReceivedMoneyId,@StoreInOrderId,@CustomerId,@Remark,@CreateTime,@Admin,@Price"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ReceivedMoneyId", SqlDbType.Int,4) , new SqlParameter("@StoreInOrderId", SqlDbType.Int,4) , new SqlParameter("@CustomerId", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@CreateTime", SqlDbType.DateTime) , new SqlParameter("@Admin", SqlDbType.VarChar,254) , new SqlParameter("@Price", SqlDbType.Decimal,9) }; parameters[0].Value = model.ReceivedMoneyId; parameters[1].Value = model.StoreInOrderId; parameters[2].Value = model.CustomerId; parameters[3].Value = model.Remark; parameters[4].Value = model.CreateTime; parameters[5].Value = model.Admin; parameters[6].Value = model.Price; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.sys_channel model) { int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_channel("); strSql.Append("model_id,[name],title,sort_id)"); strSql.Append(" values ("); strSql.Append("@model_id,@name,@title,@sort_id)"); OleDbParameter[] parameters = { new OleDbParameter("@model_id", OleDbType.Integer,4), new OleDbParameter("@name", OleDbType.VarChar,100), new OleDbParameter("@title", OleDbType.VarChar,100), new OleDbParameter("@sort_id", OleDbType.Integer,4)}; parameters[0].Value = model.model_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.sort_id; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return -1; } } } return newId; }
/// <summary> /// ����һ������ /// </summary> public int Add(DTcms.Model.comment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_comment("); strSql.Append("channel_id,content_id,title,user_id,user_name,user_ip,content,is_lock,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@content_id,@title,@user_id,@user_name,@user_ip,@content,@is_lock,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@content_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,255), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,50), new SqlParameter("@user_ip", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.content_id; parameters[2].Value = model.title; parameters[3].Value = model.user_id; parameters[4].Value = model.user_name; parameters[5].Value = model.user_ip; parameters[6].Value = model.content; parameters[7].Value = model.is_lock; parameters[8].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DTcms.Model.GoodsAttributeValues model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into GoodsAttributeValues("); strSql.Append("GoodsId,AttributeName,AttributeValue,Remark"); strSql.Append(") values ("); strSql.Append("@GoodsId,@AttributeName,@AttributeValue,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@GoodsId", SqlDbType.Int,4) , new SqlParameter("@AttributeName", SqlDbType.VarChar,254) , new SqlParameter("@AttributeValue", SqlDbType.VarChar,254) , new SqlParameter("@Remark", SqlDbType.VarChar,254) }; parameters[0].Value = model.GoodsId; parameters[1].Value = model.AttributeName; parameters[2].Value = model.AttributeValue; parameters[3].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
public void Add(SqlConnection conn, SqlTransaction trans, DTcms.Model.StoreOutGoodsVehicle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StoreOutGoodsVehicle("); strSql.Append("StoreOutWaitingGoodsId,VehicleId,Remark,Count"); strSql.Append(") values ("); strSql.Append("@StoreOutWaitingGoodsId,@VehicleId,@Remark,@Count"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@StoreOutWaitingGoodsId", SqlDbType.Int,4) , new SqlParameter("@VehicleId", SqlDbType.Int,4) , new SqlParameter("@Remark", SqlDbType.VarChar,254) , new SqlParameter("@Count", SqlDbType.Decimal,9) }; parameters[0].Value = model.StoreOutWaitingGoodsId; parameters[1].Value = model.VehicleId; parameters[2].Value = model.Remark; parameters[3].Value = model.Count; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.Order model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DTcms.Model.Order model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DTcms.Model.StoreInOrder model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DTcms.Model.StoreInCost model) { dal.Add(model); }
public bool Update(DTcms.Model.StoreInCost model, int id) { return dal.Update(model, id); }
/// <summary> /// ����һ������ /// </summary> public int Add(DTcms.Model.users model) { return dal.Add(model); }