/// <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)); }