public Maticsoft.Model.Shop.Gift.Gifts GetModel(int GiftId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 GiftId,CategoryID,Name,ShortDescription,Unit,Weight,LongDescription,Title,Meta_Description,Meta_Keywords,ThumbnailsUrl,InFocusImageUrl,CostPrice,MarketPrice,SalePrice,Stock,NeedPoint,NeedGrade,SaleCounts,CreateDate,Enabled from Shop_Gifts ");
builder.Append(" where GiftId=@GiftId");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@GiftId", SqlDbType.Int, 4) };
cmdParms[0].Value = GiftId;
Maticsoft.Model.Shop.Gift.Gifts gifts = new Maticsoft.Model.Shop.Gift.Gifts();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["GiftId"] != null) && (set.Tables[0].Rows[0]["GiftId"].ToString() != ""))
{
gifts.GiftId = int.Parse(set.Tables[0].Rows[0]["GiftId"].ToString());
}
if ((set.Tables[0].Rows[0]["CategoryID"] != null) && (set.Tables[0].Rows[0]["CategoryID"].ToString() != ""))
{
gifts.CategoryID = int.Parse(set.Tables[0].Rows[0]["CategoryID"].ToString());
}
if ((set.Tables[0].Rows[0]["Name"] != null) && (set.Tables[0].Rows[0]["Name"].ToString() != ""))
{
gifts.Name = set.Tables[0].Rows[0]["Name"].ToString();
}
if ((set.Tables[0].Rows[0]["ShortDescription"] != null) && (set.Tables[0].Rows[0]["ShortDescription"].ToString() != ""))
{
gifts.ShortDescription = set.Tables[0].Rows[0]["ShortDescription"].ToString();
}
if ((set.Tables[0].Rows[0]["Unit"] != null) && (set.Tables[0].Rows[0]["Unit"].ToString() != ""))
{
gifts.Unit = set.Tables[0].Rows[0]["Unit"].ToString();
}
if ((set.Tables[0].Rows[0]["Weight"] != null) && (set.Tables[0].Rows[0]["Weight"].ToString() != ""))
{
gifts.Weight = int.Parse(set.Tables[0].Rows[0]["Weight"].ToString());
}
if ((set.Tables[0].Rows[0]["LongDescription"] != null) && (set.Tables[0].Rows[0]["LongDescription"].ToString() != ""))
{
gifts.LongDescription = set.Tables[0].Rows[0]["LongDescription"].ToString();
}
if ((set.Tables[0].Rows[0]["Title"] != null) && (set.Tables[0].Rows[0]["Title"].ToString() != ""))
{
gifts.Title = set.Tables[0].Rows[0]["Title"].ToString();
}
if ((set.Tables[0].Rows[0]["Meta_Description"] != null) && (set.Tables[0].Rows[0]["Meta_Description"].ToString() != ""))
{
gifts.Meta_Description = set.Tables[0].Rows[0]["Meta_Description"].ToString();
}
if ((set.Tables[0].Rows[0]["Meta_Keywords"] != null) && (set.Tables[0].Rows[0]["Meta_Keywords"].ToString() != ""))
{
gifts.Meta_Keywords = set.Tables[0].Rows[0]["Meta_Keywords"].ToString();
}
if ((set.Tables[0].Rows[0]["ThumbnailsUrl"] != null) && (set.Tables[0].Rows[0]["ThumbnailsUrl"].ToString() != ""))
{
gifts.ThumbnailsUrl = set.Tables[0].Rows[0]["ThumbnailsUrl"].ToString();
}
if ((set.Tables[0].Rows[0]["InFocusImageUrl"] != null) && (set.Tables[0].Rows[0]["InFocusImageUrl"].ToString() != ""))
{
gifts.InFocusImageUrl = set.Tables[0].Rows[0]["InFocusImageUrl"].ToString();
}
if ((set.Tables[0].Rows[0]["CostPrice"] != null) && (set.Tables[0].Rows[0]["CostPrice"].ToString() != ""))
{
gifts.CostPrice = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["CostPrice"].ToString()));
}
if ((set.Tables[0].Rows[0]["MarketPrice"] != null) && (set.Tables[0].Rows[0]["MarketPrice"].ToString() != ""))
{
gifts.MarketPrice = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["MarketPrice"].ToString()));
}
if ((set.Tables[0].Rows[0]["SalePrice"] != null) && (set.Tables[0].Rows[0]["SalePrice"].ToString() != ""))
{
gifts.SalePrice = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["SalePrice"].ToString()));
}
if ((set.Tables[0].Rows[0]["Stock"] != null) && (set.Tables[0].Rows[0]["Stock"].ToString() != ""))
{
gifts.Stock = new int?(int.Parse(set.Tables[0].Rows[0]["Stock"].ToString()));
}
if ((set.Tables[0].Rows[0]["NeedPoint"] != null) && (set.Tables[0].Rows[0]["NeedPoint"].ToString() != ""))
{
gifts.NeedPoint = int.Parse(set.Tables[0].Rows[0]["NeedPoint"].ToString());
}
if ((set.Tables[0].Rows[0]["NeedGrade"] != null) && (set.Tables[0].Rows[0]["NeedGrade"].ToString() != ""))
{
gifts.NeedGrade = int.Parse(set.Tables[0].Rows[0]["NeedGrade"].ToString());
}
if ((set.Tables[0].Rows[0]["SaleCounts"] != null) && (set.Tables[0].Rows[0]["SaleCounts"].ToString() != ""))
{
gifts.SaleCounts = int.Parse(set.Tables[0].Rows[0]["SaleCounts"].ToString());
}
if ((set.Tables[0].Rows[0]["CreateDate"] != null) && (set.Tables[0].Rows[0]["CreateDate"].ToString() != ""))
{
gifts.CreateDate = DateTime.Parse(set.Tables[0].Rows[0]["CreateDate"].ToString());
}
if ((set.Tables[0].Rows[0]["Enabled"] != null) && (set.Tables[0].Rows[0]["Enabled"].ToString() != ""))
{
if ((set.Tables[0].Rows[0]["Enabled"].ToString() == "1") || (set.Tables[0].Rows[0]["Enabled"].ToString().ToLower() == "true"))
{
gifts.Enabled = true;
return gifts;
}
gifts.Enabled = false;
}
return gifts;
}
private void GetProdictInfo()
{
int num = 0;
if (!string.IsNullOrWhiteSpace(this.DropParentId.SelectedValue.Trim()))
{
num = int.Parse(this.DropParentId.SelectedValue);
}
string text = this.txtProductName.Text;
string str2 = this.txtUnit.Text;
decimal? nullable = new decimal?(Globals.SafeDecimal(this.txtMarketPrice.Text, (decimal) 0M));
decimal? nullable2 = new decimal?(Globals.SafeDecimal(this.txtCostPrice.Text, (decimal) 0M));
decimal? nullable3 = new decimal?(Globals.SafeDecimal(this.txtSalePrice.Text, (decimal) 0M));
int num2 = Globals.SafeInt(this.txtWeight.Text, 0);
int num3 = Globals.SafeInt(this.txtStock.Text, 0);
int num4 = Globals.SafeInt(this.txtPoints.Text, 0);
string str3 = this.txtShortDescription.Text;
string str4 = this.txtDescription.Text;
string str5 = this.txtMeta_Title.Text;
string str6 = this.txtMeta_Description.Text;
string str7 = this.txtMeta_Keywords.Text;
string format = this.hfImage.Value;
string str9 = this.thfImage.Value;
if (!string.IsNullOrWhiteSpace(str3))
{
str3 = Globals.HtmlEncodeForSpaceWrap(str3);
}
Maticsoft.Model.Shop.Gift.Gifts model = new Maticsoft.Model.Shop.Gift.Gifts {
Name = text,
CategoryID = num,
Unit = str2,
CostPrice = nullable2,
NeedPoint = num4,
SaleCounts = 0,
SalePrice = nullable3,
Stock = new int?(num3),
Weight = num2,
MarketPrice = nullable,
CreateDate = DateTime.Now,
Enabled = Globals.SafeBool(this.rblUpselling.SelectedValue, false),
ShortDescription = str3,
LongDescription = str4,
Title = str5,
Meta_Description = str6,
Meta_Keywords = str7,
ThumbnailsUrl = string.Format(format, ""),
InFocusImageUrl = string.Format(str9, "T_")
};
if (this.GiftBll.Add(model) > 0)
{
base.Response.Redirect("GiftsList.aspx");
}
else
{
MessageBox.Show(this, "保存失败! 请重试.");
}
}
public List<Maticsoft.Model.Shop.Gift.Gifts> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Shop.Gift.Gifts> list = new List<Maticsoft.Model.Shop.Gift.Gifts>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.Shop.Gift.Gifts item = new Maticsoft.Model.Shop.Gift.Gifts();
if ((dt.Rows[i]["GiftId"] != null) && (dt.Rows[i]["GiftId"].ToString() != ""))
{
item.GiftId = int.Parse(dt.Rows[i]["GiftId"].ToString());
}
if ((dt.Rows[i]["CategoryID"] != null) && (dt.Rows[i]["CategoryID"].ToString() != ""))
{
item.CategoryID = int.Parse(dt.Rows[i]["CategoryID"].ToString());
}
if ((dt.Rows[i]["Name"] != null) && (dt.Rows[i]["Name"].ToString() != ""))
{
item.Name = dt.Rows[i]["Name"].ToString();
}
if ((dt.Rows[i]["ShortDescription"] != null) && (dt.Rows[i]["ShortDescription"].ToString() != ""))
{
item.ShortDescription = dt.Rows[i]["ShortDescription"].ToString();
}
if ((dt.Rows[i]["Unit"] != null) && (dt.Rows[i]["Unit"].ToString() != ""))
{
item.Unit = dt.Rows[i]["Unit"].ToString();
}
if ((dt.Rows[i]["Weight"] != null) && (dt.Rows[i]["Weight"].ToString() != ""))
{
item.Weight = int.Parse(dt.Rows[i]["Weight"].ToString());
}
if ((dt.Rows[i]["LongDescription"] != null) && (dt.Rows[i]["LongDescription"].ToString() != ""))
{
item.LongDescription = dt.Rows[i]["LongDescription"].ToString();
}
if ((dt.Rows[i]["Title"] != null) && (dt.Rows[i]["Title"].ToString() != ""))
{
item.Title = dt.Rows[i]["Title"].ToString();
}
if ((dt.Rows[i]["Meta_Description"] != null) && (dt.Rows[i]["Meta_Description"].ToString() != ""))
{
item.Meta_Description = dt.Rows[i]["Meta_Description"].ToString();
}
if ((dt.Rows[i]["Meta_Keywords"] != null) && (dt.Rows[i]["Meta_Keywords"].ToString() != ""))
{
item.Meta_Keywords = dt.Rows[i]["Meta_Keywords"].ToString();
}
if ((dt.Rows[i]["ThumbnailsUrl"] != null) && (dt.Rows[i]["ThumbnailsUrl"].ToString() != ""))
{
item.ThumbnailsUrl = dt.Rows[i]["ThumbnailsUrl"].ToString();
}
if ((dt.Rows[i]["InFocusImageUrl"] != null) && (dt.Rows[i]["InFocusImageUrl"].ToString() != ""))
{
item.InFocusImageUrl = dt.Rows[i]["InFocusImageUrl"].ToString();
}
if ((dt.Rows[i]["CostPrice"] != null) && (dt.Rows[i]["CostPrice"].ToString() != ""))
{
item.CostPrice = new decimal?(decimal.Parse(dt.Rows[i]["CostPrice"].ToString()));
}
if ((dt.Rows[i]["MarketPrice"] != null) && (dt.Rows[i]["MarketPrice"].ToString() != ""))
{
item.MarketPrice = new decimal?(decimal.Parse(dt.Rows[i]["MarketPrice"].ToString()));
}
if ((dt.Rows[i]["SalePrice"] != null) && (dt.Rows[i]["SalePrice"].ToString() != ""))
{
item.SalePrice = new decimal?(decimal.Parse(dt.Rows[i]["SalePrice"].ToString()));
}
if ((dt.Rows[i]["Stock"] != null) && (dt.Rows[i]["Stock"].ToString() != ""))
{
item.Stock = new int?(int.Parse(dt.Rows[i]["Stock"].ToString()));
}
if ((dt.Rows[i]["NeedPoint"] != null) && (dt.Rows[i]["NeedPoint"].ToString() != ""))
{
item.NeedPoint = int.Parse(dt.Rows[i]["NeedPoint"].ToString());
}
if ((dt.Rows[i]["NeedGrade"] != null) && (dt.Rows[i]["NeedGrade"].ToString() != ""))
{
item.NeedGrade = int.Parse(dt.Rows[i]["NeedGrade"].ToString());
}
if ((dt.Rows[i]["SaleCounts"] != null) && (dt.Rows[i]["SaleCounts"].ToString() != ""))
{
item.SaleCounts = int.Parse(dt.Rows[i]["SaleCounts"].ToString());
}
if ((dt.Rows[i]["CreateDate"] != null) && (dt.Rows[i]["CreateDate"].ToString() != ""))
{
item.CreateDate = DateTime.Parse(dt.Rows[i]["CreateDate"].ToString());
}
if ((dt.Rows[i]["Enabled"] != null) && (dt.Rows[i]["Enabled"].ToString() != ""))
{
if ((dt.Rows[i]["Enabled"].ToString() == "1") || (dt.Rows[i]["Enabled"].ToString().ToLower() == "true"))
{
item.Enabled = true;
}
else
{
item.Enabled = false;
}
}
list.Add(item);
}
}
return list;
}
