public bool AddEx(Maticsoft.Model.SNS.GroupTopicFav model) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("insert into SNS_GroupTopicFav("); builder.Append("CreatedUserID,CreatedDate,TopicID,Tags,Remark)"); builder.Append(" values ("); builder.Append("@CreatedUserID,@CreatedDate,@TopicID,@Tags,@Remark)"); builder.Append(";select @@IDENTITY"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@TopicID", SqlDbType.Int, 4), new SqlParameter("@Tags", SqlDbType.NVarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 100) }; para[0].Value = model.CreatedUserID; para[1].Value = model.CreatedDate; para[2].Value = model.TopicID; para[3].Value = model.Tags; para[4].Value = model.Remark; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("update Accounts_UsersExp set FavTopicCount=FavTopicCount-1"); builder2.Append(" where UserID=@UserID "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameterArray2[0].Value = model.CreatedUserID; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool AddEx(Maticsoft.Model.SNS.GroupUsers model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SNS_GroupUsers("); builder.Append("GroupID,UserID,NickName,JoinTime,Role,ApplyReason,IsRecommend,Sequence,Status)"); builder.Append(" values ("); builder.Append("@GroupID,@UserID,@NickName,@JoinTime,@Role,@ApplyReason,@IsRecommend,@Sequence,@Status)"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@GroupID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@NickName", SqlDbType.NVarChar, 50), new SqlParameter("@JoinTime", SqlDbType.DateTime), new SqlParameter("@Role", SqlDbType.Int, 4), new SqlParameter("@ApplyReason", SqlDbType.NVarChar), new SqlParameter("@IsRecommend", SqlDbType.Bit, 1), new SqlParameter("@Sequence", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4) }; para[0].Value = model.GroupID; para[1].Value = model.UserID; para[2].Value = model.NickName; para[3].Value = model.JoinTime; para[4].Value = model.Role; para[5].Value = model.ApplyReason; para[6].Value = model.IsRecommend; para[7].Value = model.Sequence; para[8].Value = model.Status; List<CommandInfo> cmdList = new List<CommandInfo>(); CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("Update SNS_Groups "); builder2.Append(" Set GroupUserCount=GroupUserCount+1 "); builder2.Append(" where GroupID=@GroupID"); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@GroupID", SqlDbType.Int, 4) }; parameterArray2[0].Value = model.GroupID; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public int AddEx(Maticsoft.Model.CMS.Comment model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into CMS_Comment("); builder.Append("ContentId,Description,CreatedDate,CreatedUserID,ReplyCount,ParentID,TypeID,State,IsRead,CreatedNickName)"); builder.Append(" values ("); builder.Append("@ContentId,@Description,@CreatedDate,@CreatedUserID,@ReplyCount,@ParentID,@TypeID,@State,@IsRead,@CreatedNickName)"); builder.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ContentId", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.Text), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@ReplyCount", SqlDbType.Int, 4), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@TypeID", SqlDbType.SmallInt, 2), new SqlParameter("@State", SqlDbType.Bit, 1), new SqlParameter("@IsRead", SqlDbType.Bit, 1), new SqlParameter("@CreatedNickName", SqlDbType.NVarChar, 200), new SqlParameter("@ReturnValue", SqlDbType.Int) }; para[0].Value = model.ContentId; para[1].Value = model.Description; para[2].Value = model.CreatedDate; para[3].Value = model.CreatedUserID; para[4].Value = model.ReplyCount; para[5].Value = model.ParentID; para[6].Value = model.TypeID; para[7].Value = model.State; para[8].Value = model.IsRead; para[9].Value = model.CreatedNickName; para[10].Direction = ParameterDirection.Output; List<CommandInfo> cmdList = new List<CommandInfo>(); CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("Update CMS_Content "); builder2.Append(" Set TotalComment=TotalComment+1 "); builder2.Append(" where ContentID=@ContentID "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@ContentID", SqlDbType.Int, 4) }; parameterArray2[0].Value = model.ContentId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); DbHelperSQL.ExecuteSqlTran(cmdList); return (int) para[10].Value; }
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; }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public bool Add(ResolveResXml.Model.res_project model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into res_project("); strSql.Append("id,project_Name,project_CountryCode)"); strSql.Append(" values ("); strSql.Append("@id,@project_Name,@project_CountryCode)"); SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32,8), new SQLiteParameter("@project_Name", DbType.String), new SQLiteParameter("@project_CountryCode", DbType.String)}; parameters[0].Value = model.id; parameters[1].Value = model.project_Name; parameters[2].Value = model.project_CountryCode; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; foreach (ResolveResXml.Model.res_XML models in model.res_XMLs) { strSql2=new StringBuilder(); strSql2.Append("insert into res_XML("); strSql2.Append("id,key,value,projectId)"); strSql2.Append(" values ("); strSql2.Append("@id,@key,@value,@projectId)"); SQLiteParameter[] parameters2 = { new SQLiteParameter("@id", DbType.Int32,8), new SQLiteParameter("@key", DbType.String), new SQLiteParameter("@value", DbType.String), new SQLiteParameter("@projectId", DbType.Int32,4)}; parameters2[0].Value = models.id; parameters2[1].Value = models.key; parameters2[2].Value = models.value; parameters2[3].Value = models.projectId; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } int result= DbHelperSQLite.ExecuteSqlTran(sqllist); if (result > 0) { return true; } else { return false; } }
public bool CancelOrder(OrderInfo orderInfo, User currentUser = new User()) { List<CommandInfo> cmdList = new List<CommandInfo>(); if ((orderInfo.OrderItems != null) && (orderInfo.OrderItems.Count > 0)) { foreach (Maticsoft.Model.Shop.Order.OrderItems items in orderInfo.OrderItems) { StringBuilder builder = new StringBuilder(); builder.Append("update Shop_SKUs set Stock=Stock+@Stock"); builder.Append(" where SKU=@SKU"); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@SKU", SqlDbType.NVarChar, 50), new SqlParameter("@Stock", SqlDbType.Int, 4) }; parameterArray[0].Value = items.SKU; parameterArray[1].Value = items.Quantity; cmdList.Add(new CommandInfo(builder.ToString(), parameterArray)); } } StringBuilder builder2 = new StringBuilder(); builder2.Append("UPDATE Shop_Orders SET OrderStatus=-1, UpdatedDate=@UpdatedDate"); builder2.Append(" where OrderId=@OrderId OR ParentOrderId=@OrderId"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@OrderId", SqlDbType.BigInt, 8), new SqlParameter("@UpdatedDate", SqlDbType.DateTime) }; para[0].Value = orderInfo.OrderId; para[1].Value = DateTime.Now; CommandInfo item = new CommandInfo(builder2.ToString(), para, EffentNextType.ExcuteEffectRows); cmdList.Add(item); StringBuilder builder3 = new StringBuilder(); builder3.Append("insert into Shop_OrderAction("); builder3.Append("OrderId,OrderCode,UserId,Username,ActionCode,ActionDate,Remark)"); builder3.Append(" values ("); builder3.Append("@OrderId,@OrderCode,@UserId,@Username,@ActionCode,@ActionDate,@Remark)"); SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@OrderId", SqlDbType.BigInt, 8), new SqlParameter("@OrderCode", SqlDbType.NVarChar, 50), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Username", SqlDbType.NVarChar, 200), new SqlParameter("@ActionCode", SqlDbType.NVarChar, 100), new SqlParameter("@ActionDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.NVarChar, 0x3e8) }; parameterArray3[0].Value = orderInfo.OrderId; parameterArray3[1].Value = orderInfo.OrderCode; parameterArray3[2].Value = (currentUser != null) ? currentUser.UserID : orderInfo.BuyerID; parameterArray3[3].Value = (currentUser != null) ? currentUser.NickName : orderInfo.BuyerName; parameterArray3[4].Value = 0x65; parameterArray3[5].Value = DateTime.Now; if ((currentUser != null) && (currentUser.UserType == "AA")) { parameterArray3[6].Value = "管理员取消订单"; } else { parameterArray3[6].Value = "取消订单"; } item = new CommandInfo(builder3.ToString(), parameterArray3, EffentNextType.ExcuteEffectRows); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool AddHistory(Maticsoft.Model.Shop.Coupon.CouponInfo model) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("insert into Shop_CouponHistory("); 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[] para = 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) }; para[0].Value = model.CouponCode; para[1].Value = model.CategoryId; para[2].Value = model.ClassId; para[3].Value = model.SupplierId; para[4].Value = model.RuleId; para[5].Value = model.CouponName; para[6].Value = model.CouponPwd; para[7].Value = model.UserId; para[8].Value = model.UserEmail; para[9].Value = model.Status; para[10].Value = model.CouponPrice; para[11].Value = model.LimitPrice; para[12].Value = model.NeedPoint; para[13].Value = model.IsPwd; para[14].Value = model.IsReuse; para[15].Value = model.StartDate; para[0x10].Value = model.EndDate; para[0x11].Value = model.GenerateTime; para[0x12].Value = model.UsedDate; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from Shop_CouponInfo "); builder2.Append(" where CouponCode=@CouponCode "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@CouponCode", SqlDbType.NVarChar, 200) }; parameterArray2[0].Value = model.CouponCode; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool DeleteEX(int PointsLimitID) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from Accounts_PointsLimit "); builder.Append(" where PointsLimitID=@PointsLimitID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PointsLimitID", SqlDbType.Int, 4) }; para[0].Value = PointsLimitID; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("UPDATE Accounts_PointsRule SET PointsLimitID=-1 WHERE PointsLimitID=@PointsLimitID"); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@PointsLimitID", SqlDbType.Int, 4) }; parameterArray2[0].Value = PointsLimitID; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool AddHotStarRank() { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete SNS_StarRank "); builder.Append(" where typeId=1 "); SqlParameter[] para = new SqlParameter[0]; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("insert into SNS_StarRank(UserId,UserGravatar,TypeId,NickName,Status,RankType,IsRecommend,Sequence,TimeUnit,StartDate,EndDate,CreatedDate,RankDate) "); builder2.Append(" select top 10 UserID,UserGravatar,TypeID,NickName,Status,'0','false',ROW_NUMBER() OVER( ORDER BY ID),'-1',GETDATE(),GETDATE(),GETDATE(),GETDATE() from "); builder2.Append(" (select top 10 *,FansCount=(select FansCount from Accounts_UsersExp where UserID=star.UserID) from SNS_Star star where Status=1 and TypeID=1 order by FansCount desc) temp "); SqlParameter[] parameterArray2 = new SqlParameter[0]; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEx(int userId) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from Accounts_Users "); builder.Append(" where UserID=@UserID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4) }; para[0].Value = userId; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from Accounts_UsersExp "); builder2.Append(" where UserID=@UserID "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameterArray2[0].Value = userId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool AddDetail(Maticsoft.Model.Members.PointsDetail model) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("insert into Accounts_PointsDetail("); builder.Append("RuleAction,UserID,Score,ExtData,CurrentPoints,Description,CreatedDate,Type)"); builder.Append(" values ("); builder.Append("@RuleAction,@UserID,@Score,@ExtData,0,@Description,@CreatedDate,@Type)"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RuleAction", SqlDbType.NVarChar, 200), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Score", SqlDbType.Int, 4), new SqlParameter("@ExtData", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@Type", SqlDbType.Int, 4) }; para[0].Value = model.RuleAction; para[1].Value = model.UserID; para[2].Value = model.Score; para[3].Value = model.ExtData; para[4].Value = model.Description; para[5].Value = model.CreatedDate; para[6].Value = model.Type; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("update Accounts_UsersExp set "); if (model.Type == 0) { builder2.Append("Points=Points+@Points"); } if (model.Type == 1) { builder2.Append("Points=Points-@Points"); } builder2.Append(" where UserID=@UserID "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@Points", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameterArray2[0].Value = model.Score; parameterArray2[1].Value = model.UserID; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool RunTask(Maticsoft.Model.Ms.WeiBoTaskMsg model) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("insert into Ms_WeiBoMsg("); builder.Append("WeiboMsg,ImageUrl,CreateDate,PublishDate)"); builder.Append(" values ("); builder.Append("@WeiboMsg,@ImageUrl,@CreateDate,@PublishDate)"); builder.Append(";select @@IDENTITY"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@WeiboMsg", SqlDbType.NVarChar, 200), new SqlParameter("@ImageUrl", SqlDbType.NVarChar, 300), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@PublishDate", SqlDbType.DateTime) }; para[0].Value = model.WeiboMsg; para[1].Value = model.ImageUrl; para[2].Value = model.CreateDate; para[3].Value = model.PublishDate; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from Ms_WeiBoTaskMsg "); builder2.Append(" where WeiBoTaskId=@WeiBoTaskId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@WeiBoTaskId", SqlDbType.Int, 4) }; parameterArray2[0].Value = model.WeiBoTaskId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public void ExtendReturn(LabMS.Model.Recipients model) { StringBuilder strSql1 = new StringBuilder(); strSql1.Append("update Recipients set "); strSql1.Append("ReturnTime=@ReturnTime,"); strSql1.Append("Comment=@Comment,"); strSql1.Append("ReturnState=@ReturnState"); strSql1.Append(" where Numbers=@Numbers "); SqlParameter[] parameters1 = { new SqlParameter("@ReturnTime", SqlDbType.DateTime,8), new SqlParameter("@Comment", SqlDbType.VarChar,100), new SqlParameter("@ReturnState", SqlDbType.VarChar,20), new SqlParameter("@Numbers", SqlDbType.VarChar,50) }; parameters1[0].Value = model.ReturnTime; parameters1[1].Value = model.Comment; parameters1[2].Value = model.ReturnState; parameters1[3].Value = model.Numbers; CommandInfo comd1 = new CommandInfo(); comd1.Parameters = parameters1; comd1.CommandText = strSql1.ToString(); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update InstrumentAndConsumables set "); strSql2.Append("Quantity=@Quantity"); strSql2.Append(" where Numbers=@Numbers "); SqlParameter[] parameters2 = { new SqlParameter("@Quantity", SqlDbType.Int,4), new SqlParameter("@Numbers", SqlDbType.VarChar,30) }; parameters2[0].Value = 1; parameters2[1].Value = model.Numbers; CommandInfo comd2 = new CommandInfo(); comd2.Parameters = parameters2; comd2.CommandText = strSql2.ToString(); List<CommandInfo> listcomd = new List<CommandInfo>(); listcomd.Add(comd1); listcomd.Add(comd2); try { DbHelperSQL.ExecuteSqlTran(listcomd); } catch { throw (new Exception("数据库执行错误!")); } }
public bool AddEx(UsersExpModel model, int inviteID, string inviteNick, int pointScore) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Accounts_UsersExp("); builder.Append("UserID,Gravatar,Singature,TelPhone,QQ,MSN,HomePage,Birthday,BirthdayVisible,BirthdayIndexVisible,Constellation,ConstellationVisible,ConstellationIndexVisible,NativePlace,NativePlaceVisible,NativePlaceIndexVisible,RegionId,Address,AddressVisible,AddressIndexVisible,BodilyForm,BodilyFormVisible,BodilyFormIndexVisible,BloodType,BloodTypeVisible,BloodTypeIndexVisible,Marriaged,MarriagedVisible,MarriagedIndexVisible,PersonalStatus,PersonalStatusVisible,PersonalStatusIndexVisible,Grade,Balance,Points,TopicCount,ReplyTopicCount,FavTopicCount,PvCount,FansCount,FellowCount,AblumsCount,FavouritesCount,FavoritedCount,ShareCount,ProductsCount,PersonalDomain,LastAccessTime,LastAccessIP,LastPostTime,LastLoginTime,Remark,IsUserDPI,PayAccount)"); builder.Append(" values ("); builder.Append("@UserID,@Gravatar,@Singature,@TelPhone,@QQ,@MSN,@HomePage,@Birthday,@BirthdayVisible,@BirthdayIndexVisible,@Constellation,@ConstellationVisible,@ConstellationIndexVisible,@NativePlace,@NativePlaceVisible,@NativePlaceIndexVisible,@RegionId,@Address,@AddressVisible,@AddressIndexVisible,@BodilyForm,@BodilyFormVisible,@BodilyFormIndexVisible,@BloodType,@BloodTypeVisible,@BloodTypeIndexVisible,@Marriaged,@MarriagedVisible,@MarriagedIndexVisible,@PersonalStatus,@PersonalStatusVisible,@PersonalStatusIndexVisible,@Grade,@Balance,@Points,@TopicCount,@ReplyTopicCount,@FavTopicCount,@PvCount,@FansCount,@FellowCount,@AblumsCount,@FavouritesCount,@FavoritedCount,@ShareCount,@ProductsCount,@PersonalDomain,@LastAccessTime,@LastAccessIP,@LastPostTime,@LastLoginTime,@Remark,@IsUserDPI,@PayAccount)"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Gravatar", SqlDbType.NVarChar, 200), new SqlParameter("@Singature", SqlDbType.NVarChar, 200), new SqlParameter("@TelPhone", SqlDbType.NVarChar, 20), new SqlParameter("@QQ", SqlDbType.NVarChar, 30), new SqlParameter("@MSN", SqlDbType.NVarChar, 30), new SqlParameter("@HomePage", SqlDbType.NVarChar, 50), new SqlParameter("@Birthday", SqlDbType.DateTime), new SqlParameter("@BirthdayVisible", SqlDbType.SmallInt, 2), new SqlParameter("@BirthdayIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@Constellation", SqlDbType.NVarChar, 10), new SqlParameter("@ConstellationVisible", SqlDbType.SmallInt, 2), new SqlParameter("@ConstellationIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@NativePlace", SqlDbType.NVarChar, 300), new SqlParameter("@NativePlaceVisible", SqlDbType.SmallInt, 2), new SqlParameter("@NativePlaceIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@RegionId", SqlDbType.Int, 4), new SqlParameter("@Address", SqlDbType.NVarChar, 300), new SqlParameter("@AddressVisible", SqlDbType.SmallInt, 2), new SqlParameter("@AddressIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@BodilyForm", SqlDbType.NVarChar, 10), new SqlParameter("@BodilyFormVisible", SqlDbType.SmallInt, 2), new SqlParameter("@BodilyFormIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@BloodType", SqlDbType.NVarChar, 10), new SqlParameter("@BloodTypeVisible", SqlDbType.SmallInt, 2), new SqlParameter("@BloodTypeIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@Marriaged", SqlDbType.NVarChar, 10), new SqlParameter("@MarriagedVisible", SqlDbType.SmallInt, 2), new SqlParameter("@MarriagedIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@PersonalStatus", SqlDbType.NVarChar, 10), new SqlParameter("@PersonalStatusVisible", SqlDbType.SmallInt, 2), new SqlParameter("@PersonalStatusIndexVisible", SqlDbType.Bit, 1), new SqlParameter("@Grade", SqlDbType.Int, 4), new SqlParameter("@Balance", SqlDbType.Money, 8), new SqlParameter("@Points", SqlDbType.Int, 4), new SqlParameter("@TopicCount", SqlDbType.Int, 4), new SqlParameter("@ReplyTopicCount", SqlDbType.Int, 4), new SqlParameter("@FavTopicCount", SqlDbType.Int, 4), new SqlParameter("@PvCount", SqlDbType.Int, 4), new SqlParameter("@FansCount", SqlDbType.Int, 4), new SqlParameter("@FellowCount", SqlDbType.Int, 4), new SqlParameter("@AblumsCount", SqlDbType.Int, 4), new SqlParameter("@FavouritesCount", SqlDbType.Int, 4), new SqlParameter("@FavoritedCount", SqlDbType.Int, 4), new SqlParameter("@ShareCount", SqlDbType.Int, 4), new SqlParameter("@ProductsCount", SqlDbType.Int, 4), new SqlParameter("@PersonalDomain", SqlDbType.NVarChar, 50), new SqlParameter("@LastAccessTime", SqlDbType.DateTime), new SqlParameter("@LastAccessIP", SqlDbType.NVarChar, 50), new SqlParameter("@LastPostTime", SqlDbType.DateTime), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@IsUserDPI", SqlDbType.Bit, 1), new SqlParameter("@PayAccount", SqlDbType.NVarChar, 200) }; para[0].Value = model.UserID; para[1].Value = model.Gravatar; para[2].Value = model.Singature; para[3].Value = model.TelPhone; para[4].Value = model.QQ; para[5].Value = model.MSN; para[6].Value = model.HomePage; para[7].Value = model.Birthday; para[8].Value = model.BirthdayVisible; para[9].Value = model.BirthdayIndexVisible; para[10].Value = model.Constellation; para[11].Value = model.ConstellationVisible; para[12].Value = model.ConstellationIndexVisible; para[13].Value = model.NativePlace; para[14].Value = model.NativePlaceVisible; para[15].Value = model.NativePlaceIndexVisible; para[0x10].Value = model.RegionId; para[0x11].Value = model.Address; para[0x12].Value = model.AddressVisible; para[0x13].Value = model.AddressIndexVisible; para[20].Value = model.BodilyForm; para[0x15].Value = model.BodilyFormVisible; para[0x16].Value = model.BodilyFormIndexVisible; para[0x17].Value = model.BloodType; para[0x18].Value = model.BloodTypeVisible; para[0x19].Value = model.BloodTypeIndexVisible; para[0x1a].Value = model.Marriaged; para[0x1b].Value = model.MarriagedVisible; para[0x1c].Value = model.MarriagedIndexVisible; para[0x1d].Value = model.PersonalStatus; para[30].Value = model.PersonalStatusVisible; para[0x1f].Value = model.PersonalStatusIndexVisible; para[0x20].Value = model.Grade; para[0x21].Value = model.Balance; para[0x22].Value = model.Points; para[0x23].Value = model.TopicCount; para[0x24].Value = model.ReplyTopicCount; para[0x25].Value = model.FavTopicCount; para[0x26].Value = model.PvCount; para[0x27].Value = model.FansCount; para[40].Value = model.FellowCount; para[0x29].Value = model.AblumsCount; para[0x2a].Value = model.FavouritesCount; para[0x2b].Value = model.FavoritedCount; para[0x2c].Value = model.ShareCount; para[0x2d].Value = model.ProductsCount; para[0x2e].Value = model.PersonalDomain; para[0x2f].Value = model.LastAccessTime; para[0x30].Value = model.LastAccessIP; para[0x31].Value = model.LastPostTime; para[50].Value = model.LastLoginTime; para[0x33].Value = model.Remark; para[0x34].Value = model.IsUserDPI; para[0x35].Value = model.PayAccount; List<CommandInfo> cmdList = new List<CommandInfo>(); CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("insert into Accounts_UserInvite("); builder2.Append("UserId,UserNick,InviteUserId,InviteNick,IsRebate,IsNew,CreatedDate,RebateDesc)"); builder2.Append(" values ("); builder2.Append("@UserId,@UserNick,@InviteUserId,@InviteNick,@IsRebate,@IsNew,@CreatedDate,@RebateDesc)"); builder2.Append(";select @@IDENTITY"); SqlParameter[] parameterArray2 = 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("@RebateDesc", SqlDbType.NVarChar, 200) }; parameterArray2[0].Value = model.UserID; parameterArray2[1].Value = model.NickName; parameterArray2[2].Value = inviteID; parameterArray2[3].Value = inviteNick; parameterArray2[4].Value = true; parameterArray2[5].Value = true; parameterArray2[6].Value = DateTime.Now; parameterArray2[7].Value = "邀请用户+" + pointScore + "积分"; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool UpdateShipped(OrderInfo model) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("update Shop_Orders set "); builder.Append("OrderCode=@OrderCode,"); builder.Append("ParentOrderId=@ParentOrderId,"); builder.Append("CreatedDate=@CreatedDate,"); builder.Append("UpdatedDate=@UpdatedDate,"); builder.Append("BuyerID=@BuyerID,"); builder.Append("BuyerName=@BuyerName,"); builder.Append("BuyerEmail=@BuyerEmail,"); builder.Append("BuyerCellPhone=@BuyerCellPhone,"); builder.Append("RegionId=@RegionId,"); builder.Append("ShipRegion=@ShipRegion,"); builder.Append("ShipAddress=@ShipAddress,"); builder.Append("ShipZipCode=@ShipZipCode,"); builder.Append("ShipName=@ShipName,"); builder.Append("ShipTelPhone=@ShipTelPhone,"); builder.Append("ShipCellPhone=@ShipCellPhone,"); builder.Append("ShipEmail=@ShipEmail,"); builder.Append("ShippingModeId=@ShippingModeId,"); builder.Append("ShippingModeName=@ShippingModeName,"); builder.Append("RealShippingModeId=@RealShippingModeId,"); builder.Append("RealShippingModeName=@RealShippingModeName,"); builder.Append("ShipperId=@ShipperId,"); builder.Append("ShipperName=@ShipperName,"); builder.Append("ShipperAddress=@ShipperAddress,"); builder.Append("ShipperCellPhone=@ShipperCellPhone,"); builder.Append("Freight=@Freight,"); builder.Append("FreightAdjusted=@FreightAdjusted,"); builder.Append("FreightActual=@FreightActual,"); builder.Append("Weight=@Weight,"); builder.Append("ShippingStatus=@ShippingStatus,"); builder.Append("ShipOrderNumber=@ShipOrderNumber,"); builder.Append("ExpressCompanyName=@ExpressCompanyName,"); builder.Append("ExpressCompanyAbb=@ExpressCompanyAbb,"); builder.Append("PaymentTypeId=@PaymentTypeId,"); builder.Append("PaymentTypeName=@PaymentTypeName,"); builder.Append("PaymentGateway=@PaymentGateway,"); builder.Append("PaymentStatus=@PaymentStatus,"); builder.Append("RefundStatus=@RefundStatus,"); builder.Append("PayCurrencyCode=@PayCurrencyCode,"); builder.Append("PayCurrencyName=@PayCurrencyName,"); builder.Append("PaymentFee=@PaymentFee,"); builder.Append("PaymentFeeAdjusted=@PaymentFeeAdjusted,"); builder.Append("GatewayOrderId=@GatewayOrderId,"); builder.Append("OrderTotal=@OrderTotal,"); builder.Append("OrderPoint=@OrderPoint,"); builder.Append("OrderCostPrice=@OrderCostPrice,"); builder.Append("OrderProfit=@OrderProfit,"); builder.Append("OrderOtherCost=@OrderOtherCost,"); builder.Append("OrderOptionPrice=@OrderOptionPrice,"); builder.Append("DiscountName=@DiscountName,"); builder.Append("DiscountAmount=@DiscountAmount,"); builder.Append("DiscountAdjusted=@DiscountAdjusted,"); builder.Append("DiscountValue=@DiscountValue,"); builder.Append("DiscountValueType=@DiscountValueType,"); builder.Append("CouponCode=@CouponCode,"); builder.Append("CouponName=@CouponName,"); builder.Append("CouponAmount=@CouponAmount,"); builder.Append("CouponValue=@CouponValue,"); builder.Append("CouponValueType=@CouponValueType,"); builder.Append("ActivityName=@ActivityName,"); builder.Append("ActivityFreeAmount=@ActivityFreeAmount,"); builder.Append("ActivityStatus=@ActivityStatus,"); builder.Append("GroupBuyId=@GroupBuyId,"); builder.Append("GroupBuyPrice=@GroupBuyPrice,"); builder.Append("GroupBuyStatus=@GroupBuyStatus,"); builder.Append("Amount=@Amount,"); builder.Append("OrderType=@OrderType,"); builder.Append("OrderStatus=@OrderStatus,"); builder.Append("SellerID=@SellerID,"); builder.Append("SellerName=@SellerName,"); builder.Append("SellerEmail=@SellerEmail,"); builder.Append("SellerCellPhone=@SellerCellPhone,"); builder.Append("SupplierId=@SupplierId,"); builder.Append("SupplierName=@SupplierName,"); builder.Append("ReferID=@ReferID,"); builder.Append("ReferURL=@ReferURL,"); builder.Append("OrderIP=@OrderIP,"); builder.Append("Remark=@Remark,"); builder.Append("CommentStatus=@CommentStatus"); builder.Append(" where OrderId=@OrderId"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@OrderCode", SqlDbType.NVarChar, 50), new SqlParameter("@ParentOrderId", SqlDbType.BigInt, 8), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@UpdatedDate", SqlDbType.DateTime), new SqlParameter("@BuyerID", SqlDbType.Int, 4), new SqlParameter("@BuyerName", SqlDbType.NVarChar, 100), new SqlParameter("@BuyerEmail", SqlDbType.NVarChar, 100), new SqlParameter("@BuyerCellPhone", SqlDbType.NVarChar, 50), new SqlParameter("@RegionId", SqlDbType.Int, 4), new SqlParameter("@ShipRegion", SqlDbType.NVarChar, 300), new SqlParameter("@ShipAddress", SqlDbType.NVarChar, 300), new SqlParameter("@ShipZipCode", SqlDbType.NVarChar, 20), new SqlParameter("@ShipName", SqlDbType.NVarChar, 50), new SqlParameter("@ShipTelPhone", SqlDbType.NVarChar, 50), new SqlParameter("@ShipCellPhone", SqlDbType.NVarChar, 50), new SqlParameter("@ShipEmail", SqlDbType.NVarChar, 100), new SqlParameter("@ShippingModeId", SqlDbType.Int, 4), new SqlParameter("@ShippingModeName", SqlDbType.NVarChar, 100), new SqlParameter("@RealShippingModeId", SqlDbType.Int, 4), new SqlParameter("@RealShippingModeName", SqlDbType.NVarChar, 100), new SqlParameter("@ShipperId", SqlDbType.Int, 4), new SqlParameter("@ShipperName", SqlDbType.NVarChar, 100), new SqlParameter("@ShipperAddress", SqlDbType.NVarChar, 300), new SqlParameter("@ShipperCellPhone", SqlDbType.NVarChar, 20), new SqlParameter("@Freight", SqlDbType.Money, 8), new SqlParameter("@FreightAdjusted", SqlDbType.Money, 8), new SqlParameter("@FreightActual", SqlDbType.Money, 8), new SqlParameter("@Weight", SqlDbType.Int, 4), new SqlParameter("@ShippingStatus", SqlDbType.SmallInt, 2), new SqlParameter("@ShipOrderNumber", SqlDbType.NVarChar, 50), new SqlParameter("@ExpressCompanyName", SqlDbType.NVarChar, 500), new SqlParameter("@ExpressCompanyAbb", SqlDbType.NVarChar, 500), new SqlParameter("@PaymentTypeId", SqlDbType.Int, 4), new SqlParameter("@PaymentTypeName", SqlDbType.NVarChar, 100), new SqlParameter("@PaymentGateway", SqlDbType.NVarChar, 50), new SqlParameter("@PaymentStatus", SqlDbType.SmallInt, 2), new SqlParameter("@RefundStatus", SqlDbType.SmallInt, 2), new SqlParameter("@PayCurrencyCode", SqlDbType.NVarChar, 20), new SqlParameter("@PayCurrencyName", SqlDbType.NVarChar, 20), new SqlParameter("@PaymentFee", SqlDbType.Money, 8), new SqlParameter("@PaymentFeeAdjusted", SqlDbType.Money, 8), new SqlParameter("@GatewayOrderId", SqlDbType.NVarChar, 100), new SqlParameter("@OrderTotal", SqlDbType.Money, 8), new SqlParameter("@OrderPoint", SqlDbType.Int, 4), new SqlParameter("@OrderCostPrice", SqlDbType.Money, 8), new SqlParameter("@OrderProfit", SqlDbType.Money, 8), new SqlParameter("@OrderOtherCost", SqlDbType.Money, 8), new SqlParameter("@OrderOptionPrice", SqlDbType.Money, 8), new SqlParameter("@DiscountName", SqlDbType.NVarChar, 200), new SqlParameter("@DiscountAmount", SqlDbType.Money, 8), new SqlParameter("@DiscountAdjusted", SqlDbType.Money, 8), new SqlParameter("@DiscountValue", SqlDbType.Money, 8), new SqlParameter("@DiscountValueType", SqlDbType.SmallInt, 2), new SqlParameter("@CouponCode", SqlDbType.NVarChar, 50), new SqlParameter("@CouponName", SqlDbType.NVarChar, 100), new SqlParameter("@CouponAmount", SqlDbType.Money, 8), new SqlParameter("@CouponValue", SqlDbType.Money, 8), new SqlParameter("@CouponValueType", SqlDbType.SmallInt, 2), new SqlParameter("@ActivityName", SqlDbType.NVarChar, 200), new SqlParameter("@ActivityFreeAmount", SqlDbType.Money, 8), new SqlParameter("@ActivityStatus", SqlDbType.SmallInt, 2), new SqlParameter("@GroupBuyId", SqlDbType.Int, 4), new SqlParameter("@GroupBuyPrice", SqlDbType.Money, 8), new SqlParameter("@GroupBuyStatus", SqlDbType.SmallInt, 2), new SqlParameter("@Amount", SqlDbType.Money, 8), new SqlParameter("@OrderType", SqlDbType.SmallInt, 2), new SqlParameter("@OrderStatus", SqlDbType.SmallInt, 2), new SqlParameter("@SellerID", SqlDbType.Int, 4), new SqlParameter("@SellerName", SqlDbType.NVarChar, 100), new SqlParameter("@SellerEmail", SqlDbType.NVarChar, 100), new SqlParameter("@SellerCellPhone", SqlDbType.NVarChar, 50), new SqlParameter("@SupplierId", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.NVarChar, 100), new SqlParameter("@ReferID", SqlDbType.NVarChar, 50), new SqlParameter("@ReferURL", SqlDbType.NVarChar, 200), new SqlParameter("@OrderIP", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@CommentStatus", SqlDbType.SmallInt, 2), new SqlParameter("@OrderId", SqlDbType.BigInt, 8) }; para[0].Value = model.OrderCode; para[1].Value = model.ParentOrderId; para[2].Value = model.CreatedDate; para[3].Value = model.UpdatedDate; para[4].Value = model.BuyerID; para[5].Value = model.BuyerName; para[6].Value = model.BuyerEmail; para[7].Value = model.BuyerCellPhone; para[8].Value = model.RegionId; para[9].Value = model.ShipRegion; para[10].Value = model.ShipAddress; para[11].Value = model.ShipZipCode; para[12].Value = model.ShipName; para[13].Value = model.ShipTelPhone; para[14].Value = model.ShipCellPhone; para[15].Value = model.ShipEmail; para[0x10].Value = model.ShippingModeId; para[0x11].Value = model.ShippingModeName; para[0x12].Value = model.RealShippingModeId; para[0x13].Value = model.RealShippingModeName; para[20].Value = model.ShipperId; para[0x15].Value = model.ShipperName; para[0x16].Value = model.ShipperAddress; para[0x17].Value = model.ShipperCellPhone; para[0x18].Value = model.Freight; para[0x19].Value = model.FreightAdjusted; para[0x1a].Value = model.FreightActual; para[0x1b].Value = model.Weight; para[0x1c].Value = model.ShippingStatus; para[0x1d].Value = model.ShipOrderNumber; para[30].Value = model.ExpressCompanyName; para[0x1f].Value = model.ExpressCompanyAbb; para[0x20].Value = model.PaymentTypeId; para[0x21].Value = model.PaymentTypeName; para[0x22].Value = model.PaymentGateway; para[0x23].Value = model.PaymentStatus; para[0x24].Value = model.RefundStatus; para[0x25].Value = model.PayCurrencyCode; para[0x26].Value = model.PayCurrencyName; para[0x27].Value = model.PaymentFee; para[40].Value = model.PaymentFeeAdjusted; para[0x29].Value = model.GatewayOrderId; para[0x2a].Value = model.OrderTotal; para[0x2b].Value = model.OrderPoint; para[0x2c].Value = model.OrderCostPrice; para[0x2d].Value = model.OrderProfit; para[0x2e].Value = model.OrderOtherCost; para[0x2f].Value = model.OrderOptionPrice; para[0x30].Value = model.DiscountName; para[0x31].Value = model.DiscountAmount; para[50].Value = model.DiscountAdjusted; para[0x33].Value = model.DiscountValue; para[0x34].Value = model.DiscountValueType; para[0x35].Value = model.CouponCode; para[0x36].Value = model.CouponName; para[0x37].Value = model.CouponAmount; para[0x38].Value = model.CouponValue; para[0x39].Value = model.CouponValueType; para[0x3a].Value = model.ActivityName; para[0x3b].Value = model.ActivityFreeAmount; para[60].Value = model.ActivityStatus; para[0x3d].Value = model.GroupBuyId; para[0x3e].Value = model.GroupBuyPrice; para[0x3f].Value = model.GroupBuyStatus; para[0x40].Value = model.Amount; para[0x41].Value = model.OrderType; para[0x42].Value = model.OrderStatus; para[0x43].Value = model.SellerID; para[0x44].Value = model.SellerName; para[0x45].Value = model.SellerEmail; para[70].Value = model.SellerCellPhone; para[0x47].Value = model.SupplierId; para[0x48].Value = model.SupplierName; para[0x49].Value = model.ReferID; para[0x4a].Value = model.ReferURL; para[0x4b].Value = model.OrderIP; para[0x4c].Value = model.Remark; para[0x4d].Value = model.CommentStatus; para[0x4e].Value = model.OrderId; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("UPDATE Shop_OrderItems SET ShipmentQuantity=Quantity WHERE OrderId =@OrderId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@OrderId", SqlDbType.BigInt, 8) }; parameterArray2[0].Value = model.OrderId; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public void DeleteNormal(List<CommandInfo> sqllist, int PostID) { StringBuilder builder = new StringBuilder(); builder.Append("Delete SNS_Posts Where PostID=@PostID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PostID", SqlDbType.Int, 4) }; para[0].Value = PostID; CommandInfo item = new CommandInfo(builder.ToString(), para); sqllist.Add(item); }
public bool UpdatePathAndDepth(int id, int parentid) { List<CommandInfo> cmdList = new List<CommandInfo>(); CommandInfo item = new CommandInfo(); if (parentid == 0) { StringBuilder builder = new StringBuilder(); builder.Append("update Shop_GiftsCategory set "); builder.Append("Depth=@Depth,"); builder.Append("Path=@Path,"); builder.Append("HasChildren='false'"); builder.Append(" where CategoryID=@CategoryID"); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@Depth", SqlDbType.Int, 4), new SqlParameter("@Path", SqlDbType.NVarChar, 200), new SqlParameter("@CategoryID", SqlDbType.Int, 4) }; parameterArray[0].Value = 1; parameterArray[1].Value = id; parameterArray[2].Value = id; item = new CommandInfo(builder.ToString(), parameterArray); cmdList.Add(item); } else { StringBuilder builder2 = new StringBuilder(); builder2.Append("update Shop_GiftsCategory set "); builder2.Append("Depth=(select Shop_GiftsCategory.depth from Shop_GiftsCategory where CategoryID=@ParentCategoryID)+1,"); builder2.Append("Path=(select Shop_GiftsCategory.Path from Shop_GiftsCategory where CategoryID=@ParentCategoryID)+@Path,"); builder2.Append("HasChildren='true'"); builder2.Append(" where CategoryID=@CategoryID"); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@Path", SqlDbType.NVarChar, 200), new SqlParameter("@ParentCategoryID", SqlDbType.Int, 4), new SqlParameter("@CategoryID", SqlDbType.Int, 4) }; parameterArray2[0].Value = "|" + id; parameterArray2[1].Value = parentid; parameterArray2[2].Value = id; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); } StringBuilder builder3 = new StringBuilder(); builder3.Append("UPDATE Shop_GiftsCategory set"); builder3.Append(" Depth=(select Shop_GiftsCategory.depth from Shop_GiftsCategory where CategoryID=@CategoryID)+1,"); builder3.Append(" Path=(select Shop_GiftsCategory.Path from Shop_GiftsCategory where CategoryID=@CategoryID)+@Path "); builder3.Append("where ParentCategoryId=@CategoryID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Path", SqlDbType.NVarChar, 200), new SqlParameter("@ParentCategoryID", SqlDbType.Int, 4), new SqlParameter("@CategoryID", SqlDbType.Int, 4) }; para[0].Value = "|" + id; para[1].Value = parentid; para[2].Value = id; item = new CommandInfo(builder3.ToString(), para); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEx(int AlbumID, int TargetId, int Type) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from SNS_UserAlbumDetail "); builder.Append(" where TargetID=@TargetID and Type=@Type and AlbumID=@AlbumID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@TargetID", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@AlbumID", SqlDbType.Int, 4) }; para[0].Value = TargetId; para[1].Value = Type; para[2].Value = AlbumID; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("update SNS_UserAlbums set PhotoCount=PhotoCount-1"); builder2.Append(" where AlbumID=@AlbumID "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@AlbumID", SqlDbType.Int, 4) }; parameterArray2[0].Value = TargetId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool DeleteListByNormalPost(string PostIDs) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("Delete SNS_Posts Where PostID in (" + PostIDs + ")"); CommandInfo item = new CommandInfo(builder.ToString(), null); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from SNS_Comments "); builder2.Append(" where TargetId in(select PostID from SNS_Posts where PostId in (" + PostIDs + ")) AND Type=0"); CommandInfo info2 = new CommandInfo(builder2.ToString(), null); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool DeleteListEX(string PhotoIDs) { int length = PhotoIDs.Split(new char[] { ',' }).Length; List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("Update Accounts_UsersExp set ShareCount=ShareCount-" + length); builder.Append(" where UserID in ( Select CreatedUserID from SNS_Photos where PhotoID in (" + PhotoIDs + ")) "); SqlParameter[] para = new SqlParameter[0]; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("Update SNS_UserAlbums set PhotoCount=PhotoCount-1 "); builder2.Append(" where AlbumID in ( Select AlbumID from SNS_UserAlbumDetail where type=0 and TargetID in (" + PhotoIDs + "))"); item = new CommandInfo(builder2.ToString(), para); cmdList.Add(item); StringBuilder builder3 = new StringBuilder(); builder3.Append("delete SNS_Photos "); builder3.Append(" where PhotoID in (" + PhotoIDs + ")"); item = new CommandInfo(builder3.ToString(), para); cmdList.Add(item); StringBuilder builder4 = new StringBuilder(); builder4.Append("delete SNS_Posts "); builder4.Append(" where Type=1 and TargetId in (" + PhotoIDs + ") "); item = new CommandInfo(builder4.ToString(), para); cmdList.Add(item); StringBuilder builder5 = new StringBuilder(); builder5.Append("delete SNS_Comments "); builder5.Append(" where type=1 and TargetID in (" + PhotoIDs + ") "); item = new CommandInfo(builder5.ToString(), para); cmdList.Add(item); StringBuilder builder6 = new StringBuilder(); builder6.Append("delete SNS_UserFavourite "); builder6.Append(" where type=0 and TargetID in (" + PhotoIDs + ") "); item = new CommandInfo(builder6.ToString(), para); cmdList.Add(item); StringBuilder builder7 = new StringBuilder(); builder7.Append("delete SNS_UserAlbumDetail "); builder7.Append(" where type=0 and TargetID in (" + PhotoIDs + ") "); item = new CommandInfo(builder7.ToString(), para); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEx(int RuleId) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from Shop_CouponInfo "); builder.Append(" where RuleId=@RuleId "); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RuleId", SqlDbType.Int, 4) }; para[0].Value = RuleId; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from Shop_CouponHistory "); builder2.Append(" where RuleId=@RuleId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@RuleId", SqlDbType.Int, 4) }; parameterArray2[0].Value = RuleId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool UpdateCommentCount(int id) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("update SNS_UserBlog set "); builder.Append("TotalComment=TotalComment+1 "); builder.Append(" where BlogID=@BlogID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BlogID", SqlDbType.Int, 4) }; para[0].Value = id; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("Update SNS_Posts Set CommentCount=CommentCount+1 where type=4 and TargetId=@TargetId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray2[0].Value = id; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEx(long InquiryId) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from Shop_Inquiry "); builder.Append(" where InquiryId=@InquiryId"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@InquiryId", SqlDbType.BigInt) }; para[0].Value = InquiryId; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from Shop_InquiryItem "); builder2.Append(" where InquiryId=@InquiryId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@InquiryId", SqlDbType.BigInt) }; parameterArray2[0].Value = InquiryId; CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(info2); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public bool DeleteListEx(string GroupIDlist) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from SNS_GroupTopicFav "); builder.Append(" where TopicID in (select TopicID from SNS_GroupTopics where GroupID in (" + GroupIDlist + ")) "); CommandInfo item = new CommandInfo(builder.ToString(), null); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from SNS_GroupTopicReply "); builder2.Append(" where GroupID in (" + GroupIDlist + ") "); CommandInfo info2 = new CommandInfo(builder2.ToString(), null); cmdList.Add(info2); StringBuilder builder3 = new StringBuilder(); builder3.Append("delete from SNS_GroupTopics "); builder3.Append(" where GroupID in (" + GroupIDlist + ") "); CommandInfo info3 = new CommandInfo(builder3.ToString(), null); cmdList.Add(info3); StringBuilder builder4 = new StringBuilder(); builder4.Append("delete from SNS_GroupUsers "); builder4.Append(" where GroupID in (" + GroupIDlist + ") "); CommandInfo info4 = new CommandInfo(builder4.ToString(), null); cmdList.Add(info4); StringBuilder builder5 = new StringBuilder(); builder5.Append("delete from SNS_Groups "); builder5.Append(" where GroupID in (" + GroupIDlist + ") "); CommandInfo info5 = new CommandInfo(builder5.ToString(), null); cmdList.Add(info5); if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0) { return false; } return true; }
public int AddForwardPost(Maticsoft.Model.SNS.Posts model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SNS_Posts("); builder.Append("Type,TopicTitle,CreatedUserID,UserIP,Status,CreatedDate,CreatedNickName,OriginalID,ForwardedID,Description,HasReferUsers)"); builder.Append(" values ("); builder.Append("@Type,@TopicTitle,@CreatedUserID,@UserIP,@Status,@CreatedDate,@CreatedNickName,@OriginalID,@ForwardedID,@Description,@HasReferUsers)"); builder.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@TopicTitle", SqlDbType.NVarChar, 200), new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@UserIP", SqlDbType.NVarChar, 15), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@CreatedNickName", SqlDbType.NVarChar, 50), new SqlParameter("@OriginalID", SqlDbType.Int, 4), new SqlParameter("@ForwardedID", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@HasReferUsers", SqlDbType.Bit, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; para[0].Value = model.Type; para[1].Value = model.TopicTitle; para[2].Value = model.CreatedUserID; para[3].Value = model.UserIP; para[4].Value = model.Status; para[5].Value = model.CreatedDate; para[6].Value = model.CreatedNickName; para[7].Value = model.OriginalID; para[8].Value = model.ForwardedID; para[9].Value = model.Description; para[10].Value = model.HasReferUsers; para[11].Direction = ParameterDirection.Output; List<CommandInfo> cmdList = new List<CommandInfo>(); CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("update SNS_Posts"); builder2.Append(" set ForwardCount=ForwardCount+1"); int originalID = model.OriginalID; builder2.Append(" where PostID in( " + ((originalID == model.ForwardedID) ? model.OriginalID.ToString() : (model.OriginalID + "," + model.ForwardedID)) + " )"); item = new CommandInfo(builder2.ToString(), null); cmdList.Add(item); DbHelperSQL.ExecuteSqlTran(cmdList); return (int) para[11].Value; }
public void UpdateStatus(List<CommandInfo> sqllist, int PostID) { StringBuilder builder = new StringBuilder(); builder.Append("UPDATE SNS_Posts SET STATUS=@STATUS Where PostID=@PostID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@PostID", SqlDbType.Int, 4) }; para[0].Value = 3; para[1].Value = PostID; CommandInfo item = new CommandInfo(builder.ToString(), para); sqllist.Add(item); }
public void ExtendAdd(LabMS.Model.Recipients model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Recipients("); strSql.Append("Numbers,Name,Type,MRecipients,EncodedTime,ReturnTime,BorrowedState,ReturnState,Comment,Operator,OperatDate)"); strSql.Append(" values ("); strSql.Append("@Numbers,@Name,@Type,@MRecipients,@EncodedTime,@ReturnTime,@BorrowedState,@ReturnState,@Comment,@Operator,@OperatDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Numbers", SqlDbType.VarChar,50), new SqlParameter("@Name", SqlDbType.VarChar,30), new SqlParameter("@Type", SqlDbType.VarChar,20), new SqlParameter("@MRecipients", SqlDbType.VarChar,30), new SqlParameter("@EncodedTime", SqlDbType.DateTime), new SqlParameter("@ReturnTime", SqlDbType.DateTime), new SqlParameter("@BorrowedState", SqlDbType.VarChar,20), new SqlParameter("@ReturnState", SqlDbType.VarChar,20), new SqlParameter("@Comment", SqlDbType.VarChar,100), new SqlParameter("@Operator", SqlDbType.VarChar,30), new SqlParameter("@OperatDate", SqlDbType.DateTime)}; parameters[0].Value = model.Numbers; parameters[1].Value = model.Name; parameters[2].Value = model.Type; parameters[3].Value = model.MRecipients; parameters[4].Value = model.EncodedTime; parameters[5].Value = model.ReturnTime; parameters[6].Value = model.BorrowedState; parameters[7].Value = model.ReturnState; parameters[8].Value = model.Comment; parameters[9].Value = model.Operator; parameters[10].Value = model.OperatDate; CommandInfo comd1 = new CommandInfo(); comd1.Parameters = parameters; comd1.CommandText = strSql.ToString(); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update InstrumentAndConsumables set "); strSql2.Append("Quantity=@Quantity"); strSql2.Append(" where Numbers=@Numbers "); SqlParameter[] parameters2 = { new SqlParameter("@Quantity", SqlDbType.Int,4), new SqlParameter("@Numbers", SqlDbType.VarChar,30) }; parameters2[0].Value = 0; parameters2[1].Value = model.Numbers; CommandInfo comd2 = new CommandInfo(); comd2.Parameters = parameters2; comd2.CommandText = strSql2.ToString(); List<CommandInfo> listcomd = new List<CommandInfo>(); listcomd.Add(comd1); listcomd.Add(comd2); try { DbHelperSQL.ExecuteSqlTran(listcomd); } catch { throw (new Exception("数据库执行错误!")); } }
public bool DeleteEx(int BlogID) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete from SNS_UserBlog "); builder.Append(" where BlogID=@BlogID"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BlogID", SqlDbType.Int, 4) }; para[0].Value = BlogID; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("delete from SNS_Posts where type=4 and TargetId=@TargetId "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray2[0].Value = BlogID; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); StringBuilder builder3 = new StringBuilder(); builder3.Append("delete from SNS_Comments where type=4 and TargetId=@TargetId "); SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray3[0].Value = BlogID; item = new CommandInfo(builder3.ToString(), parameterArray3); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEX(int PhotoID) { List<CommandInfo> cmdList = new List<CommandInfo>(); StringBuilder builder = new StringBuilder(); builder.Append("delete SNS_UserFavourite "); builder.Append(" where type=0 and TargetID=@TargetId "); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; para[0].Value = PhotoID; CommandInfo item = new CommandInfo(builder.ToString(), para); cmdList.Add(item); StringBuilder builder2 = new StringBuilder(); builder2.Append("Update Accounts_UsersExp set ShareCount=ShareCount-1"); builder2.Append(" where UserID=( Select CreatedUserID from SNS_Photos where PhotoID=@PhotoID) "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@PhotoID", SqlDbType.Int, 4) }; parameterArray2[0].Value = PhotoID; item = new CommandInfo(builder2.ToString(), parameterArray2); cmdList.Add(item); StringBuilder builder3 = new StringBuilder(); builder3.Append("Update SNS_UserAlbums set PhotoCount=PhotoCount-1 "); builder3.Append(" where AlbumID=( Select AlbumID from SNS_UserAlbumDetail where type=0 and TargetID=@TargetId)"); SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray3[0].Value = PhotoID; item = new CommandInfo(builder3.ToString(), parameterArray3); cmdList.Add(item); StringBuilder builder4 = new StringBuilder(); builder4.Append("delete SNS_Posts "); builder4.Append(" where Type=1 and TargetId=@TargetId "); SqlParameter[] parameterArray4 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray4[0].Value = PhotoID; item = new CommandInfo(builder4.ToString(), parameterArray4); cmdList.Add(item); StringBuilder builder5 = new StringBuilder(); builder5.Append("delete SNS_Comments "); builder5.Append(" where type=1 and TargetID=@TargetId "); SqlParameter[] parameterArray5 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray5[0].Value = PhotoID; item = new CommandInfo(builder5.ToString(), parameterArray5); cmdList.Add(item); StringBuilder builder6 = new StringBuilder(); builder6.Append("delete SNS_UserAlbumDetail "); builder6.Append(" where type=0 and TargetID=@TargetId "); SqlParameter[] parameterArray6 = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4) }; parameterArray6[0].Value = PhotoID; item = new CommandInfo(builder6.ToString(), parameterArray6); cmdList.Add(item); StringBuilder builder7 = new StringBuilder(); builder7.Append("delete SNS_Photos "); builder7.Append(" where PhotoID=@PhotoID"); SqlParameter[] parameterArray7 = new SqlParameter[] { new SqlParameter("@PhotoID", SqlDbType.Int, 4) }; parameterArray7[0].Value = PhotoID; item = new CommandInfo(builder7.ToString(), parameterArray7); cmdList.Add(item); return (DbHelperSQL.ExecuteSqlTran(cmdList) > 0); }
public bool DeleteEx(int PostID) { List<CommandInfo> sqllist = new List<CommandInfo>(); new Maticsoft.SQLServerDAL.SNS.Comments(); Maticsoft.Model.SNS.Posts model = new Maticsoft.Model.SNS.Posts(); model = this.GetModel(PostID); int? type = model.Type; if (type.HasValue) { if ((type.Value == 0) || (type.Value == 3)) { this.DeleteNormal(sqllist, PostID); StringBuilder builder = new StringBuilder(); builder.Append("delete from SNS_Comments "); builder.Append(" where TargetId=@TargetId AND Type=@Type"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@TargetId", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4) }; para[0].Value = PostID; para[1].Value = type; CommandInfo item = new CommandInfo(builder.ToString(), para); sqllist.Add(item); if (DbHelperSQL.ExecuteSqlTran(sqllist) <= 0) { return false; } return true; } if (type.Value == 1) { int num; new Maticsoft.SQLServerDAL.SNS.Photos().DeleteListEx(model.TargetId.ToString(), out num); if (num == 1) { return true; } } else if (type.Value == 2) { int num2; new Maticsoft.SQLServerDAL.SNS.Products().DeleteListEx(model.TargetId.ToString(), out num2); if (num2 == 1) { return true; } } } return false; }