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