Example #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Maticsoft.Model.W_Material model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update W_Material set ");
            strSql.Append("Name=@Name,");
            strSql.Append("Begindate=@Begindate,");
            strSql.Append("Enddate=@Enddate,");
            strSql.Append("Number=@Number,");
            strSql.Append("Address=@Address");
           
            strSql.Append(" where Id=@Id ");
            SqlParameter[] parameters = {
					new SqlParameter("@Id", SqlDbType.Int,4),
					new SqlParameter("@Name", SqlDbType.NVarChar,100),
					new SqlParameter("@Begindate", SqlDbType.DateTime),
					new SqlParameter("@Enddate", SqlDbType.DateTime),
					new SqlParameter("@Number", SqlDbType.VarChar,150),
					new SqlParameter("@Address", SqlDbType.VarChar,150),
                   };
            parameters[0].Value = model.Id;
            parameters[1].Value = model.Name;
            parameters[2].Value = model.Begindate;
            parameters[3].Value = model.Enddate;
            parameters[4].Value = model.Number;
            parameters[5].Value = model.Address;
           

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Example #2
0
 public bool AddEx(Maticsoft.Model.SNS.UserAlbumDetail model)
 {
     List<CommandInfo> cmdList = new List<CommandInfo>();
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into SNS_UserAlbumDetail(");
     builder.Append("AlbumID,TargetID,Type,Description,AlbumUserId)");
     builder.Append(" values (");
     builder.Append("@AlbumID,@TargetID,@Type,@Description,@AlbumUserId)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] para = new SqlParameter[] { new SqlParameter("@AlbumID", SqlDbType.Int, 4), new SqlParameter("@TargetID", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@AlbumUserId", SqlDbType.Int, 4) };
     para[0].Value = model.AlbumID;
     para[1].Value = model.TargetID;
     para[2].Value = model.Type;
     para[3].Value = model.Description;
     para[4].Value = model.AlbumUserId;
     CommandInfo item = new CommandInfo(builder.ToString(), para);
     cmdList.Add(item);
     StringBuilder builder2 = new StringBuilder();
     builder2.Append("update SNS_UserAlbums set ");
     builder2.Append("PhotoCount=PhotoCount+1 ");
     builder2.Append(" where AlbumID=@AlbumID");
     SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@AlbumID", SqlDbType.Int, 4) };
     parameterArray2[0].Value = model.AlbumID;
     CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2);
     cmdList.Add(info2);
     if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0)
     {
         return false;
     }
     return true;
 }
