/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.MultiOperation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MultiOperation(");
strSql.Append("MultiUserID,CardID,CardSector,OperMoney,LastBalance,CurrentBalance,TotalMoney,OperType,InvoiceCode,OperDate,OperatorID,Remark,InvoiceID,InvoiceType)");
strSql.Append(" values (");
strSql.Append("@MultiUserID,@CardID,@CardSector,@OperMoney,@LastBalance,@CurrentBalance,@TotalMoney,@OperType,@InvoiceCode,@OperDate,@OperatorID,@Remark,@InvoiceID,@InvoiceType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MultiUserID", SqlDbType.Int, 4),
new SqlParameter("@CardID", SqlDbType.Int, 4),
new SqlParameter("@CardSector", SqlDbType.Int, 4),
new SqlParameter("@OperMoney", SqlDbType.Decimal, 9),
new SqlParameter("@LastBalance", SqlDbType.Decimal, 9),
new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OperType", SqlDbType.Int, 4),
new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50),
new SqlParameter("@OperDate", SqlDbType.DateTime),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@InvoiceID", SqlDbType.Int, 4),
new SqlParameter("@InvoiceType", SqlDbType.Int, 4)
};
parameters[0].Value = model.MultiUserID;
parameters[1].Value = model.CardID;
parameters[2].Value = model.CardSector;
parameters[3].Value = model.OperMoney;
parameters[4].Value = model.LastBalance;
parameters[5].Value = model.CurrentBalance;
parameters[6].Value = model.TotalMoney;
parameters[7].Value = model.OperType;
parameters[8].Value = model.InvoiceCode;
parameters[9].Value = model.OperDate;
parameters[10].Value = model.OperatorID;
parameters[11].Value = model.Remark;
parameters[12].Value = model.InvoiceID;
parameters[13].Value = model.InvoiceType;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int OperID)
{
WebDemo.BLL.WebDemo.MultiOperation bll = new WebDemo.BLL.WebDemo.MultiOperation();
WebDemo.Model.WebDemo.MultiOperation model = bll.GetModel(OperID);
this.lblOperID.Text = model.OperID.ToString();
this.lblMultiUserID.Text = model.MultiUserID.ToString();
this.lblCardID.Text = model.CardID.ToString();
this.lblCardSector.Text = model.CardSector.ToString();
this.lblOperMoney.Text = model.OperMoney.ToString();
this.lblLastBalance.Text = model.LastBalance.ToString();
this.lblCurrentBalance.Text = model.CurrentBalance.ToString();
this.lblTotalMoney.Text = model.TotalMoney.ToString();
this.lblOperType.Text = model.OperType.ToString();
this.lblInvoiceCode.Text = model.InvoiceCode;
this.lblOperDate.Text = model.OperDate.ToString();
this.lblOperatorID.Text = model.OperatorID.ToString();
this.lblRemark.Text = model.Remark;
this.lblInvoiceID.Text = model.InvoiceID.ToString();
this.lblInvoiceType.Text = model.InvoiceType.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MultiOperation GetModel(int OperID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OperID,MultiUserID,CardID,CardSector,OperMoney,LastBalance,CurrentBalance,TotalMoney,OperType,InvoiceCode,OperDate,OperatorID,Remark,InvoiceID,InvoiceType from MultiOperation ");
strSql.Append(" where OperID=@OperID");
SqlParameter[] parameters =
{
new SqlParameter("@OperID", SqlDbType.Int, 4)
};
parameters[0].Value = OperID;
WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation();
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 (!PageValidate.IsNumber(txtMultiUserID.Text))
{
strErr += "MultiUserID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCardID.Text))
{
strErr += "CardID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCardSector.Text))
{
strErr += "CardSector格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtOperMoney.Text))
{
strErr += "OperMoney格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtLastBalance.Text))
{
strErr += "LastBalance格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtCurrentBalance.Text))
{
strErr += "CurrentBalance格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtTotalMoney.Text))
{
strErr += "TotalMoney格式错误！\\n";
}
if (!PageValidate.IsNumber(txtOperType.Text))
{
strErr += "OperType格式错误！\\n";
}
if (this.txtInvoiceCode.Text.Trim().Length == 0)
{
strErr += "InvoiceCode不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtOperDate.Text))
{
strErr += "OperDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtOperatorID.Text))
{
strErr += "OperatorID格式错误！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "Remark不能为空！\\n";
}
if (!PageValidate.IsNumber(txtInvoiceID.Text))
{
strErr += "InvoiceID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtInvoiceType.Text))
{
strErr += "InvoiceType格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int MultiUserID = int.Parse(this.txtMultiUserID.Text);
int CardID = int.Parse(this.txtCardID.Text);
int CardSector = int.Parse(this.txtCardSector.Text);
decimal OperMoney = decimal.Parse(this.txtOperMoney.Text);
decimal LastBalance = decimal.Parse(this.txtLastBalance.Text);
decimal CurrentBalance = decimal.Parse(this.txtCurrentBalance.Text);
decimal TotalMoney = decimal.Parse(this.txtTotalMoney.Text);
int OperType = int.Parse(this.txtOperType.Text);
string InvoiceCode = this.txtInvoiceCode.Text;
DateTime OperDate = DateTime.Parse(this.txtOperDate.Text);
int OperatorID = int.Parse(this.txtOperatorID.Text);
string Remark = this.txtRemark.Text;
int InvoiceID = int.Parse(this.txtInvoiceID.Text);
int InvoiceType = int.Parse(this.txtInvoiceType.Text);
WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation();
model.MultiUserID = MultiUserID;
model.CardID = CardID;
model.CardSector = CardSector;
model.OperMoney = OperMoney;
model.LastBalance = LastBalance;
model.CurrentBalance = CurrentBalance;
model.TotalMoney = TotalMoney;
model.OperType = OperType;
model.InvoiceCode = InvoiceCode;
model.OperDate = OperDate;
model.OperatorID = OperatorID;
model.Remark = Remark;
model.InvoiceID = InvoiceID;
model.InvoiceType = InvoiceType;
WebDemo.BLL.WebDemo.MultiOperation bll = new WebDemo.BLL.WebDemo.MultiOperation();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MultiOperation DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation();
if (row != null)
{
if (row["OperID"] != null && row["OperID"].ToString() != "")
{
model.OperID = int.Parse(row["OperID"].ToString());
}
if (row["MultiUserID"] != null && row["MultiUserID"].ToString() != "")
{
model.MultiUserID = int.Parse(row["MultiUserID"].ToString());
}
if (row["CardID"] != null && row["CardID"].ToString() != "")
{
model.CardID = int.Parse(row["CardID"].ToString());
}
if (row["CardSector"] != null && row["CardSector"].ToString() != "")
{
model.CardSector = int.Parse(row["CardSector"].ToString());
}
if (row["OperMoney"] != null && row["OperMoney"].ToString() != "")
{
model.OperMoney = decimal.Parse(row["OperMoney"].ToString());
}
if (row["LastBalance"] != null && row["LastBalance"].ToString() != "")
{
model.LastBalance = decimal.Parse(row["LastBalance"].ToString());
}
if (row["CurrentBalance"] != null && row["CurrentBalance"].ToString() != "")
{
model.CurrentBalance = decimal.Parse(row["CurrentBalance"].ToString());
}
if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "")
{
model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString());
}
if (row["OperType"] != null && row["OperType"].ToString() != "")
{
model.OperType = int.Parse(row["OperType"].ToString());
}
if (row["InvoiceCode"] != null)
{
model.InvoiceCode = row["InvoiceCode"].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["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["InvoiceID"] != null && row["InvoiceID"].ToString() != "")
{
model.InvoiceID = int.Parse(row["InvoiceID"].ToString());
}
if (row["InvoiceType"] != null && row["InvoiceType"].ToString() != "")
{
model.InvoiceType = int.Parse(row["InvoiceType"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.MultiOperation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MultiOperation set ");
strSql.Append("MultiUserID=@MultiUserID,");
strSql.Append("CardID=@CardID,");
strSql.Append("CardSector=@CardSector,");
strSql.Append("OperMoney=@OperMoney,");
strSql.Append("LastBalance=@LastBalance,");
strSql.Append("CurrentBalance=@CurrentBalance,");
strSql.Append("TotalMoney=@TotalMoney,");
strSql.Append("OperType=@OperType,");
strSql.Append("InvoiceCode=@InvoiceCode,");
strSql.Append("OperDate=@OperDate,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("Remark=@Remark,");
strSql.Append("InvoiceID=@InvoiceID,");
strSql.Append("InvoiceType=@InvoiceType");
strSql.Append(" where OperID=@OperID");
SqlParameter[] parameters =
{
new SqlParameter("@MultiUserID", SqlDbType.Int, 4),
new SqlParameter("@CardID", SqlDbType.Int, 4),
new SqlParameter("@CardSector", SqlDbType.Int, 4),
new SqlParameter("@OperMoney", SqlDbType.Decimal, 9),
new SqlParameter("@LastBalance", SqlDbType.Decimal, 9),
new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OperType", SqlDbType.Int, 4),
new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50),
new SqlParameter("@OperDate", SqlDbType.DateTime),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@InvoiceID", SqlDbType.Int, 4),
new SqlParameter("@InvoiceType", SqlDbType.Int, 4),
new SqlParameter("@OperID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MultiUserID;
parameters[1].Value = model.CardID;
parameters[2].Value = model.CardSector;
parameters[3].Value = model.OperMoney;
parameters[4].Value = model.LastBalance;
parameters[5].Value = model.CurrentBalance;
parameters[6].Value = model.TotalMoney;
parameters[7].Value = model.OperType;
parameters[8].Value = model.InvoiceCode;
parameters[9].Value = model.OperDate;
parameters[10].Value = model.OperatorID;
parameters[11].Value = model.Remark;
parameters[12].Value = model.InvoiceID;
parameters[13].Value = model.InvoiceType;
parameters[14].Value = model.OperID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
