public string GetAccountPropertyByAccountModel(AccountDescription description)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(description.GameName.Trim());
stringBuilder.Append("/");
stringBuilder.Append(description.GameArea.Trim());
stringBuilder.Append("/");
stringBuilder.Append(description.ServerName.Trim());
return stringBuilder.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AccountDescription model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AccountDescription set ");
strSql.Append(" productImgAUrl = @productImgAUrl , ");
strSql.Append(" productImgBUrl = @productImgBUrl , ");
strSql.Append(" ProductImgCUrl = @ProductImgCUrl , ");
strSql.Append(" ProductImgDUrl = @ProductImgDUrl , ");
strSql.Append(" SubmitTime = @SubmitTime , ");
strSql.Append(" OrderStatus = @OrderStatus , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" EditDate = @EditDate , ");
strSql.Append(" GameName = @GameName , ");
strSql.Append(" EditUser = @EditUser , ");
strSql.Append(" GameArea = @GameArea , ");
strSql.Append(" ServerName = @ServerName , ");
strSql.Append(" AccountInfoID = @AccountInfoID , ");
strSql.Append(" ProductProperty = @ProductProperty , ");
strSql.Append(" ProductTitle = @ProductTitle , ");
strSql.Append(" ProductDescription = @ProductDescription , ");
strSql.Append(" Price = @Price ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) ,
new SqlParameter("@productImgAUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@productImgBUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@ProductImgCUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@ProductImgDUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@SubmitTime", SqlDbType.DateTime) ,
new SqlParameter("@OrderStatus", SqlDbType.Int,4) ,
new SqlParameter("@OrderNo", SqlDbType.VarChar,255) ,
new SqlParameter("@UserID", SqlDbType.Int,4) ,
new SqlParameter("@Remark", SqlDbType.VarChar,500) ,
new SqlParameter("@EditDate", SqlDbType.DateTime) ,
new SqlParameter("@GameName", SqlDbType.VarChar,50) ,
new SqlParameter("@EditUser", SqlDbType.VarChar,50) ,
new SqlParameter("@GameArea", SqlDbType.VarChar,50) ,
new SqlParameter("@ServerName", SqlDbType.VarChar,50) ,
new SqlParameter("@AccountInfoID", SqlDbType.Int,4) ,
new SqlParameter("@ProductProperty", SqlDbType.VarChar,255) ,
new SqlParameter("@ProductTitle", SqlDbType.NChar,255) ,
new SqlParameter("@ProductDescription", SqlDbType.NChar,255) ,
new SqlParameter("@Price", SqlDbType.Decimal,9)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProductImgAUrl;
parameters[2].Value = model.ProductImgBUrl;
parameters[3].Value = model.ProductImgCUrl;
parameters[4].Value = model.ProductImgDUrl;
parameters[5].Value = model.SubmitTime;
parameters[6].Value = model.OrderStatus;
parameters[7].Value = model.OrderNo;
parameters[8].Value = model.UserID;
parameters[9].Value = model.Remark;
parameters[10].Value = model.EditDate;
parameters[11].Value = model.GameName;
parameters[12].Value = model.EditUser;
parameters[13].Value = model.GameArea;
parameters[14].Value = model.ServerName;
parameters[15].Value = model.AccountInfoID;
parameters[16].Value = model.ProductProperty;
parameters[17].Value = model.ProductTitle;
parameters[18].Value = model.ProductDescription;
parameters[19].Value = model.Price;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
public List<AccountDescription> GetPagedAccountDescriptionsModelsByProc(int pageIndex, int pageSize, string whereStr,string orderStr, out int rowCount,
out int pageCount)
{
List<AccountDescription> modelsList = new List<AccountDescription>();
rowCount = 0;
pageCount = 0;
IDataParameter[] sqlParameters =
{
new SqlParameter("@TableName","AccountDescription"),
new SqlParameter("@IDName","ID"),
new SqlParameter("@PageIndex",pageIndex),
new SqlParameter("@PageSize",pageSize),
new SqlParameter("@Where",string.IsNullOrEmpty(whereStr)?"":whereStr),
new SqlParameter("@OrderBy",string.IsNullOrEmpty(orderStr)?"order by ID":"order by "+orderStr),
new SqlParameter("@RowCount",SqlDbType.Int,25),
new SqlParameter("@PageCount",SqlDbType.Int,25),
};
sqlParameters[6].Direction =ParameterDirection.Output;
sqlParameters[6].Value = DBNull.Value;
sqlParameters[7].Direction = ParameterDirection.Output;
sqlParameters[7].Value = DBNull.Value;
//SqlDataReader dataReader = DbHelperSQL.RunProcedure("sp_GetPageDataOutRowPageCount", sqlParameters);
using (SqlConnection connection = new SqlConnection(DbHelperSQL.connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = connection;
cmd.Parameters.AddRange(sqlParameters);
cmd.CommandText = "sp_GetPageDataOutRowPageCount";
SqlDataReader dataReader = cmd.ExecuteReader();
using (dataReader)
{
while (dataReader.Read())
{
AccountDescription infoModel = new AccountDescription();
infoModel.ID = Convert.ToInt32(dataReader["ID"]);
infoModel.SubmitTime =
Convert.ToDateTime(Convert.IsDBNull(dataReader["SubmitTime"])
? DateTime.MinValue
: dataReader["SubmitTime"]);
infoModel.ProductTitle = Convert.ToString(dataReader["ProductTitle"]);
infoModel.ProductProperty = Convert.ToString(dataReader["ProductProperty"]);
infoModel.Price = Convert.ToDecimal(dataReader["Price"]);
infoModel.AccountInfoID = Convert.ToInt32(dataReader["AccountInfoID"]);
infoModel.ServerName = Convert.ToString(dataReader["ServerName"]);
infoModel.GameName = Convert.ToString(dataReader["GameName"]);
infoModel.GameArea = Convert.ToString(dataReader["GameArea"]);
infoModel.OrderNo = Convert.ToString(dataReader["OrderNo"]);
infoModel.OrderStatus = (OrderStatus) dataReader["OrderStatus"];
infoModel.UserID =Convert.IsDBNull(dataReader["UserID"])?0:Convert.ToInt32(dataReader["UserID"]);
infoModel.Remark = Convert.IsDBNull(dataReader["Remark"])
? ""
: Convert.ToString(dataReader["Remark"]);
modelsList.Add(infoModel);
}
}
//只有在DataReader关闭后才能拿到输出参数！重要，重要
rowCount = Convert.ToInt32(cmd.Parameters["@RowCount"].Value);
pageCount = Convert.ToInt32(cmd.Parameters["@PageCount"].Value);
}
return modelsList;
}
public List<AccountDescription> GetModelList(string where)
{
List<AccountDescription> list = new List<AccountDescription>();
DataSet dataSet = GetList(where);
DataTable dtTable = dataSet.Tables[0];
foreach (DataRow dataRow in dtTable.Rows)
{
AccountDescription accountdescription = new AccountDescription();
accountdescription.ID = Convert.ToInt32(dataRow["ID"]);
accountdescription.OrderNo = Convert.ToString(dataRow["OrderNo"]);
list.Add(accountdescription);
}
return list;
}
/// <summary>
/// 根据AccountInfoID 拿到 AccountDescription
/// </summary>
/// <param name="accountInfoId"></param>
/// <returns></returns>
public AccountDescription GetModelByAccountInfoId(int accountInfoId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, productImgAUrl, productImgBUrl, ProductImgCUrl, ProductImgDUrl, SubmitTime, OrderStatus, OrderNo, GameName, GameArea, ServerName, AccountInfoID, ProductProperty, ProductTitle, ProductDescription, Price,UserID,Remark,EditDate,EditUser ");
strSql.Append(" from AccountDescription ");
strSql.Append(" where AccountInfoID=@AccountInfoID");
SqlParameter[] parameters = {
new SqlParameter("@AccountInfoID", SqlDbType.Int,4)
};
parameters[0].Value = accountInfoId;
AccountDescription model = new AccountDescription();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.ProductImgAUrl = ds.Tables[0].Rows[0]["productImgAUrl"].ToString();
model.ProductImgBUrl = ds.Tables[0].Rows[0]["productImgBUrl"].ToString();
model.ProductImgCUrl = ds.Tables[0].Rows[0]["ProductImgCUrl"].ToString();
model.ProductImgDUrl = ds.Tables[0].Rows[0]["ProductImgDUrl"].ToString();
if (ds.Tables[0].Rows[0]["SubmitTime"].ToString() != "")
{
model.SubmitTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubmitTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "")
{
model.OrderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), ds.Tables[0].Rows[0]["OrderStatus"].ToString(), true);
}
model.OrderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString();
model.GameName = ds.Tables[0].Rows[0]["GameName"].ToString();
model.GameArea = ds.Tables[0].Rows[0]["GameArea"].ToString();
model.ServerName = ds.Tables[0].Rows[0]["ServerName"].ToString();
if (ds.Tables[0].Rows[0]["AccountInfoID"].ToString() != "")
{
model.AccountInfoID = int.Parse(ds.Tables[0].Rows[0]["AccountInfoID"].ToString());
}
model.ProductProperty = ds.Tables[0].Rows[0]["ProductProperty"].ToString();
model.ProductTitle = ds.Tables[0].Rows[0]["ProductTitle"].ToString();
model.ProductDescription = ds.Tables[0].Rows[0]["ProductDescription"].ToString();
model.UserID = Convert.IsDBNull(ds.Tables[0].Rows[0]["UserID"]) ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["UserID"]);
if (ds.Tables[0].Rows[0]["Price"].ToString() != "")
{
model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString());
}
if (ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]);
}
if (ds.Tables[0].Rows[0]["EditUser"].ToString() != "")
{
model.EditUser = Convert.ToString(ds.Tables[0].Rows[0]["EditUser"]);
}
if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "")
{
model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AccountDescription model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AccountDescription(");
strSql.Append("productImgAUrl,productImgBUrl,ProductImgCUrl,ProductImgDUrl,SubmitTime,OrderStatus,OrderNo,GameName,GameArea,ServerName,AccountInfoID,ProductProperty,ProductTitle,ProductDescription,Price,UserID,Remark,EditDate");
strSql.Append(") values (");
strSql.Append("@productImgAUrl,@productImgBUrl,@ProductImgCUrl,@ProductImgDUrl,@SubmitTime,@OrderStatus,@OrderNo,@GameName,@GameArea,@ServerName,@AccountInfoID,@ProductProperty,@ProductTitle,@ProductDescription,@Price,@UserID,@Remark,@EditDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@productImgAUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@productImgBUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@ProductImgCUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@ProductImgDUrl", SqlDbType.VarChar,255) ,
new SqlParameter("@SubmitTime", SqlDbType.DateTime) ,
new SqlParameter("@OrderStatus", SqlDbType.Int,4) ,
new SqlParameter("@OrderNo", SqlDbType.VarChar,255) ,
new SqlParameter("@GameName", SqlDbType.NVarChar,50) ,
new SqlParameter("@GameArea", SqlDbType.NVarChar,50) ,
new SqlParameter("@ServerName", SqlDbType.NVarChar,50) ,
new SqlParameter("@AccountInfoID", SqlDbType.Int,4) ,
new SqlParameter("@ProductProperty", SqlDbType.NVarChar,255) ,
new SqlParameter("@ProductTitle", SqlDbType.NChar,255) ,
new SqlParameter("@ProductDescription", SqlDbType.NChar,255) ,
new SqlParameter("@Price", SqlDbType.Decimal,9) ,
new SqlParameter("@UserID",SqlDbType.Int),
new SqlParameter("@Remark",SqlDbType.VarChar,500),
new SqlParameter("@EditDate",SqlDbType.DateTime),
};
parameters[0].Value = model.ProductImgAUrl;
parameters[1].Value = model.ProductImgBUrl;
parameters[2].Value = model.ProductImgCUrl;
parameters[3].Value = model.ProductImgDUrl;
parameters[4].Value = model.SubmitTime;
parameters[5].Value = model.OrderStatus;
parameters[6].Value = model.OrderNo;
parameters[7].Value = model.GameName;
parameters[8].Value = model.GameArea;
parameters[9].Value = model.ServerName;
parameters[10].Value = model.AccountInfoID;
parameters[11].Value = model.ProductProperty;
parameters[12].Value = model.ProductTitle;
parameters[13].Value = model.ProductDescription;
parameters[14].Value = model.Price;
parameters[15].Value = model.UserID;
parameters[16].Value = model.Remark;
parameters[17].Value = model.EditDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//todo:判断页面第一次加载减少数据读取次数
//根据页面传过来的订单信息(AccountDescription)ID，查到订单详细信息
string descriptionId = Request.QueryString.Get("acDes");
int accountDescriptionId;
if (!int.TryParse(descriptionId, out accountDescriptionId))
{
CurrentAccountDescription = new AccountDescription();
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert",
"<script>alert('订单ID有误，请反回重试！');window.location.href='/BillList.aspx';</script>");
}
else
{
CurrentAccountDescription = _accountDescriptionDataAccess.GetModel(accountDescriptionId);
descriptionID.Value = Convert.ToString(accountDescriptionId);
}
}
/// <summary>
/// 点击生成订单后处理用户上传的订单描述信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//商品属性
string productPropertyStr = productProperty.Text;
//标题
string productTitleStr = productTitle.Text;
//价格
string productPriceStr = productPrice.Text;
//产品描述
string pdDescriptionStr =HttpUtility.HtmlEncode(pdDescription.Text);
//四人图片地址
decimal decPrice;
#region 数据校验
if (!decimal.TryParse(productPriceStr, out decPrice))
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('价格输入有误，请重新输入！')</script>");
return;
}
#endregion
AccountDescription description = new AccountDescription();
//用户前置订单ID
string accountInfoIdStr = accountInfoID.Value;
int accountInfoIdStrInt;
if (!int.TryParse(accountInfoIdStr, out accountInfoIdStrInt))
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "<script>alert('用户前置订单ID有误，请反回重试！');window.location.href='/accountInfo.aspx';</script>");
return;
}
description.AccountInfoID = accountInfoIdStrInt;
description.ProductDescription = pdDescriptionStr;
description.ProductTitle = productTitleStr;
description.ProductProperty = productPropertyStr;
description.Price = decPrice;
//拿到用户订单Info,添加订单冗余字段值
AccountInfoModel accountinfoModel = _accountInfoDataAccess.GetModel(accountInfoIdStrInt);
if (accountinfoModel == null || accountinfoModel.ID <= 0||accountinfoModel.OrderStatus!=OrderStatus.NotComplete)
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "<script>alert('用户前置订单信息有误，请反回重试！');window.location.href='/accountInfo.aspx';</script>");
return;
}
//给冗余字段赋值，方便做列表筛选
description.GameArea = accountinfoModel.GameArea;
description.GameName = accountinfoModel.GameName;
description.ServerName = accountinfoModel.ServerName;
if(!string.IsNullOrEmpty(hiddenimggameImgA.Value.Trim()))
{
description.ProductImgAUrl = hiddenimggameImgA.Value.Trim();
}
if (!string.IsNullOrEmpty(hiddenimggameImgB.Value.Trim()))
{
description.ProductImgBUrl = hiddenimggameImgB.Value.Trim();
}
if (!string.IsNullOrEmpty(hiddenimggameImgC.Value.Trim()))
{
description.ProductImgCUrl = hiddenimggameImgC.Value.Trim();
}
if (!string.IsNullOrEmpty(hiddenimggameImgD.Value.Trim()))
{
description.ProductImgDUrl = hiddenimggameImgD.Value.Trim();
}
//生成订单号 写入订单状态
//检察订单号是否已存在
string orderNoStr = GeneralOrderNo();
description.OrderNo = orderNoStr;
description.OrderStatus = OrderStatus.ShenHe;
description.UserID = CurrentUser.ID;
description.EditDate = DateTime.Now;
int res = _accountDescriptionDataAccess.Add(description);
if (res > 0)
{
//订单创建成功,更改前置订单状态
accountinfoModel.OrderStatus = OrderStatus.ShenHe;
bool resUpdate = _accountInfoDataAccess.Update(accountinfoModel);
if (resUpdate)
{
//跳转到订单列表页
Response.Redirect("AccountSaleList.aspx");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert","<script>alert('订单提交成功，进入审核状态！')</script>");
}
}
}