/// <summary>
/// 得到一个对象实体
/// </summary>
public Bill_TravelApplication GetModel(string maincode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" where maincode=@maincode ");
SqlParameter[] parameters =
{
new SqlParameter("@maincode", SqlDbType.VarChar, 50)
};
parameters[0].Value = maincode;
Bill_TravelApplication model = new Bill_TravelApplication();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.maincode = dr["maincode"].ToString();
if (!DBNull.Value.Equals(dr["MoreThanStandard"]))
{
model.MoreThanStandard = int.Parse(dr["MoreThanStandard"].ToString());
}
model.typecode = dr["typecode"].ToString();
model.travelPersionCode = dr["travelPersionCode"].ToString();
model.arrdess = dr["arrdess"].ToString();
if (!DBNull.Value.Equals(dr["travelDate"]))
{
model.travelDate = dr["travelDate"].ToString();
}
model.reasion = dr["reasion"].ToString();
model.travelplan = dr["travelplan"].ToString();
if (!DBNull.Value.Equals(dr["needAmount"]))
{
model.needAmount = int.Parse(dr["needAmount"].ToString());
}
model.Transport = dr["Transport"].ToString();
model.ReportCode = dr["ReportCode"].ToString();
model.sendDept = dr["sendDept"].ToString();
model.Transport = dr["Transport"].ToString();
model.jiaotongfei = int.Parse(dr["jiaotongfei"].ToString());
model.zhusufei = int.Parse(dr["zhusufei"].ToString());
model.yewuzhaodaifei = int.Parse(dr["yewuzhaodaifei"].ToString());
model.huiyifei = int.Parse(dr["huiyifei"].ToString());
model.yinshuafei = int.Parse(dr["yinshuafei"].ToString());
model.qitafei = int.Parse(dr["qitafei"].ToString());
return(model);
}
else
{
return(null);
}
}
}
public int Add(Bill_TravelApplication model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int iRel = Add(model, tran);
tran.Commit();
return(iRel);
}
catch
{
tran.Rollback();
throw;
}
}
}
public IList <Bill_TravelApplication> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <Bill_TravelApplication> list = new List <Bill_TravelApplication>();
foreach (DataRow dr in dt.Rows)
{
Bill_TravelApplication model = new Bill_TravelApplication();
model.maincode = dr["maincode"].ToString();
if (!DBNull.Value.Equals(dr["MoreThanStandard"]))
{
model.MoreThanStandard = int.Parse(dr["MoreThanStandard"].ToString());
}
model.typecode = dr["typecode"].ToString();
model.travelPersionCode = dr["travelPersionCode"].ToString();
model.arrdess = dr["arrdess"].ToString();
model.ReportCode = dr["ReportCode"].ToString();
if (!DBNull.Value.Equals(dr["travelDate"]))
{
model.travelDate = dr["travelDate"].ToString();
}
model.reasion = dr["reasion"].ToString();
model.sendDept = dr["sendDept"].ToString();
model.travelplan = dr["travelplan"].ToString();
if (!DBNull.Value.Equals(dr["needAmount"]))
{
model.needAmount = int.Parse(dr["needAmount"].ToString());
}
model.Transport = dr["Transport"].ToString();
model.jiaotongfei = int.Parse(dr["jiaotongfei"].ToString().Equals("") ? "0" : dr["jiaotongfei"].ToString());
model.zhusufei = int.Parse(dr["zhusufei"].ToString().Equals("") ? "0" : dr["zhusufei"].ToString());
model.yewuzhaodaifei = int.Parse(dr["yewuzhaodaifei"].ToString().Equals("") ? "0" : dr["yewuzhaodaifei"].ToString());
model.huiyifei = int.Parse(dr["huiyifei"].ToString().Equals("") ? "0" : dr["huiyifei"].ToString());
model.yinshuafei = int.Parse(dr["yinshuafei"].ToString().Equals("") ? "0" : dr["yinshuafei"].ToString());
model.qitafei = int.Parse(dr["qitafei"].ToString().Equals("") ? "0" : dr["qitafei"].ToString());
list.Add(model);
}
return(list);
}
protected void btnSave_Click(object sender, EventArgs e)
{
bill_travelApplicationBLL bllTravelApplication = new bill_travelApplicationBLL();
string strCtrl = Request["type"];
string strBillCode = Request["billCode"];
string str_billuser = PubMethod.SubString(txt_billUser.Text);
string users = hfuser.Value;
if (string.IsNullOrEmpty(users))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('出差人不能为空！');", true);
return;
}
string[] userArr = users.Split(',');
string travelPersons = "";
for (int i = 0; i < userArr.Length; i++)
{
if (travelPersons.IndexOf(userArr[i]) != -1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('有重复的出差人！');", true);
return;
}
travelPersons += "|&|" + PubMethod.SubString(userArr[i]);
}
string str_billdate = txt_billDate.Text.Trim();
string str_billdept = server.GetCellValue("select userdept from bill_users where usercode='" + str_billuser + "'");
string bm = PubMethod.SubString(txt_userDept.Text);
//申请表
Bill_TravelApplication modelTravelApplication = new Bill_TravelApplication();
//主表
Bill_Main modelMainBill = new Bill_Main();
string strMsg = "";
try
{
//添加修改
if (strCtrl.Equals("edit") && strBillCode.Equals(""))
{
if (strBillCode.Equals(""))
{
throw new Exception("单号丢失！");
}
modelTravelApplication = bllTravelApplication.GetModel(strBillCode);
}
//添加
modelMainBill.BillName = "出差管理单";
modelMainBill.BillType = "";
modelMainBill.BillUser = str_billuser;
modelMainBill.FlowId = "ccsq";
modelMainBill.GkDept = "";
modelMainBill.IsGk = "";
modelMainBill.LoopTimes = 0;
modelMainBill.StepId = "-1";
//出差申请单表
modelTravelApplication.arrdess = this.txt_address.Text.Trim();
modelTravelApplication.maincode = txt_bh.Text.Trim();
modelTravelApplication.MoreThanStandard = Convert.ToInt32(ddlIsbz.SelectedValue);
//modelTravelApplication.needAmount = int.Parse(this.txtFeePlan.Text.Trim());
modelTravelApplication.reasion = this.txt_reasion.Text.Trim();
modelTravelApplication.Transport = this.txt_jtgj.Text.Trim();
modelTravelApplication.travelDate = this.txt_travelDate.Text.Trim();
modelTravelApplication.sendDept = PubMethod.SubString(txt_bm.Text);
string strAppPersion = this.txt_billUser.Text.Trim();
if (string.IsNullOrEmpty(strAppPersion))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('申请人不能为空！');", true);
return;
}
modelTravelApplication.travelPersionCode = travelPersons;
modelTravelApplication.travelplan = this.txt_plan.Text.Trim();;
modelTravelApplication.jiaotongfei = ToIntNum(txt_jtf.Text);
modelTravelApplication.zhusufei = ToIntNum(txt_zsf.Text);
modelTravelApplication.yewuzhaodaifei = ToIntNum(txt_zdf.Text);
modelTravelApplication.huiyifei = ToIntNum(txt_hyf.Text);
modelTravelApplication.yinshuafei = ToIntNum(txt_ysf.Text);
modelTravelApplication.qitafei = ToIntNum(txt_qt.Text);
modelTravelApplication.needAmount = modelTravelApplication.jiaotongfei + modelTravelApplication.zhusufei + modelTravelApplication.yewuzhaodaifei + modelTravelApplication.huiyifei + modelTravelApplication.yinshuafei + modelTravelApplication.qitafei;
modelMainBill.BillJe = (decimal)modelTravelApplication.needAmount;
//if (this.ddlTravelType.SelectedValue == null)
//{
// throw new Exception("出差类型不能为空！");
//}
//modelTravelApplication.typecode = this.ddlTravelType.SelectedValue.Trim();
modelMainBill.BillCode = txt_bh.Text.Trim();
DateTime dtBillDate;
bool boBillDate = DateTime.TryParse(str_billdate, out dtBillDate);
if (boBillDate)
{
modelMainBill.BillDate = dtBillDate;
}
else
{
throw new Exception("日期格式输入不正确！");
}
UserMessage user = new UserMessage(modelMainBill.BillUser);
string strBillDept = user.GetRootDept().DeptCode;
if (string.IsNullOrEmpty(strBillDept))
{
throw new Exception("未发现人员所在单位！");
}
modelMainBill.BillDept = strBillDept;
//modelMainBill.BillJe = int.Parse(this.txtFeePlan.Text.Trim());//单据金额
int iRel = bllTravelApplication.AddNote(modelMainBill, modelTravelApplication, out strMsg);
if (iRel < 1)
{
throw new Exception(strMsg);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存成功！');window.location.href='travelApplyList.aspx';", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存失败,原因：" + ex.Message + "');", true);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Bill_TravelApplication model, SqlTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Bill_TravelApplication(");
strSql.Append("maincode,MoreThanStandard,typecode,travelPersionCode,arrdess,travelDate,reasion,travelplan,needAmount,Transport,ReportCode,jiaotongfei,zhusufei,yewuzhaodaifei,huiyifei,yinshuafei,qitafei,sendDept");
strSql.Append(") values (");
strSql.Append("@maincode,@MoreThanStandard,@typecode,@travelPersionCode,@arrdess,@travelDate,@reasion,@travelplan,@needAmount,@Transport,@ReportCode,@jiaotongfei,@zhusufei,@yewuzhaodaifei,@huiyifei,@yinshuafei,@qitafei,@sendDept");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@maincode", SqlDbType.VarChar, 50),
new SqlParameter("@MoreThanStandard", SqlDbType.Int, 4),
new SqlParameter("@typecode", SqlDbType.VarChar, 50),
new SqlParameter("@travelPersionCode", SqlDbType.VarChar, 50),
new SqlParameter("@arrdess", SqlDbType.VarChar, 500),
new SqlParameter("@travelDate", SqlDbType.VarChar, 50),
new SqlParameter("@reasion", SqlDbType.VarChar, 100),
new SqlParameter("@travelplan", SqlDbType.VarChar, 100),
new SqlParameter("@needAmount", SqlDbType.Int, 4),
new SqlParameter("@Transport", SqlDbType.VarChar, 50),
new SqlParameter("@ReportCode", SqlDbType.VarChar, 50),
new SqlParameter("@jiaotongfei", SqlDbType.Int, 4),
new SqlParameter("@zhusufei", SqlDbType.Int, 4),
new SqlParameter("@yewuzhaodaifei", SqlDbType.Int, 4),
new SqlParameter("@huiyifei", SqlDbType.Int, 4),
new SqlParameter("@yinshuafei", SqlDbType.Int, 4),
new SqlParameter("@qitafei", SqlDbType.Int, 4),
new SqlParameter("@sendDept", SqlDbType.VarChar, 50)
};
parameters[0].Value = SqlNull(model.maincode);
parameters[1].Value = SqlNull(model.MoreThanStandard);
parameters[2].Value = SqlNull(model.typecode);
parameters[3].Value = SqlNull(model.travelPersionCode);
parameters[4].Value = SqlNull(model.arrdess);
parameters[5].Value = SqlNull(model.travelDate);
parameters[6].Value = SqlNull(model.reasion);
parameters[7].Value = SqlNull(model.travelplan);
parameters[8].Value = SqlNull(model.needAmount);
parameters[9].Value = SqlNull(model.Transport);
parameters[10].Value = SqlNull(model.ReportCode);
parameters[11].Value = SqlNull(model.jiaotongfei);
parameters[12].Value = SqlNull(model.zhusufei);
parameters[13].Value = SqlNull(model.yewuzhaodaifei);
parameters[14].Value = SqlNull(model.huiyifei);
parameters[15].Value = SqlNull(model.yinshuafei);
parameters[16].Value = SqlNull(model.qitafei);
parameters[17].Value = SqlNull(model.sendDept);
return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false));
}
