public void CreateChargeStandard(ChargeStandard cs) { SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@carrier_id", cs.CarrierId), SqlUtilities.GenerateInputIntParameter("@carrier_area_id", cs.CarrierAreaId), SqlUtilities.GenerateInputNVarcharParameter("@encode", 50, cs.Encode), SqlUtilities.GenerateInputParameter("@goods_type", SqlDbType.TinyInt, cs.GoodsType), SqlUtilities.GenerateInputParameter("@start_weight", SqlDbType.Decimal, cs.StartWeight), SqlUtilities.GenerateInputParameter("@end_weight", SqlDbType.Decimal, cs.EndWeight), SqlUtilities.GenerateInputParameter("@base_weight", SqlDbType.Decimal, cs.BaseWeight), SqlUtilities.GenerateInputParameter("@increase_weight", SqlDbType.Decimal, cs.IncreaseWeight), SqlUtilities.GenerateInputParameter("@normal_base_price", SqlDbType.Decimal, cs.NormalBasePrice), SqlUtilities.GenerateInputParameter("@normal_continue_price", SqlDbType.Decimal, cs.NormalContinuePrice), SqlUtilities.GenerateInputParameter("@normal_kg_price", SqlDbType.Decimal, cs.NormalKgPrice), SqlUtilities.GenerateInputParameter("@normal_disposal_cost", SqlDbType.Decimal, cs.NormalDisposalCost), SqlUtilities.GenerateInputParameter("@normal_register_cost", SqlDbType.Decimal, cs.NormalRegisterCost), SqlUtilities.GenerateInputParameter("@client_base_price", SqlDbType.Decimal, cs.ClientBasePrice), SqlUtilities.GenerateInputParameter("@client_continue_price", SqlDbType.Decimal, cs.ClientContinuePrice), SqlUtilities.GenerateInputParameter("@client_kg_price", SqlDbType.Decimal, cs.ClientKgPrice), SqlUtilities.GenerateInputParameter("@client_disposal_cost", SqlDbType.Decimal, cs.ClientDisposalCost), SqlUtilities.GenerateInputParameter("@client_register_cost", SqlDbType.Decimal, cs.ClientRegisterCost), SqlUtilities.GenerateInputParameter("@self_base_price", SqlDbType.Decimal, cs.SelfBasePrice), SqlUtilities.GenerateInputParameter("@self_continue_price", SqlDbType.Decimal, cs.SelfContinuePrice), SqlUtilities.GenerateInputParameter("@self_kg_price", SqlDbType.Decimal, cs.SelfKgPrice), SqlUtilities.GenerateInputParameter("@self_disposal_cost", SqlDbType.Decimal, cs.SelfDisposalCost), SqlUtilities.GenerateInputParameter("@self_register_cost", SqlDbType.Decimal, cs.SelfRegisterCost), SqlUtilities.GenerateInputParameter("@preferential_gram", SqlDbType.Decimal, cs.PreferentialGram) }; string sql = "INSERT INTO charge_standards(carrier_id, carrier_area_id, encode, goods_type, start_weight, end_weight, base_weight, increase_weight, normal_base_price, normal_continue_price, normal_kg_price, normal_disposal_cost, normal_register_cost, client_base_price, client_continue_price, client_kg_price, client_disposal_cost, client_register_cost, self_base_price, self_continue_price, self_kg_price, self_disposal_cost, self_register_cost, preferential_gram) VALUES (@carrier_id, @carrier_area_id, @encode, @goods_type, @start_weight, @end_weight, @base_weight, @increase_weight, @normal_base_price, @normal_continue_price, @normal_kg_price, @normal_disposal_cost, @normal_register_cost, @client_base_price, @client_continue_price, @client_kg_price, @client_disposal_cost, @client_register_cost, @self_base_price, @self_continue_price, @self_kg_price, @self_disposal_cost, @self_register_cost, @preferential_gram)"; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); }
protected void btnCreate_Click(object sender, EventArgs e) { ChargeStandard cs = new ChargeStandard(); cs.CarrierAreaId = ca.Id; cs.CarrierId = carrier.Id; cs.Encode = ChargeStandardOperation.GetNextEncode(ca.Id); cs.GoodsType = byte.Parse(ddlGoodsType.SelectedItem.Value); try { cs.StartWeight = decimal.Parse(txtStartWeight.Text); cs.EndWeight = decimal.Parse(txtEndWeight.Text); cs.BaseWeight = decimal.Parse(txtBaseWeight.Text); cs.IncreaseWeight = decimal.Parse(txtIncreaseWeight.Text); cs.NormalBasePrice = decimal.Parse(txtNormalBasePrice.Text); cs.NormalContinuePrice = decimal.Parse(txtNormalContinuePrice.Text); cs.NormalDisposalCost = decimal.Parse(txtNormalDisposalCost.Text); cs.NormalKgPrice = decimal.Parse(txtNormalKgPrice.Text); cs.NormalRegisterCost = decimal.Parse(txtNormalRegisterCost.Text); cs.ClientBasePrice = decimal.Parse(txtClientBasePrice.Text); cs.ClientContinuePrice = decimal.Parse(txtClientContinuePrice.Text); cs.ClientDisposalCost = decimal.Parse(txtClientDisposalCost.Text); cs.ClientKgPrice = decimal.Parse(txtClientKgPrice.Text); cs.ClientRegisterCost = decimal.Parse(txtClientRegisterCost.Text); cs.SelfBasePrice = decimal.Parse(txtSelfBasePrice.Text); cs.SelfContinuePrice = decimal.Parse(txtSelfContinuePrice.Text); cs.SelfDisposalCost = decimal.Parse(txtSelfDisposalCost.Text); cs.SelfKgPrice = decimal.Parse(txtSelfKgPrice.Text); cs.SelfRegisterCost = decimal.Parse(txtSelfRegisterCost.Text); cs.PreferentialGram = decimal.Parse(txtPreferentialGram.Text); } catch (Exception ex) { Response.Write("<script language='javascript' type='text/javascript'>alert('重量、价格、费用和让利克数都只能为数字!');</script>"); return; } if ((cs.NormalBasePrice > 0 || cs.NormalContinuePrice > 0) && cs.NormalKgPrice > 0) { Response.Write("<script language='javascript' type='text/javascript'>alert('同一重量范围内只能按首、续重价 或 每KG价其中一种方式计算!');</script>"); return; } if ((cs.ClientBasePrice > 0 || cs.ClientContinuePrice > 0) && cs.ClientKgPrice > 0) { Response.Write("<script language='javascript' type='text/javascript'>alert('同一重量范围内只能按首、续重价 或 每KG价其中一种方式计算!');</script>"); return; } if ((cs.SelfBasePrice > 0 || cs.SelfContinuePrice > 0) && cs.SelfKgPrice > 0) { Response.Write("<script language='javascript' type='text/javascript'>alert('同一重量范围内只能按首、续重价 或 每KG价其中一种方式计算!');</script>"); return; } ChargeStandardOperation.CreateChargeStandard(cs); lblMsg.Text = "添加成功!"; RpChargeStandardDataBind(); }
public static void UpdateChargeStandard(ChargeStandard cs) { dal.UpdateChargeStandard(cs); }
public static void CreateChargeStandard(ChargeStandard cs) { dal.CreateChargeStandard(cs); }
public List<ChargeStandard> GetChargeStandardByCarrierAreaId(int carrierAreaId) { List<ChargeStandard> result = new List<ChargeStandard>(); SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@carrier_area_id", carrierAreaId) }; string sql = "SELECT carrier_id, carrier_area_id, encode, goods_type, start_weight, end_weight, base_weight, increase_weight, normal_base_price, normal_continue_price, normal_kg_price, normal_disposal_cost, normal_register_cost, client_base_price, client_continue_price, client_kg_price, client_disposal_cost, client_register_cost, self_base_price, self_continue_price, self_kg_price, self_disposal_cost, self_register_cost, id, preferential_gram FROM charge_standards WHERE carrier_area_id = @carrier_area_id"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { ChargeStandard cs = new ChargeStandard(); cs.CarrierId = dr.GetInt32(0); cs.CarrierAreaId = dr.GetInt32(1); cs.Encode = dr.GetString(2); cs.GoodsType = dr.GetByte(3); cs.StartWeight = dr.GetDecimal(4); cs.EndWeight = dr.GetDecimal(5); cs.BaseWeight = dr.GetDecimal(6); cs.IncreaseWeight = dr.GetDecimal(7); cs.NormalBasePrice = dr.GetDecimal(8); cs.NormalContinuePrice = dr.GetDecimal(9); cs.NormalKgPrice = dr.GetDecimal(10); cs.NormalDisposalCost = dr.GetDecimal(11); cs.NormalRegisterCost = dr.GetDecimal(12); cs.ClientBasePrice = dr.GetDecimal(13); cs.ClientContinuePrice = dr.GetDecimal(14); cs.ClientKgPrice = dr.GetDecimal(15); cs.ClientDisposalCost = dr.GetDecimal(16); cs.ClientRegisterCost = dr.GetDecimal(17); cs.SelfBasePrice = dr.GetDecimal(18); cs.SelfContinuePrice = dr.GetDecimal(19); cs.SelfKgPrice = dr.GetDecimal(20); cs.SelfDisposalCost = dr.GetDecimal(21); cs.SelfRegisterCost = dr.GetDecimal(22); cs.Id = dr.GetInt32(23); cs.PreferentialGram = dr.GetDecimal(24); result.Add(cs); } } return result; }
public void UpdateChargeStandard(ChargeStandard cs) { SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@id", cs.Id), SqlUtilities.GenerateInputParameter("@goods_type", SqlDbType.TinyInt, cs.GoodsType), SqlUtilities.GenerateInputParameter("@start_weight", SqlDbType.Decimal, cs.StartWeight), SqlUtilities.GenerateInputParameter("@end_weight", SqlDbType.Decimal, cs.EndWeight), SqlUtilities.GenerateInputParameter("@base_weight", SqlDbType.Decimal, cs.BaseWeight), SqlUtilities.GenerateInputParameter("@increase_weight", SqlDbType.Decimal, cs.IncreaseWeight), SqlUtilities.GenerateInputParameter("@normal_base_price", SqlDbType.Decimal, cs.NormalBasePrice), SqlUtilities.GenerateInputParameter("@normal_continue_price", SqlDbType.Decimal, cs.NormalContinuePrice), SqlUtilities.GenerateInputParameter("@normal_kg_price", SqlDbType.Decimal, cs.NormalKgPrice), SqlUtilities.GenerateInputParameter("@normal_disposal_cost", SqlDbType.Decimal, cs.NormalDisposalCost), SqlUtilities.GenerateInputParameter("@normal_register_cost", SqlDbType.Decimal, cs.NormalRegisterCost), SqlUtilities.GenerateInputParameter("@client_base_price", SqlDbType.Decimal, cs.ClientBasePrice), SqlUtilities.GenerateInputParameter("@client_continue_price", SqlDbType.Decimal, cs.ClientContinuePrice), SqlUtilities.GenerateInputParameter("@client_kg_price", SqlDbType.Decimal, cs.ClientKgPrice), SqlUtilities.GenerateInputParameter("@client_disposal_cost", SqlDbType.Decimal, cs.ClientDisposalCost), SqlUtilities.GenerateInputParameter("@client_register_cost", SqlDbType.Decimal, cs.ClientRegisterCost), SqlUtilities.GenerateInputParameter("@self_base_price", SqlDbType.Decimal, cs.SelfBasePrice), SqlUtilities.GenerateInputParameter("@self_continue_price", SqlDbType.Decimal, cs.SelfContinuePrice), SqlUtilities.GenerateInputParameter("@self_kg_price", SqlDbType.Decimal, cs.SelfKgPrice), SqlUtilities.GenerateInputParameter("@self_disposal_cost", SqlDbType.Decimal, cs.SelfDisposalCost), SqlUtilities.GenerateInputParameter("@self_register_cost", SqlDbType.Decimal, cs.SelfRegisterCost), SqlUtilities.GenerateInputParameter("@preferential_gram", SqlDbType.Decimal, cs.PreferentialGram) }; string sql = "UPDATE charge_standards SET goods_type = @goods_type, start_weight = @start_weight, end_weight = @end_weight, base_weight = @base_weight, increase_weight = @increase_weight, normal_base_price = @normal_base_price, normal_continue_price = @normal_continue_price, normal_kg_price = @normal_kg_price, normal_disposal_cost = @normal_disposal_cost, normal_register_cost = @normal_register_cost, client_base_price = @client_base_price, client_continue_price = @client_continue_price, client_kg_price = @client_kg_price, client_disposal_cost = @client_disposal_cost, client_register_cost = @client_register_cost, self_base_price = @self_base_price, self_continue_price = @self_continue_price, self_kg_price = @self_kg_price, self_disposal_cost = @self_disposal_cost, self_register_cost = @self_register_cost, preferential_gram = @preferential_gram WHERE id = @id"; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); }