/// <summary>
/// 得到一个对象实体
/// </summary>
public RegReimbursement GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, payStatus, paymentMode, payerID, payerName, paymentDate, makeTime, makerID, makerName,hasInvoice,hasInvoiceDate,bankId,bankname,banknum,payremark ");
strSql.Append(" from RegReimbursement ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar, 50)
};
parameters[0].Value = id;
RegReimbursement model = new RegReimbursement();
DataTable dt = DBHelper.GetDataSet(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
model.id = dt.Rows[0]["id"].ToString();
if (dt.Rows[0]["payStatus"].ToString() != "")
{
model.payStatus = int.Parse(dt.Rows[0]["payStatus"].ToString());
}
if (dt.Rows[0]["paymentMode"].ToString() != "")
{
model.paymentMode = int.Parse(dt.Rows[0]["paymentMode"].ToString());
}
if (dt.Rows[0]["payerID"].ToString() != "")
{
model.payerID = int.Parse(dt.Rows[0]["payerID"].ToString());
}
model.payerName = dt.Rows[0]["payerName"].ToString();
if (dt.Rows[0]["paymentDate"].ToString() != "")
{
model.paymentDate = DateTime.Parse(dt.Rows[0]["paymentDate"].ToString());
}
if (dt.Rows[0]["makeTime"].ToString() != "")
{
model.makeTime = DateTime.Parse(dt.Rows[0]["makeTime"].ToString());
}
if (dt.Rows[0]["makerID"].ToString() != "")
{
model.makerID = int.Parse(dt.Rows[0]["makerID"].ToString());
}
model.makerName = dt.Rows[0]["makerName"].ToString();
model.payremark = dt.Rows[0]["payremark"].ToString();
model.bankName = dt.Rows[0]["bankname"].ToString();
model.bankNum = dt.Rows[0]["banknum"].ToString();
model.bankId = Convert.IsDBNull(dt.Rows[0]["bankId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["bankId"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RegReimbursement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RegReimbursement (");
strSql.Append("id,payStatus,paymentMode,payerID,payerName,paymentDate,makeTime,makerID,makerName,ausID,payremark,bankname,banknum,bankId");
strSql.Append(") values (");
strSql.Append("@id,@payStatus,@paymentMode,@payerID,@payerName,@paymentDate,@makeTime,@makerID,@makerName,@ausID,@payremark,@bankname,@banknum,@bankId");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar, 50),
new SqlParameter("@payStatus", SqlDbType.TinyInt, 1),
new SqlParameter("@paymentMode", SqlDbType.TinyInt, 1),
new SqlParameter("@payerID", SqlDbType.Int, 4),
new SqlParameter("@payerName", SqlDbType.VarChar, 50),
new SqlParameter("@paymentDate", SqlDbType.DateTime),
new SqlParameter("@makeTime", SqlDbType.DateTime),
new SqlParameter("@makerID", SqlDbType.Int, 4),
new SqlParameter("@makerName", SqlDbType.VarChar, 50),
new SqlParameter("@ausID", SqlDbType.Int, 4),
new SqlParameter("@payremark", SqlDbType.VarChar, 100),
new SqlParameter("@bankname", SqlDbType.VarChar, 100),
new SqlParameter("@banknum", SqlDbType.VarChar, 100),
new SqlParameter("@bankId", SqlDbType.Int, 4),
};
parameters[0].Value = model.id;
parameters[1].Value = model.payStatus;
parameters[2].Value = model.paymentMode;
parameters[3].Value = model.payerID;
parameters[4].Value = model.payerName;
parameters[5].Value = model.paymentDate;
parameters[6].Value = model.makeTime;
parameters[7].Value = model.makerID;
parameters[8].Value = model.makerName;
parameters[9].Value = model.ausID;
parameters[10].Value = model.payremark;
parameters[11].Value = model.bankName;
parameters[12].Value = model.bankNum;
parameters[13].Value = model.bankId;
int row = DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <RegReimbursement> DataTableToList(DataTable dt)
{
List <RegReimbursement> modelList = new List <RegReimbursement>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
RegReimbursement model;
for (int n = 0; n < rowsCount; n++)
{
model = new RegReimbursement();
model.id = dt.Rows[n]["id"].ToString();
if (dt.Rows[n]["payStatus"].ToString() != "")
{
model.payStatus = int.Parse(dt.Rows[n]["payStatus"].ToString());
}
if (dt.Rows[n]["paymentMode"].ToString() != "")
{
model.paymentMode = int.Parse(dt.Rows[n]["paymentMode"].ToString());
}
if (dt.Rows[n]["payerID"].ToString() != "")
{
model.payerID = int.Parse(dt.Rows[n]["payerID"].ToString());
}
model.payerName = dt.Rows[n]["payerName"].ToString();
if (dt.Rows[n]["paymentDate"].ToString() != "")
{
model.paymentDate = DateTime.Parse(dt.Rows[n]["paymentDate"].ToString());
}
if (dt.Rows[n]["makeTime"].ToString() != "")
{
model.makeTime = DateTime.Parse(dt.Rows[n]["makeTime"].ToString());
}
if (dt.Rows[n]["makerID"].ToString() != "")
{
model.makerID = int.Parse(dt.Rows[n]["makerID"].ToString());
}
model.makerName = dt.Rows[n]["makerName"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string paystatus = Request.QueryString["pay"];
LoadAusRottenData();
LoadFile();
LoadData();
if (paystatus == "1") //已经支付了
{
string regid = Request.QueryString["regID"].ToString().Trim();
RegReimbursementManager rem = new RegReimbursementManager();
RegReimbursement reg = rem.GetModel(regid);
this.txtPayer.Text = reg.payerName;
this.txtPaymentDate.Text = reg.paymentDate.ToString("yyyy-MM-dd");
//this.ddlPaymentMode.SelectedValue = reg.paymentMode.ToString();
this.iptremark.Value = reg.payremark.ToString();
this.btnSave.Visible = false;
this.chkIsPay.Checked = true;
this.chkIsPay.Enabled = false;
//this.ddlPaymentMode.Enabled = false;
this.iptremark.Disabled = true;
this.iptbankname.Disabled = true;
this.iptbanknum.Disabled = true;
this.txtPaymentDate.Attributes.Add("onfocus", "");
}
else
{
txtPayer.Text = (Session["login"] as LoginInfo).Cname;
txtPaymentDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
this.txtPaymentDate.CssClass = "inputLine readonly Wdate";
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(RegReimbursement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RegReimbursement set ");
strSql.Append(" id = @id , ");
strSql.Append(" payStatus = @payStatus , ");
strSql.Append(" paymentMode = @paymentMode , ");
strSql.Append(" payerID = @payerID , ");
strSql.Append(" payerName = @payerName , ");
strSql.Append(" paymentDate = @paymentDate , ");
strSql.Append(" makeTime = @makeTime , ");
strSql.Append(" makerID = @makerID , ");
strSql.Append(" makerName = @makerName, ");
strSql.Append(" payremark = @payremark, ");
strSql.Append(" bankname = @bankname, ");
strSql.Append(" banknum = @banknum, ");
strSql.Append(" bankId = @bankId ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar, 50),
new SqlParameter("@payStatus", SqlDbType.TinyInt, 1),
new SqlParameter("@paymentMode", SqlDbType.TinyInt, 1),
new SqlParameter("@payerID", SqlDbType.Int, 4),
new SqlParameter("@payerName", SqlDbType.VarChar, 50),
new SqlParameter("@paymentDate", SqlDbType.DateTime),
new SqlParameter("@makeTime", SqlDbType.DateTime),
new SqlParameter("@makerID", SqlDbType.Int, 4),
new SqlParameter("@makerName", SqlDbType.VarChar, 50),
new SqlParameter("@payremark", SqlDbType.VarChar, 100),
new SqlParameter("@bankname", SqlDbType.VarChar, 100),
new SqlParameter("@banknum", SqlDbType.VarChar, 100),
new SqlParameter("@bankId", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.payStatus;
parameters[2].Value = model.paymentMode;
parameters[3].Value = model.payerID;
parameters[4].Value = model.payerName;
parameters[5].Value = model.paymentDate;
parameters[6].Value = model.makeTime;
parameters[7].Value = model.makerID;
parameters[8].Value = model.makerName;
parameters[9].Value = model.payremark;
parameters[10].Value = model.bankName;
parameters[11].Value = model.bankNum;
parameters[12].Value = model.bankId;
int rows = DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(RegReimbursement model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RegReimbursement model)
{
return(dal.Add(model));
}
/// <summary>
/// 保存报销登记，保存的信息有（其他信息保存到RegReimbursement表中）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
#region 无用代码
///////////
//EtNet_Models.RegReimbursement mReg = new RegReimbursement();
//LoginInfo currentUser = Session["login"] as LoginInfo;
//mReg.id = Guid.NewGuid().ToString();
//mReg.makerID = currentUser.Id;
//mReg.makerName = currentUser.Cname;
//mReg.makeTime = DateTime.Now;
//mReg.payerID = currentUser.Id;
//mReg.payerName = currentUser.Cname;
//mReg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim());
//mReg.paymentMode = int.Parse(ddlPaymentMode.SelectedValue.Trim());
//mReg.payStatus = chkIsPay.Checked ? 1 : 0;
//mReg.hasInvoice = int.Parse(ddlHasInvoiceNum.SelectedValue.Trim());
//if (txtHasInvoceDate.Text.Trim() != "") //收到发票日期
//{
// mReg.hasInvoiceDate = Convert.ToDateTime(txtHasInvoceDate.Text);
//}
//if (Request.QueryString["ausID"] != null)
//{
// int ausID;
// int.TryParse(Request.QueryString["ausID"].ToString(), out ausID);
// mReg.ausID = ausID;
//}
//RegReimbursementManager bReg = new RegReimbursementManager();
//ReimbursementInvoice mRI = new ReimbursementInvoice();
//ReimbursementInvoiceManager bRI = new ReimbursementInvoiceManager();
//if (Request.QueryString["regID"] != null && Request.QueryString["regID"].ToString().Trim() != string.Empty)
//{
// string regID = Request.QueryString["regID"].ToString().Trim();
// if (string.Empty != regID)
// {
// mReg = bReg.GetModel(regID);
// if (mReg != null)
// {
// mReg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim());
// mReg.paymentMode = int.Parse(ddlPaymentMode.SelectedValue.Trim());
// mReg.payStatus = chkIsPay.Checked ? 1 : 0;
// mReg.hasInvoice = int.Parse(ddlHasInvoiceNum.SelectedValue.Trim());
// if (this.txtHasInvoceDate.Text.Trim() != "")
// {
// mReg.hasInvoiceDate = Convert.ToDateTime(this.txtHasInvoceDate.Text);
// }
// bReg.Update(mReg);
// bRI.DeleteByRegID(regID);
// }
// }
//}
//else
// bReg.Add(mReg);
//string jsonString = hidInvoiceDate.Value;
//List<InvoiceData> invoiceList = ReadJson(jsonString);
//mRI.reimbursementID = mReg.id;
//for (int i = 0, len = invoiceList.Count(); i < len; i++)
//{
// InvoiceData invoiceData = invoiceList[i];
// mRI.id = Guid.NewGuid().ToString();
// mRI.invoiceNum = invoiceData.Num;
// mRI.remark = invoiceData.Remark;
// if (mRI.invoiceNum.Trim() == string.Empty && mRI.remark.Trim() == string.Empty)
// break;
// bRI.Add(mRI);
//}
//ClientScript.RegisterStartupScript(Page.GetType(), "a", "alert('保存成功');self.location.href='RegReimbursedFormList.aspx';", true);
#endregion
EtNet_Models.RegReimbursement reg = new RegReimbursement();
LoginInfo payUser = Session["login"] as LoginInfo;
if (Request.QueryString["ausID"] != null)
{
int ausID;
int.TryParse(Request.QueryString["ausID"].ToString(), out ausID);
reg.ausID = ausID;
}
reg.makerName = this.lblcanme.Text; //报销人员
reg.makeTime = DateTime.Parse(this.lblapplydate.Text.Trim()); //报销日期
reg.makerID = LoginInfoManager.getLoginIDByname(this.lblcanme.Text.Trim()); //得到报销人员关联id
reg.payStatus = chkIsPay.Checked ? 1 : 0; //费用是否支付
reg.paymentMode = 1; /* int.Parse(ddlPaymentMode.SelectedValue.Trim()); //支付方式*/
reg.payerID = payUser.Id; //支付人关联id
reg.payerName = payUser.Cname; //支付人名字
reg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); //支付时间
reg.payremark = this.iptremark.Value; //支付备注
reg.bankName = this.iptbankname.Value; //支付银行
reg.bankNum = this.iptbanknum.Value; //支付帐号
reg.bankId = int.Parse(this.hidbankid.Value); //支付银行对应id
RegReimbursementManager regmanager = new RegReimbursementManager();
if (Request.QueryString["regID"] != null && Request.QueryString["regID"].ToString().Trim() != string.Empty)
{
string regID = Request.QueryString["regID"].ToString().Trim();
if (string.Empty != regID)
{
reg = regmanager.GetModel(regID);
if (reg != null)
{
reg.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim());
reg.paymentMode = 1; /* int.Parse(ddlPaymentMode.SelectedValue.Trim());*/
reg.payStatus = chkIsPay.Checked ? 1 : 0;
reg.payremark = this.iptremark.Value;
reg.bankName = this.iptbankname.Value;
reg.bankNum = this.iptbanknum.Value;
reg.bankId = int.Parse(this.hidbankid.Value);
regmanager.Update(reg);
}
}
}
else
{
reg.id = Guid.NewGuid().ToString(); //id主键
regmanager.Add(reg);
}
ClientScript.RegisterStartupScript(Page.GetType(), "a", "alert('保存成功');self.location.href='RegReimbursedFormList.aspx';", true);
}
