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