C# DTcms类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中DTcms类的典型用法代码示例。如果您正苦于以下问题：C# DTcms类的具体用法？C# DTcms怎么用？C# DTcms使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

DTcms类属于命名空间，在下文中一共展示了DTcms类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Add

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

开发者ID:sichina，项目名称:DTcms_103_sql_src，代码行数:31，代码来源:sys_channel.cs

示例2: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:37，代码来源:Customer.cs

示例3: Add

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

开发者ID:sichina，项目名称:DTcms_103_sql_src，代码行数:37，代码来源:photo_attribute.cs

示例4: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:28，代码来源:Attach.cs

示例5: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:29，代码来源:Vehicle.cs

示例6: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:28，代码来源:ReceivedUnitPrice.cs

示例7: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:25，代码来源:StoreOutUnitPrice.cs

示例8: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:34，代码来源:StoreOutGoods.cs

示例9: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:28，代码来源:Store.cs

示例10: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:33，代码来源:StoreInGoods.cs

示例11: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:60，代码来源:AllotOrder.cs

示例12: Add

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

            }
        }

开发者ID:uwitec，项目名称:MWMS，代码行数:55，代码来源:AllotGoods.cs

示例13: Add

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

开发者ID:sichina，项目名称:DTcms_103_sql_src，代码行数:54，代码来源:sys_model.cs

示例14: Add

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

开发者ID:sichina，项目名称:or-dtcms2.0，代码行数:47，代码来源:attributes.cs

示例15: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:42，代码来源:CheckCost.cs

示例16: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:23，代码来源:StoreMode.cs

示例17: Add

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

开发者ID:uwitec，项目名称:MWMS，代码行数:24，代码来源:ReceivedOfStoreInGoods.cs

示例18: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(DTcms.Model.attributes model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update dt_attributes set ");
			strSql.Append("[email protected]_id,");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]_value,");
			strSql.Append("[email protected]_id,");
			strSql.Append("[email protected]_time");
			strSql.Append(" where [email protected]");
			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;
			}
		}

开发者ID:sichina，项目名称:or-dtcms2.0，代码行数:43，代码来源:attributes.cs

示例19: Add

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

            }
        }

开发者ID:uwitec，项目名称:MWMS，代码行数:43，代码来源:InvoicedRecord.cs

示例20: Add

		/// <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 =

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# DType类代码示例发布时间：2022-05-24

C# DTO类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18000|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9580|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8131|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8515|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8419|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9317|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8381|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7814|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8369|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7365|2022-11-06

客服电话

电子邮件

C# DTcms类代码示例

示例1: Add

示例2: Add

示例3: Add

示例4: Add

示例5: Add

示例6: Add

示例7: Add

示例8: Add

示例9: Add

示例10: Add

示例11: Add

示例12: Add

示例13: Add

示例14: Add

示例15: Add

示例16: Add

示例17: Add

示例18: Update

示例19: Add

示例20: Add

请发表评论

全部评论

上一篇：

下一篇：

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

delphiDES加密算法

medfreeman/markdown-it-toc-and-anchor: m

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053