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