protected void gvList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblUserType = e.Row.FindControl("lblUserType") as Label;
NoName.NetShop.ShopFlow.ExpressInfoModel model = e.Row.DataItem as NoName.NetShop.ShopFlow.ExpressInfoModel;
MemberType userType = (MemberType)model.UserType;
UserLevel userLevel = (UserLevel)model.UserLevel;
switch (userType)
{
case MemberType.Personal:
lblUserType.Text = userLevel.ToString();
break;
case MemberType.Company:
lblUserType.Text = "鼎企会员";
break;
case MemberType.Famly:
lblUserType.Text = "鼎宅会员";
break;
case MemberType.School:
lblUserType.Text = "鼎校会员";
break;
default:
lblUserType.Text = userLevel.ToString();
break;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.ShopFlow.ExpressInfoModel model)
{
Database db = NoName.NetShop.Common.CommDataAccess.DbWriter;
DbCommand dbCommand = db.GetStoredProcCommand("UP_unExpressInfo_Update");
db.AddInParameter(dbCommand, "ShipRegion", DbType.Byte, model.ShipRegion);
db.AddInParameter(dbCommand, "UserType", DbType.Byte, model.UserType);
db.AddInParameter(dbCommand, "UserLevel", DbType.Byte, model.UserLevel);
db.AddInParameter(dbCommand, "MarkMoney", DbType.Decimal, model.MarkMoney);
db.AddInParameter(dbCommand, "LShipFee", DbType.Decimal, model.LShipFee);
db.AddInParameter(dbCommand, "GShipFee", DbType.Decimal, model.GShipFee);
db.AddInParameter(dbCommand, "RuleId", DbType.Int32, model.RuleId);
db.ExecuteNonQuery(dbCommand);
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in gvList.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
int ruleId = int.Parse(row.Cells[0].Text);
NoName.NetShop.ShopFlow.ExpressInfoModel model = ebll.GetModel(ruleId);
model.MarkMoney = decimal.Parse(((TextBox)row.FindControl("txtMarkMoney")).Text);
model.LShipFee = decimal.Parse(((TextBox)row.FindControl("txtLShipFee")).Text);
model.GShipFee = decimal.Parse(((TextBox)row.FindControl("txtGShipFee")).Text);
ebll.Update(model);
}
}
BindList();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.ShopFlow.ExpressInfoModel GetModel(int RuleId)
{
Database db = DatabaseFactory.CreateDatabase();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ShipRegion,UserType,UserLevel,MarkMoney,LShipFee,GShipFee,RuleId ");
strSql.Append(" FROM unExpressInfo where ruleId=" + RuleId);
NoName.NetShop.ShopFlow.ExpressInfoModel model = null;
using (IDataReader dataReader = NoName.NetShop.Common.CommDataAccess.DbReader.ExecuteReader(CommandType.Text, strSql.ToString()))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.ShopFlow.ExpressInfoModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.ShopFlow.ExpressInfoModel model = new NoName.NetShop.ShopFlow.ExpressInfoModel();
object ojb;
ojb = dataReader["ShipRegion"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipRegion = Convert.ToInt32(ojb);
}
ojb = dataReader["UserType"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserType = Convert.ToInt32(ojb);
}
ojb = dataReader["UserLevel"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserLevel = Convert.ToInt32(ojb);
}
ojb = dataReader["MarkMoney"];
if (ojb != null && ojb != DBNull.Value)
{
model.MarkMoney = (decimal)ojb;
}
ojb = dataReader["LShipFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.LShipFee = (decimal)ojb;
}
ojb = dataReader["GShipFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.GShipFee = (decimal)ojb;
}
ojb = dataReader["RuleId"];
if (ojb != null && ojb != DBNull.Value)
{
model.RuleId = Convert.ToInt32(ojb);
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.ShopFlow.ExpressInfoModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.ShopFlow.ExpressInfoModel model = new NoName.NetShop.ShopFlow.ExpressInfoModel();
object ojb;
ojb = dataReader["ShipRegion"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipRegion = Convert.ToInt32(ojb);
}
ojb = dataReader["UserType"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserType = Convert.ToInt32(ojb);
}
ojb = dataReader["UserLevel"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserLevel = Convert.ToInt32(ojb);
}
ojb = dataReader["MarkMoney"];
if (ojb != null && ojb != DBNull.Value)
{
model.MarkMoney = (decimal)ojb;
}
ojb = dataReader["LShipFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.LShipFee = (decimal)ojb;
}
ojb = dataReader["GShipFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.GShipFee = (decimal)ojb;
}
ojb = dataReader["RuleId"];
if (ojb != null && ojb != DBNull.Value)
{
model.RuleId = Convert.ToInt32(ojb);
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.ShopFlow.ExpressInfoModel model)
{
dal.Update(model);
}
