C# Maticsoft类代码示例

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

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

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

示例16: Add

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

开发者ID:huaminglee，项目名称:myyyyshop，代码行数:25，代码来源:UserInvite.cs

示例17: Add

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

开发者ID:553406268，项目名称:abctest，代码行数:29，代码来源:ChanPxhDAL.cs

示例18: Add

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

开发者ID:samjustin8231，项目名称:LandAndResourcesBureauSys，代码行数:37，代码来源:T_Menu.cs

示例19: Add

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

开发者ID:huaminglee，项目名称:myyyyshop，代码行数:26，代码来源:ProductImage.cs

示例20: CreateCategory

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

开发者ID:huaminglee，项目名称:myyyyshop，代码行数:29，代码来源:CategoryInfo.cs

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

鲜花

握手

雷人

路过

鸡蛋

该文章已有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# Matrix类代码示例发布时间：2022-05-24

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

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

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

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

阅读：18101|2023-10-27

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

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

阅读：9618|2022-11-06

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

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

阅读：8153|2022-11-06

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

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

阅读：8531|2022-11-06

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

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

阅读：8433|2022-11-06

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

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

阅读：9347|2022-11-06

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

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

阅读：8397|2022-11-06

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

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

阅读：7834|2022-11-06

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

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

阅读：8387|2022-11-06

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

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

阅读：7380|2022-11-06

客服电话

电子邮件

C# Maticsoft类代码示例

示例1: Update

示例2: AddEx

示例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: Add

示例19: Add

示例20: CreateCategory

请发表评论

全部评论

上一篇：

下一篇：

PacktPublishing/Python-Machine-Learning-

BentoBoxWorld/AOneBlock: A OneBlock Mine

鲁东大学一米网:Win7系统USB驱动器RAM的操

manur/MATLAB-git: A thin MATLAB wrapper

Matlab中点乘和乘的区别

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

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

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053