private void ShowInfo(int PriceTypeID)
{
WebDemo.BLL.WebDemo.PriceType bll = new WebDemo.BLL.WebDemo.PriceType();
WebDemo.Model.WebDemo.PriceType model = bll.GetModel(PriceTypeID);
this.lblPriceTypeID.Text = model.PriceTypeID.ToString();
this.lblPriceTypeName.Text = model.PriceTypeName;
this.lblMeterTypeID.Text = model.MeterTypeID.ToString();
this.lblPriceNo.Text = model.PriceNo.ToString();
this.lblPrice.Text = model.Price.ToString();
this.lblPrice2.Text = model.Price2.ToString();
this.lblPrice3.Text = model.Price3.ToString();
this.lblDivid1.Text = model.Divid1.ToString();
this.lblDivid2.Text = model.Divid2.ToString();
this.lblPriceUnit.Text = model.PriceUnit;
this.lblRemark.Text = model.Remark;
this.lblPrice4.Text = model.Price4.ToString();
this.lblPrice5.Text = model.Price5.ToString();
this.lblPrice6.Text = model.Price6.ToString();
this.lblDivid3.Text = model.Divid3.ToString();
this.lblDivid4.Text = model.Divid4.ToString();
this.lblDivid5.Text = model.Divid5.ToString();
this.lblExeDate.Text = model.ExeDate.ToString();
this.lblSetNo.Text = model.SetNo.ToString();
this.lblSuiteNo.Text = model.SuiteNo.ToString();
this.lblGroupPriceNo.Text = model.GroupPriceNo.ToString();
this.lblPriceTypeCode.Text = model.PriceTypeCode;
this.lblIsStartStar.Text = model.IsStartStar.ToString();
this.lblIsStartPeople.Text = model.IsStartPeople.ToString();
this.lblPeopleCheck.Text = model.PeopleCheck.ToString();
this.lblMaxPeople.Text = model.MaxPeople.ToString();
this.lblAddUseNumber.Text = model.AddUseNumber.ToString();
this.lblStarsLevel.Text = model.StarsLevel.ToString();
this.lblStarsPeriod.Text = model.StarsPeriod.ToString();
this.lblStarsCorrected.Text = model.StarsCorrected.ToString();
this.lblIsStartArea.Text = model.IsStartArea.ToString();
this.lblCoefficient.Text = model.Coefficient.ToString();
this.lblCalculateDay.Text = model.CalculateDay.ToString();
this.lblStarsAreaWay.Text = model.StarsAreaWay.ToString();
this.lblStarsByUser.Text = model.StarsByUser.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.PriceType GetModel(int PriceTypeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PriceTypeID,PriceTypeName,MeterTypeID,PriceNo,Price,Price2,Price3,Divid1,Divid2,PriceUnit,Remark,Price4,Price5,Price6,Divid3,Divid4,Divid5,ExeDate,SetNo,SuiteNo,GroupPriceNo,PriceTypeCode,IsStartStar,IsStartPeople,PeopleCheck,MaxPeople,AddUseNumber,StarsLevel,StarsPeriod,StarsCorrected,IsStartArea,Coefficient,CalculateDay,StarsAreaWay,StarsByUser from PriceType ");
strSql.Append(" where PriceTypeID=@PriceTypeID");
SqlParameter[] parameters =
{
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4)
};
parameters[0].Value = PriceTypeID;
WebDemo.Model.WebDemo.PriceType model = new WebDemo.Model.WebDemo.PriceType();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtPriceTypeName.Text.Trim().Length == 0)
{
strErr += "价格名称不能为空！\\n";
}
if (!PageValidate.IsNumber(txtMeterTypeID.Text))
{
strErr += "表类型编号格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPriceNo.Text))
{
strErr += "程序控制格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice.Text))
{
strErr += "单价格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice2.Text))
{
strErr += "单价2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice3.Text))
{
strErr += "单价3格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid1.Text))
{
strErr += "分界点1格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid2.Text))
{
strErr += "分界点2格式错误！\\n";
}
if (this.txtPriceUnit.Text.Trim().Length == 0)
{
strErr += "PriceUnit不能为空！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "备注信息不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtPrice4.Text))
{
strErr += "Price4格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice5.Text))
{
strErr += "Price5格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice6.Text))
{
strErr += "Price6格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid3.Text))
{
strErr += "Divid3格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid4.Text))
{
strErr += "Divid4格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid5.Text))
{
strErr += "Divid5格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtExeDate.Text))
{
strErr += "ExeDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtSetNo.Text))
{
strErr += "SetNo格式错误！\\n";
}
if (!PageValidate.IsNumber(txtSuiteNo.Text))
{
strErr += "SuiteNo格式错误！\\n";
}
if (!PageValidate.IsNumber(txtGroupPriceNo.Text))
{
strErr += "GroupPriceNo格式错误！\\n";
}
if (this.txtPriceTypeCode.Text.Trim().Length == 0)
{
strErr += "PriceTypeCode不能为空！\\n";
}
if (!PageValidate.IsNumber(txtIsStartStar.Text))
{
strErr += "IsStartStar格式错误！\\n";
}
if (!PageValidate.IsNumber(txtIsStartPeople.Text))
{
strErr += "IsStartPeople格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPeopleCheck.Text))
{
strErr += "PeopleCheck格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMaxPeople.Text))
{
strErr += "MaxPeople格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtAddUseNumber.Text))
{
strErr += "AddUseNumber格式错误！\\n";
}
if (!PageValidate.IsNumber(txtStarsLevel.Text))
{
strErr += "StarsLevel格式错误！\\n";
}
if (!PageValidate.IsNumber(txtStarsPeriod.Text))
{
strErr += "StarsPeriod格式错误！\\n";
}
if (!PageValidate.IsNumber(txtStarsCorrected.Text))
{
strErr += "StarsCorrected格式错误！\\n";
}
if (!PageValidate.IsNumber(txtIsStartArea.Text))
{
strErr += "IsStartArea格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtCoefficient.Text))
{
strErr += "Coefficient格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCalculateDay.Text))
{
strErr += "CalculateDay格式错误！\\n";
}
if (!PageValidate.IsNumber(txtStarsAreaWay.Text))
{
strErr += "StarsAreaWay格式错误！\\n";
}
if (!PageValidate.IsNumber(txtStarsByUser.Text))
{
strErr += "StarsByUser格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string PriceTypeName = this.txtPriceTypeName.Text;
int MeterTypeID = int.Parse(this.txtMeterTypeID.Text);
int PriceNo = int.Parse(this.txtPriceNo.Text);
decimal Price = decimal.Parse(this.txtPrice.Text);
decimal Price2 = decimal.Parse(this.txtPrice2.Text);
decimal Price3 = decimal.Parse(this.txtPrice3.Text);
int Divid1 = int.Parse(this.txtDivid1.Text);
int Divid2 = int.Parse(this.txtDivid2.Text);
string PriceUnit = this.txtPriceUnit.Text;
string Remark = this.txtRemark.Text;
decimal Price4 = decimal.Parse(this.txtPrice4.Text);
decimal Price5 = decimal.Parse(this.txtPrice5.Text);
decimal Price6 = decimal.Parse(this.txtPrice6.Text);
int Divid3 = int.Parse(this.txtDivid3.Text);
int Divid4 = int.Parse(this.txtDivid4.Text);
int Divid5 = int.Parse(this.txtDivid5.Text);
DateTime ExeDate = DateTime.Parse(this.txtExeDate.Text);
int SetNo = int.Parse(this.txtSetNo.Text);
int SuiteNo = int.Parse(this.txtSuiteNo.Text);
int GroupPriceNo = int.Parse(this.txtGroupPriceNo.Text);
string PriceTypeCode = this.txtPriceTypeCode.Text;
int IsStartStar = int.Parse(this.txtIsStartStar.Text);
int IsStartPeople = int.Parse(this.txtIsStartPeople.Text);
int PeopleCheck = int.Parse(this.txtPeopleCheck.Text);
int MaxPeople = int.Parse(this.txtMaxPeople.Text);
decimal AddUseNumber = decimal.Parse(this.txtAddUseNumber.Text);
int StarsLevel = int.Parse(this.txtStarsLevel.Text);
int StarsPeriod = int.Parse(this.txtStarsPeriod.Text);
int StarsCorrected = int.Parse(this.txtStarsCorrected.Text);
int IsStartArea = int.Parse(this.txtIsStartArea.Text);
decimal Coefficient = decimal.Parse(this.txtCoefficient.Text);
int CalculateDay = int.Parse(this.txtCalculateDay.Text);
int StarsAreaWay = int.Parse(this.txtStarsAreaWay.Text);
int StarsByUser = int.Parse(this.txtStarsByUser.Text);
WebDemo.Model.WebDemo.PriceType model = new WebDemo.Model.WebDemo.PriceType();
model.PriceTypeName = PriceTypeName;
model.MeterTypeID = MeterTypeID;
model.PriceNo = PriceNo;
model.Price = Price;
model.Price2 = Price2;
model.Price3 = Price3;
model.Divid1 = Divid1;
model.Divid2 = Divid2;
model.PriceUnit = PriceUnit;
model.Remark = Remark;
model.Price4 = Price4;
model.Price5 = Price5;
model.Price6 = Price6;
model.Divid3 = Divid3;
model.Divid4 = Divid4;
model.Divid5 = Divid5;
model.ExeDate = ExeDate;
model.SetNo = SetNo;
model.SuiteNo = SuiteNo;
model.GroupPriceNo = GroupPriceNo;
model.PriceTypeCode = PriceTypeCode;
model.IsStartStar = IsStartStar;
model.IsStartPeople = IsStartPeople;
model.PeopleCheck = PeopleCheck;
model.MaxPeople = MaxPeople;
model.AddUseNumber = AddUseNumber;
model.StarsLevel = StarsLevel;
model.StarsPeriod = StarsPeriod;
model.StarsCorrected = StarsCorrected;
model.IsStartArea = IsStartArea;
model.Coefficient = Coefficient;
model.CalculateDay = CalculateDay;
model.StarsAreaWay = StarsAreaWay;
model.StarsByUser = StarsByUser;
WebDemo.BLL.WebDemo.PriceType bll = new WebDemo.BLL.WebDemo.PriceType();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.PriceType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PriceType(");
strSql.Append("PriceTypeName,MeterTypeID,PriceNo,Price,Price2,Price3,Divid1,Divid2,PriceUnit,Remark,Price4,Price5,Price6,Divid3,Divid4,Divid5,ExeDate,SetNo,SuiteNo,GroupPriceNo,PriceTypeCode,IsStartStar,IsStartPeople,PeopleCheck,MaxPeople,AddUseNumber,StarsLevel,StarsPeriod,StarsCorrected,IsStartArea,Coefficient,CalculateDay,StarsAreaWay,StarsByUser)");
strSql.Append(" values (");
strSql.Append("@PriceTypeName,@MeterTypeID,@PriceNo,@Price,@Price2,@Price3,@Divid1,@Divid2,@PriceUnit,@Remark,@Price4,@Price5,@Price6,@Divid3,@Divid4,@Divid5,@ExeDate,@SetNo,@SuiteNo,@GroupPriceNo,@PriceTypeCode,@IsStartStar,@IsStartPeople,@PeopleCheck,@MaxPeople,@AddUseNumber,@StarsLevel,@StarsPeriod,@StarsCorrected,@IsStartArea,@Coefficient,@CalculateDay,@StarsAreaWay,@StarsByUser)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@MeterTypeID", SqlDbType.Int, 4),
new SqlParameter("@PriceNo", SqlDbType.Int, 4),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Price2", SqlDbType.Decimal, 9),
new SqlParameter("@Price3", SqlDbType.Decimal, 9),
new SqlParameter("@Divid1", SqlDbType.Int, 4),
new SqlParameter("@Divid2", SqlDbType.Int, 4),
new SqlParameter("@PriceUnit", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@Price4", SqlDbType.Decimal, 9),
new SqlParameter("@Price5", SqlDbType.Decimal, 9),
new SqlParameter("@Price6", SqlDbType.Decimal, 9),
new SqlParameter("@Divid3", SqlDbType.Int, 4),
new SqlParameter("@Divid4", SqlDbType.Int, 4),
new SqlParameter("@Divid5", SqlDbType.Int, 4),
new SqlParameter("@ExeDate", SqlDbType.DateTime),
new SqlParameter("@SetNo", SqlDbType.Int, 4),
new SqlParameter("@SuiteNo", SqlDbType.Int, 4),
new SqlParameter("@GroupPriceNo", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeCode", SqlDbType.VarChar, 100),
new SqlParameter("@IsStartStar", SqlDbType.Int, 4),
new SqlParameter("@IsStartPeople", SqlDbType.Int, 4),
new SqlParameter("@PeopleCheck", SqlDbType.Int, 4),
new SqlParameter("@MaxPeople", SqlDbType.Int, 4),
new SqlParameter("@AddUseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@StarsLevel", SqlDbType.Int, 4),
new SqlParameter("@StarsPeriod", SqlDbType.Int, 4),
new SqlParameter("@StarsCorrected", SqlDbType.Int, 4),
new SqlParameter("@IsStartArea", SqlDbType.Int, 4),
new SqlParameter("@Coefficient", SqlDbType.Decimal, 9),
new SqlParameter("@CalculateDay", SqlDbType.Int, 4),
new SqlParameter("@StarsAreaWay", SqlDbType.Int, 4),
new SqlParameter("@StarsByUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.PriceTypeName;
parameters[1].Value = model.MeterTypeID;
parameters[2].Value = model.PriceNo;
parameters[3].Value = model.Price;
parameters[4].Value = model.Price2;
parameters[5].Value = model.Price3;
parameters[6].Value = model.Divid1;
parameters[7].Value = model.Divid2;
parameters[8].Value = model.PriceUnit;
parameters[9].Value = model.Remark;
parameters[10].Value = model.Price4;
parameters[11].Value = model.Price5;
parameters[12].Value = model.Price6;
parameters[13].Value = model.Divid3;
parameters[14].Value = model.Divid4;
parameters[15].Value = model.Divid5;
parameters[16].Value = model.ExeDate;
parameters[17].Value = model.SetNo;
parameters[18].Value = model.SuiteNo;
parameters[19].Value = model.GroupPriceNo;
parameters[20].Value = model.PriceTypeCode;
parameters[21].Value = model.IsStartStar;
parameters[22].Value = model.IsStartPeople;
parameters[23].Value = model.PeopleCheck;
parameters[24].Value = model.MaxPeople;
parameters[25].Value = model.AddUseNumber;
parameters[26].Value = model.StarsLevel;
parameters[27].Value = model.StarsPeriod;
parameters[28].Value = model.StarsCorrected;
parameters[29].Value = model.IsStartArea;
parameters[30].Value = model.Coefficient;
parameters[31].Value = model.CalculateDay;
parameters[32].Value = model.StarsAreaWay;
parameters[33].Value = model.StarsByUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.PriceType DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.PriceType model = new WebDemo.Model.WebDemo.PriceType();
if (row != null)
{
if (row["PriceTypeID"] != null && row["PriceTypeID"].ToString() != "")
{
model.PriceTypeID = int.Parse(row["PriceTypeID"].ToString());
}
if (row["PriceTypeName"] != null)
{
model.PriceTypeName = row["PriceTypeName"].ToString();
}
if (row["MeterTypeID"] != null && row["MeterTypeID"].ToString() != "")
{
model.MeterTypeID = int.Parse(row["MeterTypeID"].ToString());
}
if (row["PriceNo"] != null && row["PriceNo"].ToString() != "")
{
model.PriceNo = int.Parse(row["PriceNo"].ToString());
}
if (row["Price"] != null && row["Price"].ToString() != "")
{
model.Price = decimal.Parse(row["Price"].ToString());
}
if (row["Price2"] != null && row["Price2"].ToString() != "")
{
model.Price2 = decimal.Parse(row["Price2"].ToString());
}
if (row["Price3"] != null && row["Price3"].ToString() != "")
{
model.Price3 = decimal.Parse(row["Price3"].ToString());
}
if (row["Divid1"] != null && row["Divid1"].ToString() != "")
{
model.Divid1 = int.Parse(row["Divid1"].ToString());
}
if (row["Divid2"] != null && row["Divid2"].ToString() != "")
{
model.Divid2 = int.Parse(row["Divid2"].ToString());
}
if (row["PriceUnit"] != null)
{
model.PriceUnit = row["PriceUnit"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["Price4"] != null && row["Price4"].ToString() != "")
{
model.Price4 = decimal.Parse(row["Price4"].ToString());
}
if (row["Price5"] != null && row["Price5"].ToString() != "")
{
model.Price5 = decimal.Parse(row["Price5"].ToString());
}
if (row["Price6"] != null && row["Price6"].ToString() != "")
{
model.Price6 = decimal.Parse(row["Price6"].ToString());
}
if (row["Divid3"] != null && row["Divid3"].ToString() != "")
{
model.Divid3 = int.Parse(row["Divid3"].ToString());
}
if (row["Divid4"] != null && row["Divid4"].ToString() != "")
{
model.Divid4 = int.Parse(row["Divid4"].ToString());
}
if (row["Divid5"] != null && row["Divid5"].ToString() != "")
{
model.Divid5 = int.Parse(row["Divid5"].ToString());
}
if (row["ExeDate"] != null && row["ExeDate"].ToString() != "")
{
model.ExeDate = DateTime.Parse(row["ExeDate"].ToString());
}
if (row["SetNo"] != null && row["SetNo"].ToString() != "")
{
model.SetNo = int.Parse(row["SetNo"].ToString());
}
if (row["SuiteNo"] != null && row["SuiteNo"].ToString() != "")
{
model.SuiteNo = int.Parse(row["SuiteNo"].ToString());
}
if (row["GroupPriceNo"] != null && row["GroupPriceNo"].ToString() != "")
{
model.GroupPriceNo = int.Parse(row["GroupPriceNo"].ToString());
}
if (row["PriceTypeCode"] != null)
{
model.PriceTypeCode = row["PriceTypeCode"].ToString();
}
if (row["IsStartStar"] != null && row["IsStartStar"].ToString() != "")
{
model.IsStartStar = int.Parse(row["IsStartStar"].ToString());
}
if (row["IsStartPeople"] != null && row["IsStartPeople"].ToString() != "")
{
model.IsStartPeople = int.Parse(row["IsStartPeople"].ToString());
}
if (row["PeopleCheck"] != null && row["PeopleCheck"].ToString() != "")
{
model.PeopleCheck = int.Parse(row["PeopleCheck"].ToString());
}
if (row["MaxPeople"] != null && row["MaxPeople"].ToString() != "")
{
model.MaxPeople = int.Parse(row["MaxPeople"].ToString());
}
if (row["AddUseNumber"] != null && row["AddUseNumber"].ToString() != "")
{
model.AddUseNumber = decimal.Parse(row["AddUseNumber"].ToString());
}
if (row["StarsLevel"] != null && row["StarsLevel"].ToString() != "")
{
model.StarsLevel = int.Parse(row["StarsLevel"].ToString());
}
if (row["StarsPeriod"] != null && row["StarsPeriod"].ToString() != "")
{
model.StarsPeriod = int.Parse(row["StarsPeriod"].ToString());
}
if (row["StarsCorrected"] != null && row["StarsCorrected"].ToString() != "")
{
model.StarsCorrected = int.Parse(row["StarsCorrected"].ToString());
}
if (row["IsStartArea"] != null && row["IsStartArea"].ToString() != "")
{
model.IsStartArea = int.Parse(row["IsStartArea"].ToString());
}
if (row["Coefficient"] != null && row["Coefficient"].ToString() != "")
{
model.Coefficient = decimal.Parse(row["Coefficient"].ToString());
}
if (row["CalculateDay"] != null && row["CalculateDay"].ToString() != "")
{
model.CalculateDay = int.Parse(row["CalculateDay"].ToString());
}
if (row["StarsAreaWay"] != null && row["StarsAreaWay"].ToString() != "")
{
model.StarsAreaWay = int.Parse(row["StarsAreaWay"].ToString());
}
if (row["StarsByUser"] != null && row["StarsByUser"].ToString() != "")
{
model.StarsByUser = int.Parse(row["StarsByUser"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.PriceType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PriceType set ");
strSql.Append("PriceTypeName=@PriceTypeName,");
strSql.Append("MeterTypeID=@MeterTypeID,");
strSql.Append("PriceNo=@PriceNo,");
strSql.Append("Price=@Price,");
strSql.Append("Price2=@Price2,");
strSql.Append("Price3=@Price3,");
strSql.Append("Divid1=@Divid1,");
strSql.Append("Divid2=@Divid2,");
strSql.Append("PriceUnit=@PriceUnit,");
strSql.Append("Remark=@Remark,");
strSql.Append("Price4=@Price4,");
strSql.Append("Price5=@Price5,");
strSql.Append("Price6=@Price6,");
strSql.Append("Divid3=@Divid3,");
strSql.Append("Divid4=@Divid4,");
strSql.Append("Divid5=@Divid5,");
strSql.Append("ExeDate=@ExeDate,");
strSql.Append("SetNo=@SetNo,");
strSql.Append("SuiteNo=@SuiteNo,");
strSql.Append("GroupPriceNo=@GroupPriceNo,");
strSql.Append("PriceTypeCode=@PriceTypeCode,");
strSql.Append("IsStartStar=@IsStartStar,");
strSql.Append("IsStartPeople=@IsStartPeople,");
strSql.Append("PeopleCheck=@PeopleCheck,");
strSql.Append("MaxPeople=@MaxPeople,");
strSql.Append("AddUseNumber=@AddUseNumber,");
strSql.Append("StarsLevel=@StarsLevel,");
strSql.Append("StarsPeriod=@StarsPeriod,");
strSql.Append("StarsCorrected=@StarsCorrected,");
strSql.Append("IsStartArea=@IsStartArea,");
strSql.Append("Coefficient=@Coefficient,");
strSql.Append("CalculateDay=@CalculateDay,");
strSql.Append("StarsAreaWay=@StarsAreaWay,");
strSql.Append("StarsByUser=@StarsByUser");
strSql.Append(" where PriceTypeID=@PriceTypeID");
SqlParameter[] parameters =
{
new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@MeterTypeID", SqlDbType.Int, 4),
new SqlParameter("@PriceNo", SqlDbType.Int, 4),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Price2", SqlDbType.Decimal, 9),
new SqlParameter("@Price3", SqlDbType.Decimal, 9),
new SqlParameter("@Divid1", SqlDbType.Int, 4),
new SqlParameter("@Divid2", SqlDbType.Int, 4),
new SqlParameter("@PriceUnit", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@Price4", SqlDbType.Decimal, 9),
new SqlParameter("@Price5", SqlDbType.Decimal, 9),
new SqlParameter("@Price6", SqlDbType.Decimal, 9),
new SqlParameter("@Divid3", SqlDbType.Int, 4),
new SqlParameter("@Divid4", SqlDbType.Int, 4),
new SqlParameter("@Divid5", SqlDbType.Int, 4),
new SqlParameter("@ExeDate", SqlDbType.DateTime),
new SqlParameter("@SetNo", SqlDbType.Int, 4),
new SqlParameter("@SuiteNo", SqlDbType.Int, 4),
new SqlParameter("@GroupPriceNo", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeCode", SqlDbType.VarChar, 100),
new SqlParameter("@IsStartStar", SqlDbType.Int, 4),
new SqlParameter("@IsStartPeople", SqlDbType.Int, 4),
new SqlParameter("@PeopleCheck", SqlDbType.Int, 4),
new SqlParameter("@MaxPeople", SqlDbType.Int, 4),
new SqlParameter("@AddUseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@StarsLevel", SqlDbType.Int, 4),
new SqlParameter("@StarsPeriod", SqlDbType.Int, 4),
new SqlParameter("@StarsCorrected", SqlDbType.Int, 4),
new SqlParameter("@IsStartArea", SqlDbType.Int, 4),
new SqlParameter("@Coefficient", SqlDbType.Decimal, 9),
new SqlParameter("@CalculateDay", SqlDbType.Int, 4),
new SqlParameter("@StarsAreaWay", SqlDbType.Int, 4),
new SqlParameter("@StarsByUser", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.PriceTypeName;
parameters[1].Value = model.MeterTypeID;
parameters[2].Value = model.PriceNo;
parameters[3].Value = model.Price;
parameters[4].Value = model.Price2;
parameters[5].Value = model.Price3;
parameters[6].Value = model.Divid1;
parameters[7].Value = model.Divid2;
parameters[8].Value = model.PriceUnit;
parameters[9].Value = model.Remark;
parameters[10].Value = model.Price4;
parameters[11].Value = model.Price5;
parameters[12].Value = model.Price6;
parameters[13].Value = model.Divid3;
parameters[14].Value = model.Divid4;
parameters[15].Value = model.Divid5;
parameters[16].Value = model.ExeDate;
parameters[17].Value = model.SetNo;
parameters[18].Value = model.SuiteNo;
parameters[19].Value = model.GroupPriceNo;
parameters[20].Value = model.PriceTypeCode;
parameters[21].Value = model.IsStartStar;
parameters[22].Value = model.IsStartPeople;
parameters[23].Value = model.PeopleCheck;
parameters[24].Value = model.MaxPeople;
parameters[25].Value = model.AddUseNumber;
parameters[26].Value = model.StarsLevel;
parameters[27].Value = model.StarsPeriod;
parameters[28].Value = model.StarsCorrected;
parameters[29].Value = model.IsStartArea;
parameters[30].Value = model.Coefficient;
parameters[31].Value = model.CalculateDay;
parameters[32].Value = model.StarsAreaWay;
parameters[33].Value = model.StarsByUser;
parameters[34].Value = model.PriceTypeID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
