private void ShowInfo(int OperID)
{
WebDemo.BLL.WebDemo.OperationDay bll = new WebDemo.BLL.WebDemo.OperationDay();
WebDemo.Model.WebDemo.OperationDay model = bll.GetModel(OperID);
this.lblOperID.Text = model.OperID.ToString();
this.txtMeterID.Text = model.MeterID.ToString();
this.txtBeginMonth.Text = model.BeginMonth;
this.txtBeginNumber.Text = model.BeginNumber.ToString();
this.txtEndMonth.Text = model.EndMonth;
this.txtEndNumber.Text = model.EndNumber.ToString();
this.txtUseNumber.Text = model.UseNumber.ToString();
this.txtPriceTypeID.Text = model.PriceTypeID.ToString();
this.txtPriceTypeName.Text = model.PriceTypeName;
this.txtPrice.Text = model.Price.ToString();
this.txtPrice2.Text = model.Price2.ToString();
this.txtPrice3.Text = model.Price3.ToString();
this.txtFareMoney.Text = model.FareMoney.ToString();
this.txtPayMark.Text = model.PayMark.ToString();
this.txtOperType.Text = model.OperType.ToString();
this.lblOperDate.Text = model.OperDate.ToString();
this.txtOperatorID.Text = model.OperatorID.ToString();
this.txtopermonth.Text = model.opermonth;
this.txtMeterNumber.Text = model.MeterNumber.ToString();
this.txtDivid1.Text = model.Divid1.ToString();
this.txtDivid2.Text = model.Divid2.ToString();
this.txtUseNumber1.Text = model.UseNumber1.ToString();
this.txtUseNumber2.Text = model.UseNumber2.ToString();
this.txtUseNumber3.Text = model.UseNumber3.ToString();
this.txtExtData1.Text = model.ExtData1;
this.txtExtData2.Text = model.ExtData2;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.OperationDay GetModel(int OperID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OperID,MeterID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,MeterNumber,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2 from OperationDay ");
strSql.Append(" where OperID=@OperID");
SqlParameter[] parameters =
{
new SqlParameter("@OperID", SqlDbType.Int, 4)
};
parameters[0].Value = OperID;
WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.OperationDay model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OperationDay(");
strSql.Append("MeterID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,MeterNumber,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2)");
strSql.Append(" values (");
strSql.Append("@MeterID,@BeginMonth,@BeginNumber,@EndMonth,@EndNumber,@UseNumber,@PriceTypeID,@PriceTypeName,@Price,@Price2,@Price3,@FareMoney,@PayMark,@OperType,@OperDate,@OperatorID,@opermonth,@MeterNumber,@Divid1,@Divid2,@UseNumber1,@UseNumber2,@UseNumber3,@ExtData1,@ExtData2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@BeginMonth", SqlDbType.VarChar, 10),
new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9),
new SqlParameter("@EndMonth", SqlDbType.VarChar, 10),
new SqlParameter("@EndNumber", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Price2", SqlDbType.Decimal, 9),
new SqlParameter("@Price3", SqlDbType.Decimal, 9),
new SqlParameter("@FareMoney", SqlDbType.Decimal, 9),
new SqlParameter("@PayMark", SqlDbType.Int, 4),
new SqlParameter("@OperType", SqlDbType.Int, 4),
new SqlParameter("@OperDate", SqlDbType.DateTime),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@opermonth", SqlDbType.VarChar, 10),
new SqlParameter("@MeterNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Divid1", SqlDbType.Int, 4),
new SqlParameter("@Divid2", SqlDbType.Int, 4),
new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9),
new SqlParameter("@ExtData1", SqlDbType.VarChar, 50),
new SqlParameter("@ExtData2", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.MeterID;
parameters[1].Value = model.BeginMonth;
parameters[2].Value = model.BeginNumber;
parameters[3].Value = model.EndMonth;
parameters[4].Value = model.EndNumber;
parameters[5].Value = model.UseNumber;
parameters[6].Value = model.PriceTypeID;
parameters[7].Value = model.PriceTypeName;
parameters[8].Value = model.Price;
parameters[9].Value = model.Price2;
parameters[10].Value = model.Price3;
parameters[11].Value = model.FareMoney;
parameters[12].Value = model.PayMark;
parameters[13].Value = model.OperType;
parameters[14].Value = model.OperDate;
parameters[15].Value = model.OperatorID;
parameters[16].Value = model.opermonth;
parameters[17].Value = model.MeterNumber;
parameters[18].Value = model.Divid1;
parameters[19].Value = model.Divid2;
parameters[20].Value = model.UseNumber1;
parameters[21].Value = model.UseNumber2;
parameters[22].Value = model.UseNumber3;
parameters[23].Value = model.ExtData1;
parameters[24].Value = model.ExtData2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.OperationDay DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay();
if (row != null)
{
if (row["OperID"] != null && row["OperID"].ToString() != "")
{
model.OperID = int.Parse(row["OperID"].ToString());
}
if (row["MeterID"] != null && row["MeterID"].ToString() != "")
{
model.MeterID = int.Parse(row["MeterID"].ToString());
}
if (row["BeginMonth"] != null)
{
model.BeginMonth = row["BeginMonth"].ToString();
}
if (row["BeginNumber"] != null && row["BeginNumber"].ToString() != "")
{
model.BeginNumber = decimal.Parse(row["BeginNumber"].ToString());
}
if (row["EndMonth"] != null)
{
model.EndMonth = row["EndMonth"].ToString();
}
if (row["EndNumber"] != null && row["EndNumber"].ToString() != "")
{
model.EndNumber = decimal.Parse(row["EndNumber"].ToString());
}
if (row["UseNumber"] != null && row["UseNumber"].ToString() != "")
{
model.UseNumber = decimal.Parse(row["UseNumber"].ToString());
}
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["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["FareMoney"] != null && row["FareMoney"].ToString() != "")
{
model.FareMoney = decimal.Parse(row["FareMoney"].ToString());
}
if (row["PayMark"] != null && row["PayMark"].ToString() != "")
{
model.PayMark = int.Parse(row["PayMark"].ToString());
}
if (row["OperType"] != null && row["OperType"].ToString() != "")
{
model.OperType = int.Parse(row["OperType"].ToString());
}
if (row["OperDate"] != null && row["OperDate"].ToString() != "")
{
model.OperDate = DateTime.Parse(row["OperDate"].ToString());
}
if (row["OperatorID"] != null && row["OperatorID"].ToString() != "")
{
model.OperatorID = int.Parse(row["OperatorID"].ToString());
}
if (row["opermonth"] != null)
{
model.opermonth = row["opermonth"].ToString();
}
if (row["MeterNumber"] != null && row["MeterNumber"].ToString() != "")
{
model.MeterNumber = decimal.Parse(row["MeterNumber"].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["UseNumber1"] != null && row["UseNumber1"].ToString() != "")
{
model.UseNumber1 = decimal.Parse(row["UseNumber1"].ToString());
}
if (row["UseNumber2"] != null && row["UseNumber2"].ToString() != "")
{
model.UseNumber2 = decimal.Parse(row["UseNumber2"].ToString());
}
if (row["UseNumber3"] != null && row["UseNumber3"].ToString() != "")
{
model.UseNumber3 = decimal.Parse(row["UseNumber3"].ToString());
}
if (row["ExtData1"] != null)
{
model.ExtData1 = row["ExtData1"].ToString();
}
if (row["ExtData2"] != null)
{
model.ExtData2 = row["ExtData2"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.OperationDay model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OperationDay set ");
strSql.Append("MeterID=@MeterID,");
strSql.Append("BeginMonth=@BeginMonth,");
strSql.Append("BeginNumber=@BeginNumber,");
strSql.Append("EndMonth=@EndMonth,");
strSql.Append("EndNumber=@EndNumber,");
strSql.Append("UseNumber=@UseNumber,");
strSql.Append("PriceTypeID=@PriceTypeID,");
strSql.Append("PriceTypeName=@PriceTypeName,");
strSql.Append("Price=@Price,");
strSql.Append("Price2=@Price2,");
strSql.Append("Price3=@Price3,");
strSql.Append("FareMoney=@FareMoney,");
strSql.Append("PayMark=@PayMark,");
strSql.Append("OperType=@OperType,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("opermonth=@opermonth,");
strSql.Append("MeterNumber=@MeterNumber,");
strSql.Append("Divid1=@Divid1,");
strSql.Append("Divid2=@Divid2,");
strSql.Append("UseNumber1=@UseNumber1,");
strSql.Append("UseNumber2=@UseNumber2,");
strSql.Append("UseNumber3=@UseNumber3,");
strSql.Append("ExtData1=@ExtData1,");
strSql.Append("ExtData2=@ExtData2");
strSql.Append(" where OperID=@OperID");
SqlParameter[] parameters =
{
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@BeginMonth", SqlDbType.VarChar, 10),
new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9),
new SqlParameter("@EndMonth", SqlDbType.VarChar, 10),
new SqlParameter("@EndNumber", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Price2", SqlDbType.Decimal, 9),
new SqlParameter("@Price3", SqlDbType.Decimal, 9),
new SqlParameter("@FareMoney", SqlDbType.Decimal, 9),
new SqlParameter("@PayMark", SqlDbType.Int, 4),
new SqlParameter("@OperType", SqlDbType.Int, 4),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@opermonth", SqlDbType.VarChar, 10),
new SqlParameter("@MeterNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Divid1", SqlDbType.Int, 4),
new SqlParameter("@Divid2", SqlDbType.Int, 4),
new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9),
new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9),
new SqlParameter("@ExtData1", SqlDbType.VarChar, 50),
new SqlParameter("@ExtData2", SqlDbType.VarChar, 50),
new SqlParameter("@OperID", SqlDbType.Int, 4),
new SqlParameter("@OperDate", SqlDbType.DateTime)
};
parameters[0].Value = model.MeterID;
parameters[1].Value = model.BeginMonth;
parameters[2].Value = model.BeginNumber;
parameters[3].Value = model.EndMonth;
parameters[4].Value = model.EndNumber;
parameters[5].Value = model.UseNumber;
parameters[6].Value = model.PriceTypeID;
parameters[7].Value = model.PriceTypeName;
parameters[8].Value = model.Price;
parameters[9].Value = model.Price2;
parameters[10].Value = model.Price3;
parameters[11].Value = model.FareMoney;
parameters[12].Value = model.PayMark;
parameters[13].Value = model.OperType;
parameters[14].Value = model.OperatorID;
parameters[15].Value = model.opermonth;
parameters[16].Value = model.MeterNumber;
parameters[17].Value = model.Divid1;
parameters[18].Value = model.Divid2;
parameters[19].Value = model.UseNumber1;
parameters[20].Value = model.UseNumber2;
parameters[21].Value = model.UseNumber3;
parameters[22].Value = model.ExtData1;
parameters[23].Value = model.ExtData2;
parameters[24].Value = model.OperID;
parameters[25].Value = model.OperDate;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtMeterID.Text))
{
strErr += "MeterID格式错误！\\n";
}
if (this.txtBeginMonth.Text.Trim().Length == 0)
{
strErr += "BeginMonth不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtBeginNumber.Text))
{
strErr += "BeginNumber格式错误！\\n";
}
if (this.txtEndMonth.Text.Trim().Length == 0)
{
strErr += "EndMonth不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtEndNumber.Text))
{
strErr += "EndNumber格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtUseNumber.Text))
{
strErr += "UseNumber格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPriceTypeID.Text))
{
strErr += "PriceTypeID格式错误！\\n";
}
if (this.txtPriceTypeName.Text.Trim().Length == 0)
{
strErr += "PriceTypeName不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtPrice.Text))
{
strErr += "Price格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice2.Text))
{
strErr += "Price2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPrice3.Text))
{
strErr += "Price3格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtFareMoney.Text))
{
strErr += "FareMoney格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPayMark.Text))
{
strErr += "PayMark格式错误！\\n";
}
if (!PageValidate.IsNumber(txtOperType.Text))
{
strErr += "OperType格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtOperDate.Text))
{
strErr += "业务时间格式错误！\\n";
}
if (!PageValidate.IsNumber(txtOperatorID.Text))
{
strErr += "OperatorID格式错误！\\n";
}
if (this.txtopermonth.Text.Trim().Length == 0)
{
strErr += "opermonth不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtMeterNumber.Text))
{
strErr += "MeterNumber格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid1.Text))
{
strErr += "Divid1格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDivid2.Text))
{
strErr += "Divid2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtUseNumber1.Text))
{
strErr += "UseNumber1格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtUseNumber2.Text))
{
strErr += "UseNumber2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtUseNumber3.Text))
{
strErr += "UseNumber3格式错误！\\n";
}
if (this.txtExtData1.Text.Trim().Length == 0)
{
strErr += "ExtData1不能为空！\\n";
}
if (this.txtExtData2.Text.Trim().Length == 0)
{
strErr += "ExtData2不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int MeterID = int.Parse(this.txtMeterID.Text);
string BeginMonth = this.txtBeginMonth.Text;
decimal BeginNumber = decimal.Parse(this.txtBeginNumber.Text);
string EndMonth = this.txtEndMonth.Text;
decimal EndNumber = decimal.Parse(this.txtEndNumber.Text);
decimal UseNumber = decimal.Parse(this.txtUseNumber.Text);
int PriceTypeID = int.Parse(this.txtPriceTypeID.Text);
string PriceTypeName = this.txtPriceTypeName.Text;
decimal Price = decimal.Parse(this.txtPrice.Text);
decimal Price2 = decimal.Parse(this.txtPrice2.Text);
decimal Price3 = decimal.Parse(this.txtPrice3.Text);
decimal FareMoney = decimal.Parse(this.txtFareMoney.Text);
int PayMark = int.Parse(this.txtPayMark.Text);
int OperType = int.Parse(this.txtOperType.Text);
DateTime OperDate = DateTime.Parse(this.txtOperDate.Text);
int OperatorID = int.Parse(this.txtOperatorID.Text);
string opermonth = this.txtopermonth.Text;
decimal MeterNumber = decimal.Parse(this.txtMeterNumber.Text);
int Divid1 = int.Parse(this.txtDivid1.Text);
int Divid2 = int.Parse(this.txtDivid2.Text);
decimal UseNumber1 = decimal.Parse(this.txtUseNumber1.Text);
decimal UseNumber2 = decimal.Parse(this.txtUseNumber2.Text);
decimal UseNumber3 = decimal.Parse(this.txtUseNumber3.Text);
string ExtData1 = this.txtExtData1.Text;
string ExtData2 = this.txtExtData2.Text;
WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay();
model.MeterID = MeterID;
model.BeginMonth = BeginMonth;
model.BeginNumber = BeginNumber;
model.EndMonth = EndMonth;
model.EndNumber = EndNumber;
model.UseNumber = UseNumber;
model.PriceTypeID = PriceTypeID;
model.PriceTypeName = PriceTypeName;
model.Price = Price;
model.Price2 = Price2;
model.Price3 = Price3;
model.FareMoney = FareMoney;
model.PayMark = PayMark;
model.OperType = OperType;
model.OperDate = OperDate;
model.OperatorID = OperatorID;
model.opermonth = opermonth;
model.MeterNumber = MeterNumber;
model.Divid1 = Divid1;
model.Divid2 = Divid2;
model.UseNumber1 = UseNumber1;
model.UseNumber2 = UseNumber2;
model.UseNumber3 = UseNumber3;
model.ExtData1 = ExtData1;
model.ExtData2 = ExtData2;
WebDemo.BLL.WebDemo.OperationDay bll = new WebDemo.BLL.WebDemo.OperationDay();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
