public DataTable CompanyIndexStatistics(int companyID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@companyID", SqlDbType.Int) };
pt[0].Value = companyID;
return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "CompanyIndexStatistics", pt));
}
public int AddUser(UserInfo user)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@userName", SqlDbType.NVarChar),
new SqlParameter("@userPassword", SqlDbType.NVarChar),
new SqlParameter("@email", SqlDbType.NVarChar),
new SqlParameter("@sex", SqlDbType.Int),
new SqlParameter("@introduce", SqlDbType.NText),
new SqlParameter("@photo", SqlDbType.NVarChar),
new SqlParameter("@mSN", SqlDbType.NVarChar),
new SqlParameter("@qQ", SqlDbType.NVarChar),
new SqlParameter("@tel", SqlDbType.NVarChar),
new SqlParameter("@mobile", SqlDbType.NVarChar),
new SqlParameter("@regionID", SqlDbType.NVarChar),
new SqlParameter("@address", SqlDbType.NVarChar),
new SqlParameter("@birthday", SqlDbType.NVarChar),
new SqlParameter("@registerIP", SqlDbType.NVarChar),
new SqlParameter("@registerDate", SqlDbType.DateTime),
new SqlParameter("@lastLoginIP", SqlDbType.NVarChar),
new SqlParameter("@lastLoginDate", SqlDbType.DateTime),
new SqlParameter("@loginTimes", SqlDbType.Int),
new SqlParameter("@safeCode", SqlDbType.NVarChar),
new SqlParameter("@findDate", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int),
new SqlParameter("@openID", SqlDbType.NVarChar),
new SqlParameter("@groupID", SqlDbType.Int),
new SqlParameter("@realName", SqlDbType.NVarChar),
new SqlParameter("@companyID", SqlDbType.Int),
new SqlParameter("@workingPostID", SqlDbType.Int),
new SqlParameter("@studyPostID", SqlDbType.Int),
new SqlParameter("@workingPostName", SqlDbType.NVarChar),
new SqlParameter("@department", SqlDbType.Int),
new SqlParameter("@idCard", SqlDbType.NVarChar),
new SqlParameter("@postStartDate", SqlDbType.DateTime),
new SqlParameter("@entryDate", SqlDbType.DateTime)
};
pt[0].Value = user.UserName;
pt[1].Value = user.UserPassword;
pt[2].Value = user.Email;
pt[3].Value = user.Sex;
pt[4].Value = user.Introduce;
pt[5].Value = user.Photo;
pt[6].Value = user.MSN;
pt[7].Value = user.QQ;
pt[8].Value = user.Tel;
pt[9].Value = user.Mobile;
pt[10].Value = user.RegionID;
pt[11].Value = user.Address;
pt[12].Value = user.Birthday;
pt[13].Value = user.RegisterIP;
pt[14].Value = user.RegisterDate;
pt[15].Value = user.LastLoginIP;
pt[0x10].Value = user.LastLoginDate;
pt[0x11].Value = user.LoginTimes;
pt[0x12].Value = user.SafeCode;
pt[0x13].Value = user.FindDate;
pt[20].Value = user.Status;
pt[0x15].Value = user.OpenID;
pt[0x16].Value = user.GroupID;
pt[0x17].Value = user.RealName;
pt[0x18].Value = user.CompanyID;
pt[0x19].Value = user.WorkingPostID;
pt[0x1a].Value = user.StudyPostID;
pt[0x1b].Value = user.PostName;
pt[0x1c].Value = user.Department;
pt[0x1d].Value = user.IDCard;
pt[0x1e].Value = user.PostStartDate;
if (user.EntryDate.HasValue)
{
pt[0x1f].Value = user.EntryDate;
}
else
{
pt[0x1f].Value = DBNull.Value;
}
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddUser", pt)));
}
public void UpdateUser(UserInfo user)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@userName", SqlDbType.NVarChar),
new SqlParameter("@sex", SqlDbType.Int),
new SqlParameter("@introduce", SqlDbType.NText),
new SqlParameter("@photo", SqlDbType.NVarChar),
new SqlParameter("@mSN", SqlDbType.NVarChar),
new SqlParameter("@qQ", SqlDbType.NVarChar),
new SqlParameter("@tel", SqlDbType.NVarChar),
new SqlParameter("@mobile", SqlDbType.NVarChar),
new SqlParameter("@regionID", SqlDbType.NVarChar),
new SqlParameter("@address", SqlDbType.NVarChar),
new SqlParameter("@birthday", SqlDbType.NVarChar),
new SqlParameter("@status", SqlDbType.Int),
new SqlParameter("@email", SqlDbType.NVarChar),
new SqlParameter("@groupID", SqlDbType.Int),
new SqlParameter("@realName", SqlDbType.NVarChar),
new SqlParameter("@companyID", SqlDbType.Int),
new SqlParameter("@workingPostID", SqlDbType.Int),
new SqlParameter("@studyPostID", SqlDbType.Int),
new SqlParameter("@workingPostName", SqlDbType.NVarChar),
new SqlParameter("@department", SqlDbType.Int),
new SqlParameter("@idCard", SqlDbType.NVarChar),
new SqlParameter("@postStartDate", SqlDbType.DateTime),
new SqlParameter("@entryDate", SqlDbType.DateTime)
};
pt[0].Value = user.ID;
pt[1].Value = user.UserName;
pt[2].Value = user.Sex;
pt[3].Value = user.Introduce;
pt[4].Value = user.Photo;
pt[5].Value = user.MSN;
pt[6].Value = user.QQ;
pt[7].Value = user.Tel;
pt[8].Value = user.Mobile;
pt[9].Value = user.RegionID;
pt[10].Value = user.Address;
pt[11].Value = user.Birthday;
pt[12].Value = user.Status;
pt[13].Value = user.Email;
pt[14].Value = user.GroupID;
pt[15].Value = user.RealName;
pt[16].Value = user.CompanyID;
pt[17].Value = user.WorkingPostID;
pt[18].Value = user.StudyPostID;
pt[19].Value = user.PostName;
pt[20].Value = user.Department;
pt[21].Value = user.IDCard;
pt[22].Value = user.PostStartDate;
if (user.EntryDate.HasValue)
{
pt[23].Value = user.EntryDate;
}
else
{
pt[23].Value = DBNull.Value;
}
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateUser", pt);
}
public void DeleteTaobaoProductClass()
{
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteTaobaoProductClass");
}
public void DeleteVoteItemByVoteID(string strVoteID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@strVoteID", SqlDbType.NVarChar) };
pt[0].Value = strVoteID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteVoteItemByVoteID", pt);
}
public void DeletePostKPISettingByCompanyID(string companyID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@companyID", SqlDbType.VarChar) };
pt[0].Value = companyID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeletePostKPISettingBycompanyID", pt);
}
public void MoveUpCourseCate(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
pt[0].Value = id;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "MoveUpCourseCate", pt);
}
public void MoveDownArticleClass(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
pt[0].Value = id;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "MoveDownArticleClass", pt);
}
public void DeleteKPIEvaluateByUserID(string userID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@userID", SqlDbType.VarChar) };
pt[0].Value = userID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteKPIEvaluateByuserID", pt);
}
public void UpdateProduct(ProductInfo product)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.NVarChar),
new SqlParameter("@spelling", SqlDbType.NVarChar),
new SqlParameter("@color", SqlDbType.NVarChar),
new SqlParameter("@fontStyle", SqlDbType.NVarChar),
new SqlParameter("@productNumber", SqlDbType.NVarChar),
new SqlParameter("@classID", SqlDbType.NVarChar),
new SqlParameter("@brandID", SqlDbType.VarChar),
new SqlParameter("@marketPrice", SqlDbType.Decimal),
new SqlParameter("@weight", SqlDbType.Int),
new SqlParameter("@sendPoint", SqlDbType.Int),
new SqlParameter("@photo", SqlDbType.NVarChar),
new SqlParameter("@keywords", SqlDbType.NVarChar),
new SqlParameter("@summary", SqlDbType.NText),
new SqlParameter("@introduction", SqlDbType.NText),
new SqlParameter("@remark", SqlDbType.NText),
new SqlParameter("@isSpecial", SqlDbType.Int),
new SqlParameter("@isNew", SqlDbType.Int),
new SqlParameter("@isHot", SqlDbType.Int),
new SqlParameter("@isSale", SqlDbType.Int),
new SqlParameter("@isTop", SqlDbType.Int),
new SqlParameter("@accessory", SqlDbType.NVarChar),
new SqlParameter("@relationProduct", SqlDbType.NVarChar),
new SqlParameter("@relationArticle", SqlDbType.NVarChar),
new SqlParameter("@allowComment", SqlDbType.Int),
new SqlParameter("@totalStorageCount", SqlDbType.Int),
new SqlParameter("@lowerCount", SqlDbType.Int),
new SqlParameter("@upperCount", SqlDbType.Int),
new SqlParameter("@attributeClassID", SqlDbType.Int),
new SqlParameter("@standardType", SqlDbType.Int),
new SqlParameter("@companyID", SqlDbType.Int),
new SqlParameter("@sort", SqlDbType.Int),
new SqlParameter("@courseDate", SqlDbType.NVarChar),
new SqlParameter("@state", SqlDbType.Int),
new SqlParameter("@courseURL", SqlDbType.NVarChar),
new SqlParameter("@salesToolURL", SqlDbType.NVarChar),
new SqlParameter("@editor", SqlDbType.NVarChar)
};
pt[0].Value = product.ID;
pt[1].Value = product.Name;
pt[2].Value = product.Spelling;
pt[3].Value = product.Color;
pt[4].Value = product.FontStyle;
pt[5].Value = product.ProductNumber;
pt[6].Value = product.ClassID;
pt[7].Value = product.BrandID;
pt[8].Value = product.MarketPrice;
pt[9].Value = product.Weight;
pt[10].Value = product.SendPoint;
pt[11].Value = product.Photo;
pt[12].Value = product.Keywords;
pt[13].Value = product.Summary;
pt[14].Value = product.Introduction;
pt[15].Value = product.Remark;
pt[0x10].Value = product.IsSpecial;
pt[0x11].Value = product.IsNew;
pt[0x12].Value = product.IsHot;
pt[0x13].Value = product.IsSale;
pt[20].Value = product.IsTop;
pt[0x15].Value = product.Accessory;
pt[0x16].Value = product.RelationProduct;
pt[0x17].Value = product.RelationArticle;
pt[0x18].Value = product.AllowComment;
pt[0x19].Value = product.TotalStorageCount;
pt[0x1a].Value = product.LowerCount;
pt[0x1b].Value = product.UpperCount;
pt[0x1c].Value = product.AttributeClassID;
pt[0x1d].Value = product.StandardType;
pt[0x1e].Value = product.CompanyID;
pt[0x1f].Value = product.Sort;
pt[0x20].Value = product.CourseDate;
pt[0x21].Value = product.State;
pt[0x22].Value = product.CourseURL;
pt[0x23].Value = product.SalesToolURL;
pt[0x24].Value = product.Editor;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProduct", pt);
}
public void DeleteUserAccountRecordByUserID(string strUserID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@strUserID", SqlDbType.NVarChar) };
pt[0].Value = strUserID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteUserAccountRecordByUserID", pt);
}
public void OnSaleProduct(string strID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@strID", SqlDbType.NVarChar) };
pt[0].Value = strID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "OnSaleProduct", pt);
}
public DataTable NoHandlerStatistics()
{
return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "NoHandlerStatistics"));
}
public int AddProduct(ProductInfo product)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@name", SqlDbType.NVarChar),
new SqlParameter("@spelling", SqlDbType.NVarChar),
new SqlParameter("@color", SqlDbType.NVarChar),
new SqlParameter("@fontStyle", SqlDbType.NVarChar),
new SqlParameter("@productNumber", SqlDbType.NVarChar),
new SqlParameter("@classID", SqlDbType.NVarChar),
new SqlParameter("@brandID", SqlDbType.VarChar),
new SqlParameter("@marketPrice", SqlDbType.Decimal),
new SqlParameter("@weight", SqlDbType.Int),
new SqlParameter("@sendPoint", SqlDbType.Int),
new SqlParameter("@photo", SqlDbType.NVarChar),
new SqlParameter("@keywords", SqlDbType.NVarChar),
new SqlParameter("@summary", SqlDbType.NText),
new SqlParameter("@introduction", SqlDbType.NText),
new SqlParameter("@remark", SqlDbType.NText),
new SqlParameter("@isSpecial", SqlDbType.Int),
new SqlParameter("@isNew", SqlDbType.Int),
new SqlParameter("@isHot", SqlDbType.Int),
new SqlParameter("@isSale", SqlDbType.Int),
new SqlParameter("@isTop", SqlDbType.Int),
new SqlParameter("@accessory", SqlDbType.NVarChar),
new SqlParameter("@relationProduct", SqlDbType.NVarChar),
new SqlParameter("@relationArticle", SqlDbType.NVarChar),
new SqlParameter("@viewCount", SqlDbType.Int),
new SqlParameter("@allowComment", SqlDbType.Int),
new SqlParameter("@commentCount", SqlDbType.Int),
new SqlParameter("@sumPoint", SqlDbType.Int),
new SqlParameter("@perPoint", SqlDbType.Decimal),
new SqlParameter("@photoCount", SqlDbType.Int),
new SqlParameter("@collectCount", SqlDbType.Int),
new SqlParameter("@totalStorageCount", SqlDbType.Int),
new SqlParameter("@orderCount", SqlDbType.Int),
new SqlParameter("@sendCount", SqlDbType.Int),
new SqlParameter("@importActualStorageCount", SqlDbType.Int),
new SqlParameter("@importVirtualStorageCount", SqlDbType.Int),
new SqlParameter("@lowerCount", SqlDbType.Int),
new SqlParameter("@upperCount", SqlDbType.Int),
new SqlParameter("@attributeClassID", SqlDbType.Int),
new SqlParameter("@standardType", SqlDbType.Int),
new SqlParameter("@addDate", SqlDbType.DateTime),
new SqlParameter("@companyID", SqlDbType.Int),
new SqlParameter("@sort", SqlDbType.Int),
new SqlParameter("@courseDate", SqlDbType.NVarChar),
new SqlParameter("@state", SqlDbType.Int),
new SqlParameter("@courseURL", SqlDbType.NVarChar),
new SqlParameter("@salesToolURL", SqlDbType.NVarChar),
new SqlParameter("@editor", SqlDbType.NVarChar)
};
pt[0].Value = product.Name;
pt[1].Value = product.Spelling;
pt[2].Value = product.Color;
pt[3].Value = product.FontStyle;
pt[4].Value = product.ProductNumber;
pt[5].Value = product.ClassID;
pt[6].Value = product.BrandID;
pt[7].Value = product.MarketPrice;
pt[8].Value = product.Weight;
pt[9].Value = product.SendPoint;
pt[10].Value = product.Photo;
pt[11].Value = product.Keywords;
pt[12].Value = product.Summary;
pt[13].Value = product.Introduction;
pt[14].Value = product.Remark;
pt[15].Value = product.IsSpecial;
pt[0x10].Value = product.IsNew;
pt[0x11].Value = product.IsHot;
pt[0x12].Value = product.IsSale;
pt[0x13].Value = product.IsTop;
pt[20].Value = product.Accessory;
pt[0x15].Value = product.RelationProduct;
pt[0x16].Value = product.RelationArticle;
pt[0x17].Value = product.ViewCount;
pt[0x18].Value = product.AllowComment;
pt[0x19].Value = product.CommentCount;
pt[0x1a].Value = product.SumPoint;
pt[0x1b].Value = product.PerPoint;
pt[0x1c].Value = product.PhotoCount;
pt[0x1d].Value = product.CollectCount;
pt[30].Value = product.TotalStorageCount;
pt[0x1f].Value = product.OrderCount;
pt[0x20].Value = product.SendCount;
pt[0x21].Value = product.ImportActualStorageCount;
pt[0x22].Value = product.ImportVirtualStorageCount;
pt[0x23].Value = product.LowerCount;
pt[0x24].Value = product.UpperCount;
pt[0x25].Value = product.AttributeClassID;
pt[0x26].Value = product.StandardType;
pt[0x27].Value = product.AddDate;
pt[0x28].Value = product.CompanyID;
pt[0x29].Value = product.Sort;
pt[0x2a].Value = product.CourseDate;
pt[0x2b].Value = product.State;
pt[0x2c].Value = product.CourseURL;
pt[0x2d].Value = product.SalesToolURL;
pt[0x2e].Value = product.Editor;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddProduct", pt)));
}
public void DeleteMemberPriceByProductID(string strProductID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@strProductID", SqlDbType.NVarChar) };
pt[0].Value = strProductID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteMemberPriceByProductID", pt);
}
public void DeleteRegion(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
pt[0].Value = id;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteRegion", pt);
}
public void DeletePostKPISetting(string strID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@strID", SqlDbType.NVarChar) };
pt[0].Value = strID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeletePostKPISetting", pt);
}
public void ClearCart(int userID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@userID", SqlDbType.Int) };
pt[0].Value = userID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "ClearCart", pt);
}
public void DeleteCourseCate(int CateId)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@CateId", SqlDbType.Int) };
pt[0].Value = CateId;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteCourseCate", pt);
}
public int AddTestSetting(TestSettingInfo Model)
{
SqlParameter[] pt = (SqlParameter[])this.ValueParas(Model);
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddTestSetting", pt)));
}
public override SqlDataReader ExecuteReader()
{
return(ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadPageList", base.PrepareParameter()));
}
public DataTable StatisticsSaleStop(string productIDList)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@productIDList", SqlDbType.NVarChar) };
pt[0].Value = productIDList;
return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "StatisticsSaleStop", pt));
}
