当前位置: 首页>>代码示例>>C#>>正文


C# Maticsoft类代码示例

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


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

示例1: Update

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Maticsoft.Model.W_Material model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update W_Material set ");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]");
           
            strSql.Append(" where [email protected] ");
            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);
        }
开发者ID:tianyaalone,项目名称:Water125,代码行数:32,代码来源:W_Material.cs

示例2: AddEx

 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 [email protected]");
     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;
 }
开发者ID:huaminglee,项目名称:myyyyshop,代码行数:31,代码来源:UserAlbumDetail.cs

示例3: Add

 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);
 }
开发者ID:huaminglee,项目名称:myyyyshop,代码行数:26,代码来源:Theme.cs

示例4: Add

        /// <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);
            }
        }
开发者ID:kevlens,项目名称:kfsmanager,代码行数:29,代码来源:rolefun.cs

示例5: Add

        /// <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;
            }
        }
开发者ID:key-value,项目名称:CollectionApplication,代码行数:30,代码来源:District.cs

示例6: Add

        /// <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);
            }
        }
开发者ID:hezejiang,项目名称:EHR,代码行数:31,代码来源:sys_Applications.cs

示例7: Add

        /// <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);
            }
        }
开发者ID:hezejiang,项目名称:EHR2,代码行数:33,代码来源:education_Prescription.cs

示例8: Add

 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);
 }
开发者ID:huaminglee,项目名称:myyyyshop,代码行数:29,代码来源:ProductReviews.cs

示例9: Add

        /// <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);
            }
        }
开发者ID:hezejiang,项目名称:EHR,代码行数:35,代码来源:AR_Announcement.cs

示例10: Add

        /// <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);
            }
        }
开发者ID:chanhan,项目名称:Project,代码行数:35,代码来源:MsgData.cs

示例11: Add

        /// <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);
            }
        }
开发者ID:bookxiao,项目名称:orisoft,代码行数:33,代码来源:CourseNotes.cs

示例12: Add

        /// <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);
            }
        }
开发者ID:hezejiang,项目名称:EHR2,代码行数:33,代码来源:supervision_Info.cs

示例13: Add

        /// <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;
            }
        }
开发者ID:chanhan,项目名称:Project,代码行数:36,代码来源:CodeData.cs

示例14: Add

        /// <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);
            }
        }
开发者ID:samjustin8231,项目名称:LandAndResourcesBureauSys,代码行数:63,代码来源:T_Batch.cs

示例15: Add

        /// <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);
            }
        }
开发者ID:hezejiang,项目名称:EHR,代码行数:31,代码来源:sys_RolePermission.cs


注:本文中的Maticsoft类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。