Example #3
0
 public int Add(Maticsoft.Model.Ms.Theme model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Ms_Theme(");
     builder.Append("Name,Description,PreviewPhotoSrc,ZipPackageSrc,ThemeSize,Author,IsCurrent,Language,CreatedDate,Remark)");
     builder.Append(" values (");
     builder.Append("@Name,@Description,@PreviewPhotoSrc,@ZipPackageSrc,@ThemeSize,@Author,@IsCurrent,@Language,@CreatedDate,@Remark)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@PreviewPhotoSrc", SqlDbType.NVarChar, 100), new SqlParameter("@ZipPackageSrc", SqlDbType.NVarChar, 50), new SqlParameter("@ThemeSize", SqlDbType.Int, 4), new SqlParameter("@Author", SqlDbType.NVarChar, 100), new SqlParameter("@IsCurrent", SqlDbType.Bit, 1), new SqlParameter("@Language", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.NVarChar, 100) };
     cmdParms[0].Value = model.Name;
     cmdParms[1].Value = model.Description;
     cmdParms[2].Value = model.PreviewPhotoSrc;
     cmdParms[3].Value = model.ZipPackageSrc;
     cmdParms[4].Value = model.ThemeSize;
     cmdParms[5].Value = model.Author;
     cmdParms[6].Value = model.IsCurrent;
     cmdParms[7].Value = model.Language;
     cmdParms[8].Value = model.CreatedDate;
     cmdParms[9].Value = model.Remark;
     object single = Maticsoft.DBUtility.DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.rolefun model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into rolefun(");
            strSql.Append("roleid,funid,rolep)");
            strSql.Append(" values (");
            strSql.Append("@roleid,@funid,@rolep)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@roleid", SqlDbType.Int,4),
                    new SqlParameter("@funid", SqlDbType.Int,4),
                    new SqlParameter("@rolep", SqlDbType.Int,4)};
            parameters[0].Value = model.roleid;
            parameters[1].Value = model.funid;
            parameters[2].Value = model.rolep;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.District model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into District(");
            strSql.Append("DistrictID,DistrictName,CityID,SortID)");
            strSql.Append(" values (");
            strSql.Append("@DistrictID,@DistrictName,@CityID,@SortID)");
            SqlParameter[] parameters = {
                    new SqlParameter("@DistrictID", SqlDbType.NVarChar,50),
                    new SqlParameter("@DistrictName", SqlDbType.NVarChar,50),
                    new SqlParameter("@CityID", SqlDbType.NVarChar,50),
                    new SqlParameter("@SortID", SqlDbType.Int,4)};
            parameters[0].Value = model.DistrictID;
            parameters[1].Value = model.DistrictName;
            parameters[2].Value = model.CityID;
            parameters[3].Value = model.SortID;

            int rows=ServerDbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #6
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.sys_Applications model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into sys_Applications(");
            strSql.Append("A_AppName,A_AppDescription,A_AppUrl,A_Order)");
            strSql.Append(" values (");
            strSql.Append("@A_AppName,@A_AppDescription,@A_AppUrl,@A_Order)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@A_AppName", SqlDbType.NVarChar,50),
                    new SqlParameter("@A_AppDescription", SqlDbType.NVarChar,200),
                    new SqlParameter("@A_AppUrl", SqlDbType.VarChar,50),
                    new SqlParameter("@A_Order", SqlDbType.Int,4)};
            parameters[0].Value = model.A_AppName;
            parameters[1].Value = model.A_AppDescription;
            parameters[2].Value = model.A_AppUrl;
            parameters[3].Value = model.A_Order;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.education_Prescription model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into education_Prescription(");
            strSql.Append("P_Object,P_Name,P_Content,P_Doctor,P_Date)");
            strSql.Append(" values (");
            strSql.Append("@P_Object,@P_Name,@P_Content,@P_Doctor,@P_Date)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@P_Object", SqlDbType.Money,8),
                    new SqlParameter("@P_Name", SqlDbType.NVarChar,100),
                    new SqlParameter("@P_Content", SqlDbType.Text),
                    new SqlParameter("@P_Doctor", SqlDbType.Int,4),
                    new SqlParameter("@P_Date", SqlDbType.DateTime)};
            parameters[0].Value = model.P_Object;
            parameters[1].Value = model.P_Name;
            parameters[2].Value = model.P_Content;
            parameters[3].Value = model.P_Doctor;
            parameters[4].Value = model.P_Date;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #8
0
 public int Add(Maticsoft.Model.Shop.Products.ProductReviews model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Shop_ProductReviews(");
     builder.Append("ProductId,UserId,ReviewText,UserName,UserEmail,CreatedDate,ParentId,Status,OrderId,SKU,Attribute,ImagesPath,ImagesNames)");
     builder.Append(" values (");
     builder.Append("@ProductId,@UserId,@ReviewText,@UserName,@UserEmail,@CreatedDate,@ParentId,@Status,@OrderId,@SKU,@Attribute,@ImagesPath,@ImagesNames)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProductId", SqlDbType.BigInt, 8), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@ReviewText", SqlDbType.NVarChar, -1), new SqlParameter("@UserName", SqlDbType.NVarChar, 200), new SqlParameter("@UserEmail", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@OrderId", SqlDbType.BigInt, 8), new SqlParameter("@SKU", SqlDbType.NVarChar, 200), new SqlParameter("@Attribute", SqlDbType.Text), new SqlParameter("@ImagesPath", SqlDbType.NVarChar, 300), new SqlParameter("@ImagesNames", SqlDbType.NVarChar, 500) };
     cmdParms[0].Value = model.ProductId;
     cmdParms[1].Value = model.UserId;
     cmdParms[2].Value = model.ReviewText;
     cmdParms[3].Value = model.UserName;
     cmdParms[4].Value = model.UserEmail;
     cmdParms[5].Value = model.CreatedDate;
     cmdParms[6].Value = model.ParentId;
     cmdParms[7].Value = model.Status;
     cmdParms[8].Value = model.OrderId;
     cmdParms[9].Value = model.SKU;
     cmdParms[10].Value = model.Attribute;
     cmdParms[11].Value = model.ImagesPath;
     cmdParms[12].Value = model.ImagesNames;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #9
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.AR_Announcement model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into AR_Announcement(");
            strSql.Append("A_Title,A_Content,A_DateTime,A_ResponsibilityUserID,A_Type,A_GroupID)");
            strSql.Append(" values (");
            strSql.Append("@A_Title,@A_Content,@A_DateTime,@A_ResponsibilityUserID,@A_Type,@A_GroupID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@A_Title", SqlDbType.NVarChar,255),
                    new SqlParameter("@A_Content", SqlDbType.Text),
                    new SqlParameter("@A_DateTime", SqlDbType.DateTime),
                    new SqlParameter("@A_ResponsibilityUserID", SqlDbType.Int,4),
                    new SqlParameter("@A_Type", SqlDbType.TinyInt,1),
                    new SqlParameter("@A_GroupID", SqlDbType.Int,4)};
            parameters[0].Value = model.A_Title;
            parameters[1].Value = model.A_Content;
            parameters[2].Value = model.A_DateTime;
            parameters[3].Value = model.A_ResponsibilityUserID;
            parameters[4].Value = model.A_Type;
            parameters[5].Value = model.A_GroupID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #10
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.MsgData model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into MsgData(");
            strSql.Append("PhoneNumber,Msg,MsgTime,IsRecivedMsg,ReciveMsgStatus,ReturnedID)");
            strSql.Append(" values (");
            strSql.Append("@PhoneNumber,@Msg,@MsgTime,@IsRecivedMsg,@ReciveMsgStatus,@ReturnedID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50),
                    new SqlParameter("@Msg", SqlDbType.NVarChar,200),
                    new SqlParameter("@MsgTime", SqlDbType.DateTime),
                    new SqlParameter("@IsRecivedMsg", SqlDbType.Bit,1),
                    new SqlParameter("@ReciveMsgStatus", SqlDbType.NVarChar,50),
                    new SqlParameter("@ReturnedID", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.PhoneNumber;
            parameters[1].Value = model.Msg;
            parameters[2].Value = model.MsgTime;
            parameters[3].Value = model.IsRecivedMsg;
            parameters[4].Value = model.ReciveMsgStatus;
            parameters[5].Value = model.ReturnedID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #11
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.Tao.CourseNotes model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Tao_CourseNotes(");
            strSql.Append("UserID,CourseID,ModuleID,Updatetime,Contents)");
            strSql.Append(" values (");
            strSql.Append("@UserID,@CourseID,@ModuleID,@Updatetime,@Contents)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@UserID", SqlDbType.Int,4),
                    new SqlParameter("@CourseID", SqlDbType.Int,4),
                    new SqlParameter("@ModuleID", SqlDbType.Int,4),
                    new SqlParameter("@Updatetime", SqlDbType.DateTime),
                    new SqlParameter("@Contents", SqlDbType.NVarChar,2000)};
            parameters[0].Value = model.UserID;
            parameters[1].Value = model.CourseID;
            parameters[2].Value = model.ModuleID;
            parameters[3].Value = model.Updatetime;
            parameters[4].Value = model.Contents;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #12
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.supervision_Info model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into supervision_Info(");
            strSql.Append("I_FindDate,I_Type,I_Content,I_ReportDate,I_ReportUserID)");
            strSql.Append(" values (");
            strSql.Append("@I_FindDate,@I_Type,@I_Content,@I_ReportDate,@I_ReportUserID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@I_FindDate", SqlDbType.DateTime),
                    new SqlParameter("@I_Type", SqlDbType.TinyInt,1),
                    new SqlParameter("@I_Content", SqlDbType.Text),
                    new SqlParameter("@I_ReportDate", SqlDbType.DateTime),
                    new SqlParameter("@I_ReportUserID", SqlDbType.Int,4)};
            parameters[0].Value = model.I_FindDate;
            parameters[1].Value = model.I_Type;
            parameters[2].Value = model.I_Content;
            parameters[3].Value = model.I_ReportDate;
            parameters[4].Value = model.I_ReportUserID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #13
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.CodeData model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into CodeData(");
            strSql.Append("Code,Remark,IsValidated,ValidatedTime,IsExchanged,ExchangeTime,PhoneNumber)");
            strSql.Append(" values (");
            strSql.Append("@Code,@Remark,@IsValidated,@ValidatedTime,@IsExchanged,@ExchangeTime,@PhoneNumber)");
            SqlParameter[] parameters = {
                    new SqlParameter("@Code", SqlDbType.NVarChar,50),
                    new SqlParameter("@Remark", SqlDbType.NVarChar,50),
                    new SqlParameter("@IsValidated", SqlDbType.Bit,1),
                    new SqlParameter("@ValidatedTime", SqlDbType.DateTime),
                    new SqlParameter("@IsExchanged", SqlDbType.Bit,1),
                    new SqlParameter("@ExchangeTime", SqlDbType.DateTime),
                    new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.Code;
            parameters[1].Value = model.Remark;
            parameters[2].Value = model.IsValidated;
            parameters[3].Value = model.ValidatedTime;
            parameters[4].Value = model.IsExchanged;
            parameters[5].Value = model.ExchangeTime;
            parameters[6].Value = model.PhoneNumber;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.T_Batch model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into T_Batch(");
            strSql.Append("name,subName,year,administratorArea,approvalAuthority,approvalNo,approvalTime,batchTypeId,totalArea,addConsArea,consArea,agriArea,arabArea,unusedArea,hasLevyArea,userId,createTime,isSubmited,isDeleted,des)");
            strSql.Append(" values (");
            strSql.Append("@name,@subName,@year,@administratorArea,@approvalAuthority,@approvalNo,@approvalTime,@batchTypeId,@totalArea,@addConsArea,@consArea,@agriArea,@arabArea,@unusedArea,@hasLevyArea,@userId,@createTime,@isSubmited,@isDeleted,@des)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@name", SqlDbType.VarChar,50),
                    new SqlParameter("@subName", SqlDbType.VarChar,50),
                    new SqlParameter("@year", SqlDbType.VarChar,50),
                    new SqlParameter("@administratorArea", SqlDbType.VarChar,50),
                    new SqlParameter("@approvalAuthority", SqlDbType.VarChar,50),
                    new SqlParameter("@approvalNo", SqlDbType.VarChar,50),
                    new SqlParameter("@approvalTime", SqlDbType.Date,3),
                    new SqlParameter("@batchTypeId", SqlDbType.Int,4),
                    new SqlParameter("@totalArea", SqlDbType.Decimal,9),
                    new SqlParameter("@addConsArea", SqlDbType.Decimal,9),
                    new SqlParameter("@consArea", SqlDbType.Decimal,9),
                    new SqlParameter("@agriArea", SqlDbType.Decimal,9),
                    new SqlParameter("@arabArea", SqlDbType.Decimal,9),
                    new SqlParameter("@unusedArea", SqlDbType.Decimal,9),
                    new SqlParameter("@hasLevyArea", SqlDbType.Decimal,9),
                    new SqlParameter("@userId", SqlDbType.Int,4),
                    new SqlParameter("@createTime", SqlDbType.DateTime),
                    new SqlParameter("@isSubmited", SqlDbType.Int,4),
                    new SqlParameter("@isDeleted", SqlDbType.Int,4),
                    new SqlParameter("@des", SqlDbType.Text)};
            parameters[0].Value = model.name;
            parameters[1].Value = model.subName;
            parameters[2].Value = model.year;
            parameters[3].Value = model.administratorArea;
            parameters[4].Value = model.approvalAuthority;
            parameters[5].Value = model.approvalNo;
            parameters[6].Value = model.approvalTime;
            parameters[7].Value = model.batchTypeId;
            parameters[8].Value = model.totalArea;
            parameters[9].Value = model.addConsArea;
            parameters[10].Value = model.consArea;
            parameters[11].Value = model.agriArea;
            parameters[12].Value = model.arabArea;
            parameters[13].Value = model.unusedArea;
            parameters[14].Value = model.hasLevyArea;
            parameters[15].Value = model.userId;
            parameters[16].Value = model.createTime;
            parameters[17].Value = model.isSubmited;
            parameters[18].Value = model.isDeleted;
            parameters[19].Value = model.des;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #15
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.sys_RolePermission model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into sys_RolePermission(");
            strSql.Append("P_RoleID,P_ApplicationID,P_PageCode,P_Value)");
            strSql.Append(" values (");
            strSql.Append("@P_RoleID,@P_ApplicationID,@P_PageCode,@P_Value)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@P_RoleID", SqlDbType.Int,4),
                    new SqlParameter("@P_ApplicationID", SqlDbType.Int,4),
                    new SqlParameter("@P_PageCode", SqlDbType.VarChar,20),
                    new SqlParameter("@P_Value", SqlDbType.Int,4)};
            parameters[0].Value = model.P_RoleID;
            parameters[1].Value = model.P_ApplicationID;
            parameters[2].Value = model.P_PageCode;
            parameters[3].Value = model.P_Value;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #16
0
 public int Add(Maticsoft.Model.Members.UserInvite model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Accounts_UserInvite(");
     builder.Append("UserId,UserNick,InviteUserId,InviteNick,IsRebate,IsNew,CreatedDate,Remark,RebateDesc)");
     builder.Append(" values (");
     builder.Append("@UserId,@UserNick,@InviteUserId,@InviteNick,@IsRebate,@IsNew,@CreatedDate,@Remark,@RebateDesc)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserNick", SqlDbType.NVarChar, 200), new SqlParameter("@InviteUserId", SqlDbType.Int, 4), new SqlParameter("@InviteNick", SqlDbType.NVarChar, 200), new SqlParameter("@IsRebate", SqlDbType.Bit, 1), new SqlParameter("@IsNew", SqlDbType.Bit, 1), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.NVarChar, -1), new SqlParameter("@RebateDesc", SqlDbType.NVarChar, 200) };
     cmdParms[0].Value = model.UserId;
     cmdParms[1].Value = model.UserNick;
     cmdParms[2].Value = model.InviteUserId;
     cmdParms[3].Value = model.InviteNick;
     cmdParms[4].Value = model.IsRebate;
     cmdParms[5].Value = model.IsNew;
     cmdParms[6].Value = model.CreatedDate;
     cmdParms[7].Value = model.Remark;
     cmdParms[8].Value = model.RebateDesc;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #17
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.tsuhan_scgl_cplx model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into tsuhan_scgl_cplx(");
            strSql.Append("产品类型,录入员,录入时间)");
            strSql.Append(" values (");
            strSql.Append("@产品类型,@录入员,@录入时间)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@产品类型", SqlDbType.VarChar,100),
                    new SqlParameter("@录入员", SqlDbType.VarChar,50),
                    new SqlParameter("@录入时间", SqlDbType.DateTime)};
            parameters[0].Value = model.产品类型;
            parameters[1].Value = model.录入员;
            parameters[2].Value = model.录入时间;

            object obj = dbhelper3.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.T_Menu model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Menu(");
            strSql.Append("name,url,icon,description,pid,isDeleted,_sort)");
            strSql.Append(" values (");
            strSql.Append("@name,@url,@icon,@description,@pid,@isDeleted,@_sort)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@name", SqlDbType.VarChar,40),
                    new SqlParameter("@url", SqlDbType.VarChar,200),
                    new SqlParameter("@icon", SqlDbType.VarChar,30),
                    new SqlParameter("@description", SqlDbType.VarChar,200),
                    new SqlParameter("@pid", SqlDbType.Int,4),
                    new SqlParameter("@isDeleted", SqlDbType.Int,4),
                    new SqlParameter("@_sort", SqlDbType.Int,4)};
            parameters[0].Value = model.name;
            parameters[1].Value = model.url;
            parameters[2].Value = model.icon;
            parameters[3].Value = model.description;
            parameters[4].Value = model.pid;
            parameters[5].Value = model.isDeleted;
            parameters[6].Value = model._sort;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #19
0
 public int Add(Maticsoft.Model.Shop.Products.ProductImage model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("INSERT INTO Shop_ProductImages(");
     builder.Append("ProductId,ImageUrl,ThumbnailUrl1,ThumbnailUrl2,ThumbnailUrl3,ThumbnailUrl4,ThumbnailUrl5,ThumbnailUrl6,ThumbnailUrl7,ThumbnailUrl8)");
     builder.Append(" VALUES (");
     builder.Append("@ProductId,@ImageUrl,@ThumbnailUrl1,@ThumbnailUrl2,@ThumbnailUrl3,@ThumbnailUrl4,@ThumbnailUrl5,@ThumbnailUrl6,@ThumbnailUrl7,@ThumbnailUrl8)");
     builder.Append(";SELECT @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProductId", SqlDbType.BigInt, 8), new SqlParameter("@ImageUrl", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl1", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl2", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl3", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl4", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl5", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl6", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl7", SqlDbType.NVarChar, 0xff), new SqlParameter("@ThumbnailUrl8", SqlDbType.NVarChar, 0xff) };
     cmdParms[0].Value = model.ProductId;
     cmdParms[1].Value = model.ImageUrl;
     cmdParms[2].Value = model.ThumbnailUrl1;
     cmdParms[3].Value = model.ThumbnailUrl2;
     cmdParms[4].Value = model.ThumbnailUrl3;
     cmdParms[5].Value = model.ThumbnailUrl4;
     cmdParms[6].Value = model.ThumbnailUrl5;
     cmdParms[7].Value = model.ThumbnailUrl6;
     cmdParms[8].Value = model.ThumbnailUrl7;
     cmdParms[9].Value = model.ThumbnailUrl8;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #20
0
 public bool CreateCategory(Maticsoft.Model.Shop.Products.CategoryInfo model)
 {
     Maticsoft.Model.Shop.Products.CategoryInfo info = this.GetModel(model.ParentCategoryId);
     if (info != null)
     {
         model.Depth = info.Depth + 1;
     }
     else
     {
         model.Depth = 1;
     }
     model.DisplaySequence = this.GetMaxSeqByCid(model.ParentCategoryId) + 1;
     model.Path = "";
     model.CategoryId = this.dal.Add(model);
     if (model.CategoryId <= 0)
     {
         return false;
     }
     if (info != null)
     {
         this.UpdateHasChild(info.CategoryId);
         model.Path = info.Path + "|" + model.CategoryId;
     }
     else
     {
         model.Path = model.CategoryId.ToString();
     }
     return this.dal.UpdatePath(model);
 }
Example #21
0
 public int Add(Maticsoft.Model.Members.UserRank model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Accounts_UserRank(");
     builder.Append("Name,Description,PointMax,PointMin,IsDefault,RankType,NumberOfMemberRanks,IsMemberCreated,CreatorUserId,PriceType,PriceOperations,PriceValue)");
     builder.Append(" values (");
     builder.Append("@Name,@Description,@PointMax,@PointMin,@IsDefault,@RankType,@NumberOfMemberRanks,@IsMemberCreated,@CreatorUserId,@PriceType,@PriceOperations,@PriceValue)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@PointMax", SqlDbType.Int, 4), new SqlParameter("@PointMin", SqlDbType.Int, 4), new SqlParameter("@IsDefault", SqlDbType.Bit, 1), new SqlParameter("@RankType", SqlDbType.Int, 4), new SqlParameter("@NumberOfMemberRanks", SqlDbType.Int, 4), new SqlParameter("@IsMemberCreated", SqlDbType.Bit, 1), new SqlParameter("@CreatorUserId", SqlDbType.Int, 4), new SqlParameter("@PriceType", SqlDbType.NVarChar, 20), new SqlParameter("@PriceOperations", SqlDbType.NVarChar, 10), new SqlParameter("@PriceValue", SqlDbType.Money, 8) };
     cmdParms[0].Value = model.Name;
     cmdParms[1].Value = model.Description;
     cmdParms[2].Value = model.PointMax;
     cmdParms[3].Value = model.PointMin;
     cmdParms[4].Value = model.IsDefault;
     cmdParms[5].Value = model.RankType;
     cmdParms[6].Value = model.NumberOfMemberRanks;
     cmdParms[7].Value = model.IsMemberCreated;
     cmdParms[8].Value = model.CreatorUserId;
     cmdParms[9].Value = model.PriceType;
     cmdParms[10].Value = model.PriceOperations;
     cmdParms[11].Value = model.PriceValue;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #22
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.A_Area model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into A_Area(");
            strSql.Append("AreaID,AreaName,Sort)");
            strSql.Append(" values (");
            strSql.Append("SQL2012AreaID,SQL2012AreaName,SQL2012Sort)");
            SqlParameter[] parameters = {
                    new SqlParameter("SQL2012AreaID", SqlDbType.Int,4),
                    new SqlParameter("SQL2012AreaName", SqlDbType.NVarChar,30),
                    new SqlParameter("SQL2012Sort", SqlDbType.Int,4)};
            parameters[0].Value = model.AreaID;
            parameters[1].Value = model.AreaName;
            parameters[2].Value = model.Sort;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #23
0
 public int Add(Maticsoft.Model.SNS.StarRank model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into SNS_StarRank(");
     builder.Append("UserId,UserGravatar,TypeId,NickName,IsRecommend,Sequence,TimeUnit,StartDate,EndDate,CreatedDate,RankDate,Status,RankType)");
     builder.Append(" values (");
     builder.Append("@UserId,@UserGravatar,@TypeId,@NickName,@IsRecommend,@Sequence,@TimeUnit,@StartDate,@EndDate,@CreatedDate,@RankDate,@Status,@RankType)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserGravatar", SqlDbType.NVarChar, 200), new SqlParameter("@TypeId", SqlDbType.Int, 4), new SqlParameter("@NickName", SqlDbType.NVarChar, 50), new SqlParameter("@IsRecommend", SqlDbType.Bit, 1), new SqlParameter("@Sequence", SqlDbType.Int, 4), new SqlParameter("@TimeUnit", SqlDbType.Int, 4), new SqlParameter("@StartDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@RankDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@RankType", SqlDbType.Int, 4) };
     cmdParms[0].Value = model.UserId;
     cmdParms[1].Value = model.UserGravatar;
     cmdParms[2].Value = model.TypeId;
     cmdParms[3].Value = model.NickName;
     cmdParms[4].Value = model.IsRecommend;
     cmdParms[5].Value = model.Sequence;
     cmdParms[6].Value = model.TimeUnit;
     cmdParms[7].Value = model.StartDate;
     cmdParms[8].Value = model.EndDate;
     cmdParms[9].Value = model.CreatedDate;
     cmdParms[10].Value = model.RankDate;
     cmdParms[11].Value = model.Status;
     cmdParms[12].Value = model.RankType;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #24
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.userfun model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into userfun(");
            strSql.Append("funid,funno,funname,fatherid)");
            strSql.Append(" values (");
            strSql.Append("@funid,@funno,@funname,@fatherid)");
            SqlParameter[] parameters = {
                    new SqlParameter("@funid", SqlDbType.Int,4),
                    new SqlParameter("@funno", SqlDbType.VarChar,200),
                    new SqlParameter("@funname", SqlDbType.VarChar,100),
                    new SqlParameter("@fatherid", SqlDbType.Int,4)};
            parameters[0].Value = model.funid;
            parameters[1].Value = model.funno;
            parameters[2].Value = model.funname;
            parameters[3].Value = model.fatherid;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #25
0
 public bool Add(Maticsoft.Model.Shop.Coupon.CouponInfo model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Shop_CouponInfo(");
     builder.Append("CouponCode,CategoryId,ClassId,SupplierId,RuleId,CouponName,CouponPwd,UserId,UserEmail,Status,CouponPrice,LimitPrice,NeedPoint,IsPwd,IsReuse,StartDate,EndDate,GenerateTime,UsedDate)");
     builder.Append(" values (");
     builder.Append("@CouponCode,@CategoryId,@ClassId,@SupplierId,@RuleId,@CouponName,@CouponPwd,@UserId,@UserEmail,@Status,@CouponPrice,@LimitPrice,@NeedPoint,@IsPwd,@IsReuse,@StartDate,@EndDate,@GenerateTime,@UsedDate)");
     SqlParameter[] cmdParms = new SqlParameter[] { 
         new SqlParameter("@CouponCode", SqlDbType.NVarChar, 200), new SqlParameter("@CategoryId", SqlDbType.Int, 4), new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@SupplierId", SqlDbType.Int, 4), new SqlParameter("@RuleId", SqlDbType.Int, 4), new SqlParameter("@CouponName", SqlDbType.NVarChar, 200), new SqlParameter("@CouponPwd", SqlDbType.NVarChar, 200), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserEmail", SqlDbType.NVarChar, 200), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CouponPrice", SqlDbType.Money, 8), new SqlParameter("@LimitPrice", SqlDbType.Money, 8), new SqlParameter("@NeedPoint", SqlDbType.Int, 4), new SqlParameter("@IsPwd", SqlDbType.Int, 4), new SqlParameter("@IsReuse", SqlDbType.Int, 4), new SqlParameter("@StartDate", SqlDbType.DateTime), 
         new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@GenerateTime", SqlDbType.DateTime), new SqlParameter("@UsedDate", SqlDbType.DateTime)
      };
     cmdParms[0].Value = model.CouponCode;
     cmdParms[1].Value = model.CategoryId;
     cmdParms[2].Value = model.ClassId;
     cmdParms[3].Value = model.SupplierId;
     cmdParms[4].Value = model.RuleId;
     cmdParms[5].Value = model.CouponName;
     cmdParms[6].Value = model.CouponPwd;
     cmdParms[7].Value = model.UserId;
     cmdParms[8].Value = model.UserEmail;
     cmdParms[9].Value = model.Status;
     cmdParms[10].Value = model.CouponPrice;
     cmdParms[11].Value = model.LimitPrice;
     cmdParms[12].Value = model.NeedPoint;
     cmdParms[13].Value = model.IsPwd;
     cmdParms[14].Value = model.IsReuse;
     cmdParms[15].Value = model.StartDate;
     cmdParms[0x10].Value = model.EndDate;
     cmdParms[0x11].Value = model.GenerateTime;
     cmdParms[0x12].Value = model.UsedDate;
     return (DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
 }
Example #26
0
 public void CreateHtml(string temPath, Maticsoft.Model.CMS.Content model, string createPath)
 {
     string str = string.Empty;
     string str2 = string.Empty;
     try
     {
         str2 = HttpContext.Current.Server.MapPath(createPath);
         StreamReader reader = new StreamReader(System.IO.File.Open(HttpContext.Current.Server.MapPath(temPath), FileMode.Open, FileAccess.Read), Encoding.GetEncoding("utf-8"));
         StringBuilder builder = new StringBuilder(reader.ReadToEnd());
         reader.Close();
         reader.Dispose();
         string str4 = builder.ToString().Replace("$id$", model.ContentID.ToString()).Replace("$content$", model.Description);
         this.CreatFolder(createPath);
         str = "ContentDetail-" + model.ContentID + ".html";
         StreamWriter writer = new StreamWriter(System.IO.File.Create(str2 + "/" + str), Encoding.GetEncoding("utf-8"));
         writer.Write(str4);
         writer.Flush();
         writer.Close();
         writer.Dispose();
     }
     catch (Exception)
     {
         throw;
     }
 }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.StoreSpecialTag model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into StoreSpecialTag(");
            strSql.Append("StoreSpecialTagID,BizID,SpecialTagID,TagName)");
            strSql.Append(" values (");
            strSql.Append("@StoreSpecialTagID,@BizID,@SpecialTagID,@TagName)");
            SqlParameter[] parameters = {
                    new SqlParameter("@StoreSpecialTagID", SqlDbType.NVarChar,50),
                    new SqlParameter("@BizID", SqlDbType.NVarChar,50),
                    new SqlParameter("@SpecialTagID", SqlDbType.NVarChar,50),
                    new SqlParameter("@TagName", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.StoreSpecialTagID;
            parameters[1].Value = model.BizID;
            parameters[2].Value = model.SpecialTagID;
            parameters[3].Value = model.TagName;

            int rows = ServerDbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #28
0
 public int Add(Maticsoft.TimerTask.Model.TaskTimer model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into Ms_TaskTimers(");
     builder.Append("ExecuteType,IsSingle,Interval,ExecuteTime,ExecuteNumber,Param1,Param2,Param3,Param4,Param5,Param6,Param7,Param8,Param9,Param10)");
     builder.Append(" values (");
     builder.Append("@ExecuteType,@IsSingle,@Interval,@ExecuteTime,@ExecuteNumber,@Param1,@Param2,@Param3,@Param4,@Param5,@Param6,@Param7,@Param8,@Param9,@Param10)");
     builder.Append(";select @@IDENTITY");
     SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ExecuteType", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@IsSingle", SqlDbType.Bit, 1), new SqlParameter("@Interval", SqlDbType.Decimal, 9), new SqlParameter("@ExecuteTime", SqlDbType.DateTime), new SqlParameter("@ExecuteNumber", SqlDbType.Int, 4), new SqlParameter("@Param1", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param2", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param3", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param4", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param5", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param6", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param7", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param8", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param9", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Param10", SqlDbType.NVarChar, 0xfa0) };
     cmdParms[0].Value = model.ExecuteType;
     cmdParms[1].Value = model.IsSingle;
     cmdParms[2].Value = model.Interval;
     cmdParms[3].Value = model.ExecuteTime;
     cmdParms[4].Value = model.ExecuteNumber;
     cmdParms[5].Value = model.Param1;
     cmdParms[6].Value = model.Param2;
     cmdParms[7].Value = model.Param3;
     cmdParms[8].Value = model.Param4;
     cmdParms[9].Value = model.Param5;
     cmdParms[10].Value = model.Param6;
     cmdParms[11].Value = model.Param7;
     cmdParms[12].Value = model.Param8;
     cmdParms[13].Value = model.Param9;
     cmdParms[14].Value = model.Param10;
     object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
     if (single == null)
     {
         return 0;
     }
     return Convert.ToInt32(single);
 }
Example #29
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.record_FimaryProblem model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into record_FimaryProblem(");
            strSql.Append("F_FimaryCode,F_RecordTime,F_StartTime,F_endTime,F_OverviewProblem,F_DetailProblem,F_FillingUserID)");
            strSql.Append(" values (");
            strSql.Append("@F_FimaryCode,@F_RecordTime,@F_StartTime,@F_endTime,@F_OverviewProblem,@F_DetailProblem,@F_FillingUserID)");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_FimaryCode", SqlDbType.VarChar,30),
                    new SqlParameter("@F_RecordTime", SqlDbType.DateTime),
                    new SqlParameter("@F_StartTime", SqlDbType.DateTime),
                    new SqlParameter("@F_endTime", SqlDbType.DateTime),
                    new SqlParameter("@F_OverviewProblem", SqlDbType.NVarChar,255),
                    new SqlParameter("@F_DetailProblem", SqlDbType.Text),
                    new SqlParameter("@F_FillingUserID", SqlDbType.Int,4)};
            parameters[0].Value = model.F_FimaryCode;
            parameters[1].Value = model.F_RecordTime;
            parameters[2].Value = model.F_StartTime;
            parameters[3].Value = model.F_endTime;
            parameters[4].Value = model.F_OverviewProblem;
            parameters[5].Value = model.F_DetailProblem;
            parameters[6].Value = model.F_FillingUserID;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #30
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.W_Material model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into W_Material(");
            strSql.Append("Name,Begindate,Enddate,Number,Address)");
            strSql.Append(" values (");
            strSql.Append("@Name,@Begindate,@Enddate,@Number,@Address)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@Name", SqlDbType.NVarChar,100),
					new SqlParameter("@Begindate", SqlDbType.DateTime),
					new SqlParameter("@Enddate", SqlDbType.DateTime),
					new SqlParameter("@Number", SqlDbType.VarChar,150),
					new SqlParameter("@Address", SqlDbType.VarChar,150)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.Begindate;
            parameters[2].Value = model.Enddate;
            parameters[3].Value = model.Number;
            parameters[4].Value = model.Address;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }