//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("sys_payment_list0", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.ReceiptPay bll = new BLL.ReceiptPay(); manager = GetAdminInfo(); string result = ""; int success = 0, error = 0; StringBuilder sb = new StringBuilder(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { result = bll.Delete(Convert.ToInt32(id), manager); if (result == "") { success++; } else { error++; sb.Append(result + "<br/>"); } } } JscriptMsg("共选择" + (success + error) + "条记录,成功" + success + "条,失败" + error + "条<br/>" + sb.ToString(), backUrl(), ""); }
private void ShowInfo(int _id) { BLL.ReceiptPay bll = new BLL.ReceiptPay(); DataSet ds = bll.GetList(0, "rp_id=" + _id + "", ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; txtCusName.Text = dr["c_name"].ToString(); hCusId.Value = dr["rp_cid"].ToString(); txtMoney.Text = dr["rp_money"].ToString(); if (Utils.StrToFloat(dr["rp_money"].ToString(), 0) < 0) { isFushu = true; } if (dr["rp_foredate"] != null) { txtforedate.Text = Convert.ToDateTime(dr["rp_foredate"]).ToString("yyyy-MM-dd"); } txtBank.Text = Utils.ObjectToStr(dr["cb_bank"]) + "(" + Utils.ObjectToStr(dr["cb_bankName"]) + "/" + Utils.ObjectToStr(dr["cb_bankNum"]) + ")"; hBankId.Value = Utils.ObjectToStr(dr["rp_cbid"]); ddlmethod.SelectedValue = dr["rp_method"].ToString(); txtContent.Text = dr["rp_content"].ToString(); if (dr["pm_type"].ToString() == "True") { isChongzhang = true; //dlceDate.Visible = true; //dlceNum.Visible = true; txtCenum.Text = dr["ce_num"].ToString(); txtCedate.Text = Utils.ObjectToDateTime(dr["ce_date"]).ToString("yyyy-MM-dd"); } } }
/// <summary> /// 删除凭证 /// </summary> /// <param name="id"></param> /// <param name="username"></param> /// <param name="realname"></param> /// <returns></returns> public string deleteCertificate(int id, string username, string realname) { Model.certificates model = GetModel(id); if (model == null) { return("凭证不存在"); } if (model.ce_flag == 2) { return("审批通过的不能删除"); } //判断是否被使用 DataSet ds = new BLL.ReceiptPay().GetList(0, "rp_ceid=" + id, ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { return("该凭证已被使用,不能删除"); } if (dal.Delete(id)) { Model.business_log logmodel = new Model.business_log(); logmodel.ol_relateID = id; logmodel.ol_title = "删除凭证"; logmodel.ol_content = "凭证号:" + model.ce_num + "<br/>凭证日期:" + model.ce_date.Value.ToString("yyyy-MM-dd") + ""; logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Delete.ToString(), logmodel, username, realname); return(""); } return("删除失败"); }
private void RptBind(string _strWhere, string _orderby) { manager = GetAdminInfo(); DataTable dt = new BLL.ReceiptPay().GetList(0, "rp_id=" + rpid, "rp_id").Tables[0]; if (dt == null || dt.Rows.Count == 0) { JscriptMsg("数据不存在!", "back"); return; } dr = dt.Rows[0]; BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); detailDT = bll.GetPayCertificationList(_strWhere).Tables[0]; //if (dt!=null) //{ // labCusName.Text = dt.Rows[0]["c_name"].ToString(); // labPayStatus.Text = Utils.StrToBool(Utils.ObjectToStr(dt.Rows[0]["rp_isConfirm"]), false) ? "已付款" : "未付款"; // labPayDate.Text = Utils.StrToBool(Utils.ObjectToStr(dt.Rows[0]["rp_isConfirm"]), false) ? ConvertHelper.toDate(dt.Rows[0]["rp_date"]).Value.ToString("yyyy-MM-dd") : "无"; // labPayMethod.Text = Utils.StrToBool(Utils.ObjectToStr(dt.Rows[0]["rp_isConfirm"]), false) ? dt.Rows[0]["pm_name"].ToString() : "无"; // labText.Text = dt.Rows[0]["rp_money"].ToString(); // if (unMoney > 0) // { // labText.Text += ",其中未分配金额为:" + unMoney; // } //} }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { BLL.ReceiptPay bll = new BLL.ReceiptPay(); manager = GetAdminInfo(); string result = ""; int success = 0, error = 0; StringBuilder sb = new StringBuilder(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { result = bll.Delete(Convert.ToInt32(id), manager); if (result == "") { success++; } else { error++; sb.Append(result + "<br/>"); } } } JscriptMsg("共选择" + (success + error) + "条记录,成功" + success + "条,失败" + error + "条<br/>" + sb.ToString(), Utils.CombUrlTxt("selfReceipt_list.aspx", "page={0}&ddlmethod={1}&ddlisConfirm={2}&txtsforedate={3}&txteforedate={4}&txtsdate={5}&txtedate={6}&txtNum={7}&txtCusName={8}&hCusId={9}&txtChk={10}&txtNumDate={11}", "__id__", _method, _isconfirm, _sforedate, _eforedate, _sdate, _edate, _num, _cusName, _cid, _chk, _numdate), ""); }
private void RptBind() { if (!this.isSearch) { this.page = DTRequest.GetQueryInt("page", 1); } else { this.page = 1; } BLL.ReceiptPay bll = new BLL.ReceiptPay(); Dictionary <string, string> dict = getDict(); this.rptList.DataSource = bll.GetDistributionList(dict, pageSize, page, out totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("rpDistribution.aspx", "page={0}&id={1}&tag={2}&txtOrderId={3}&ddlMoneyType={4}&ddlsign={5}&txtMoney={6}&txtChk={7}&txtsDate={8}&txteDate={9}&txtsDate1={10}&txteDate1={11}&txtPerson={12}", "__id__", rpID.ToString(), _tag.ToString(), _orderId, _moneyType, _sign, _money, _chk, _sdate, _edate, _sdate1, _edate1, _person); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); decimal _hasDistribute = bll.getDistributeMoney(rpID); labHasDistribute.Text = _hasDistribute.ToString(); labLeftMoney.Text = (model.rp_money - _hasDistribute).ToString(); }
private void RptBind(string _strWhere, string _orderby) { if (!this.isSearch) { this.page = DTRequest.GetQueryInt("page", 1); } else { this.page = 1; } BLL.ReceiptPay bll = new BLL.ReceiptPay(); DataTable dt = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount, out _tmoney, out _tunmoney).Tables[0]; this.rptList.DataSource = dt; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = backUrl(); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); pCount.Text = dt.Rows.Count.ToString(); decimal _pmoney = 0, _punmoney = 0; if (dt != null) { foreach (DataRow dr in dt.Rows) { _pmoney += Utils.ObjToDecimal(dr["rp_money"], 0); _punmoney += Utils.ObjToDecimal(dr["undistribute"], 0); } } pMoney.Text = _pmoney.ToString(); pUnMoney.Text = _punmoney.ToString(); tCount.Text = totalCount.ToString(); tMoney.Text = _tmoney.ToString(); tUnMoney.Text = _tunmoney.ToString(); txtCusName.Text = _cusName; hCusId.Value = _cid; ddlmethod.SelectedValue = _method; ddlcheck.SelectedValue = _check; ddlcheck2.SelectedValue = _check2; ddlisConfirm.SelectedValue = _isconfirm; txtsforedate.Text = _sforedate; txteforedate.Text = _eforedate; txtsdate.Text = _sdate; txtedate.Text = _edate; txtNum.Text = _num; txtChk.Text = _chk; txtNumDate.Text = _numdate; ddlsign.SelectedValue = _sign; txtMoney.Text = _money; ddlmoneyType.SelectedValue = _moneyType; ddlchecktype.SelectedValue = _flag; txtAddPerson.Text = _addperson; }
private string DoAdd(out int rpid) { rpid = 0; Model.ReceiptPay model = new Model.ReceiptPay(); BLL.ReceiptPay bll = new BLL.ReceiptPay(); manager = GetAdminInfo(); model.rp_type = true; model.rp_cid = Utils.StrToInt(hCusId.Value, 0); model.rp_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); model.rp_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); model.rp_method = Utils.StrToInt(ddlmethod.SelectedValue, 0); model.rp_content = txtContent.Text.Trim(); model.rp_cbid = 0; if (model.rp_money < 0) { model.rp_cbid = Utils.StrToInt(hBankId.Value, 0); } //在客户对账明细的账单打包时不是预收款 bool flag = true; if (!string.IsNullOrEmpty(oidStr)) { flag = false; } string result = bll.Add(model, manager, txtCenum.Text.Trim(), txtCedate.Text.Trim(), out rpid, flag); if (string.IsNullOrEmpty(result)) { if (!string.IsNullOrEmpty(oidStr) && model.rp_money == Utils.StrToDecimal(_tMoney, 0)) { JArray ja = JArray.Parse(oidStr); foreach (JObject item in ja) { Model.ReceiptPayDetail rpdModel = new Model.ReceiptPayDetail(); rpdModel.rpd_type = true; rpdModel.rpd_rpid = rpid; rpdModel.rpd_oid = item["oid"].ToString(); rpdModel.rpd_cid = Utils.StrToInt(_cid, 0); rpdModel.rpd_num = _chk; rpdModel.rpd_money = Utils.StrToDecimal(item["money"].ToString(), 0); rpdModel.rpd_foredate = model.rp_foredate; rpdModel.rpd_method = model.rp_method; rpdModel.rpd_personName = manager.real_name; rpdModel.rpd_personNum = manager.user_name; rpdModel.rpd_flag1 = 2; rpdModel.rpd_flag2 = 2; rpdModel.rpd_flag3 = 2; rpdModel.rpd_adddate = DateTime.Now; rpdModel.rpd_content = ""; rpdModel.rpd_cbid = model.rp_cbid; new BLL.ReceiptPayDetail().AddOrCancleDistribution(rpdModel, manager); } } } return(result); }
private void ShowInfo(int _id) { btnAudit.Visible = false; BLL.ReceiptPay bll = new BLL.ReceiptPay(); DataSet ds = bll.GetList(0, "rp_id=" + _id + "", ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; txtCusName.Text = dr["c_name"].ToString(); hCusId.Value = dr["rp_cid"].ToString(); txtBank.Text = Utils.ObjectToStr(dr["cb_bank"]) + "(" + Utils.ObjectToStr(dr["cb_bankName"]) + "/" + Utils.ObjectToStr(dr["cb_bankNum"]) + ")"; hBankId.Value = Utils.ObjectToStr(dr["rp_cbid"]); txtMoney.Text = dr["rp_money"].ToString(); if (dr["rp_foredate"] != null) { txtforedate.Text = Convert.ToDateTime(dr["rp_foredate"]).ToString("yyyy-MM-dd"); } ddlmethod.SelectedValue = dr["rp_method"].ToString(); txtContent.Text = dr["rp_content"].ToString(); if (Utils.ObjToInt(dr["rp_method"], 0) > 0 && new BLL.payMethod().GetModel(Utils.ObjToInt(dr["rp_method"], 0)).pm_type.Value) { isChongzhang = true; //dlceDate.Visible = true; //dlceNum.Visible = true; //dlBank.Visible = false; txtCenum.Text = Utils.ObjectToStr(dr["ce_num"]); txtCedate.Text = ConvertHelper.toDate(dr["ce_date"]).Value.ToString("yyyy-MM-dd"); } if (new MettingSys.BLL.permission().checkHasPermission(manager, "0402,0601")) { btnAudit.Visible = true; ddlflag.DataSource = Common.BusinessDict.checkStatus(); ddlflag.DataTextField = "value"; ddlflag.DataValueField = "key"; ddlflag.DataBind(); ddlflag.Items.Insert(0, new ListItem("请选择", "")); if (new BLL.permission().checkHasPermission(manager, "0402"))//财务审批 { ddlchecktype.SelectedValue = "1"; ddlflag.SelectedValue = dr["rp_flag"].ToString(); txtCheckRemark.Text = dr["rp_checkRemark"].ToString(); } else if (new BLL.permission().checkHasPermission(manager, "0601"))//总经理审批 { ddlchecktype.SelectedValue = "2"; ddlflag.SelectedValue = dr["rp_flag1"].ToString(); txtCheckRemark.Text = dr["rp_checkRemark1"].ToString(); } } } }
private void RptBind(string _strWhere, string _orderby) { if (!this.isSearch) { this.page = DTRequest.GetQueryInt("page", 1); } else { this.page = 1; } BLL.ReceiptPay bll = new BLL.ReceiptPay(); DataTable dt = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount, out _tmoney, out _tunmoney).Tables[0]; this.rptList.DataSource = dt; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("selfReceipt_list.aspx", "page={0}&ddlmethod={1}&ddlisConfirm={2}&txtsforedate={3}&txteforedate={4}&txtsdate={5}&txtedate={6}&txtNum={7}&txtCusName={8}&hCusId={9}&txtChk={10}&txtNumDate={11}", "__id__", _method, _isconfirm, _sforedate, _eforedate, _sdate, _edate, _num, _cusName, _cid, _chk, _numdate); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); pCount.Text = dt.Rows.Count.ToString(); decimal _pmoney = 0, _punmoney = 0; if (dt != null) { foreach (DataRow dr in dt.Rows) { _pmoney += Utils.ObjToDecimal(dr["rp_money"], 0); _punmoney += Utils.ObjToDecimal(dr["undistribute"], 0); } } pMoney.Text = _pmoney.ToString(); pUnMoney.Text = _punmoney.ToString(); tCount.Text = totalCount.ToString(); tMoney.Text = _tmoney.ToString(); tUnMoney.Text = _tunmoney.ToString(); txtCusName.Text = _cusName; hCusId.Value = _cid; ddlmethod.SelectedValue = _method; ddlisConfirm.SelectedValue = _isconfirm; txtsforedate.Text = _sforedate; txteforedate.Text = _eforedate; txtsdate.Text = _sdate; txtedate.Text = _edate; txtNum.Text = _num; txtChk.Text = _chk; txtNumDate.Text = _numdate; }
/// <summary> /// 删除一条数据 /// </summary> public string Delete(int id, Model.manager manager) { Model.ReceiptPay model = new BLL.ReceiptPay().GetModel(id); if (model == null) { return("数据不存在"); } if (!new BLL.permission().checkHasPermission(manager, "0401"))//如果不是财务 { return("无权限删除"); } else { if (model.rp_personNum != manager.user_name && !new BLL.permission().checkHasPermission(manager, "0403")) { return("无权限删除"); } } string typeText = "收款"; bool flag = false; if (model.rp_type.Value) { if (model.rp_isConfirm.Value) { return("已经确认收款,不能删除"); } flag = dal.deleteReceipt(id); } else { typeText = "付款"; if (model.rp_isExpect.Value && model.rp_flag1 == 2 && model.rp_money >= 0 && (model.rp_method == 0 || !new BLL.payMethod().GetModel(model.rp_method.Value).pm_type.Value)) { return("最终审批通过不能删除"); } flag = dal.deletePay(model); } if (flag) { Model.business_log logmodel = new Model.business_log(); logmodel.ol_relateID = id; logmodel.ol_title = "删除收款"; logmodel.ol_content = typeText + "ID:" + id + ",金额:" + model.rp_money; logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Delete.ToString(), logmodel, manager.user_name, manager.real_name); return(""); } return("删除失败"); }
private string DoEdit(int _id) { BLL.ReceiptPay bll = new BLL.ReceiptPay(); Model.ReceiptPay model = bll.GetModel(_id); manager = GetAdminInfo(); string _content = string.Empty; if (model.rp_cid.ToString() != hCusId.Value) { _content += "收款对象ID:" + model.rp_cid + "→<font color='red'>" + hCusId.Value + "</font><br/>"; } model.rp_cid = Utils.StrToInt(hCusId.Value, 0); if (model.rp_money.ToString() != txtMoney.Text.Trim()) { _content += "收款金额:" + model.rp_money + "→<font color='red'>" + txtMoney.Text.Trim() + "</font><br/>"; } model.rp_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); if (model.rp_foredate.Value.ToString("yyyy-MM-dd") != txtforedate.Text.Trim()) { _content += "预收日期:" + model.rp_foredate.Value.ToString("yyyy-MM-dd") + "→<font color='red'>" + txtforedate.Text.Trim() + "</font><br/>"; } model.rp_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); if (model.rp_method.ToString() != ddlmethod.SelectedValue) { _content += "收款方式ID:" + model.rp_method.ToString() + "→<font color='red'>" + ddlmethod.SelectedValue + "</font><br/>"; } model.rp_method = Utils.StrToInt(ddlmethod.SelectedValue, 0); if (model.rp_content != txtContent.Text.Trim()) { _content += "收款内容:" + model.rp_content + "→<font color='red'>" + txtContent.Text.Trim() + "</font><br/>"; } model.rp_content = txtContent.Text.Trim(); if (model.rp_cbid != Utils.StrToInt(hBankId.Value, 0)) { _content += "客户银行账号:" + model.rp_cbid + "→<font color='red'>" + hBankId.Value + "</font><br/>"; } model.rp_cbid = Utils.StrToInt(hBankId.Value, 0); return(bll.Update(model, _content, manager, txtCenum.Text.Trim(), txtCedate.Text.Trim())); }
protected void btnExcel_Click(object sender, EventArgs e) { _cusName = DTRequest.GetString("txtCusName"); _cid = DTRequest.GetString("hCusId"); _method = DTRequest.GetFormString("ddlmethod"); _check = DTRequest.GetFormString("ddlcheck"); _check2 = DTRequest.GetFormString("ddlcheck2"); _isconfirm = DTRequest.GetFormString("ddlisConfirm"); _sforedate = DTRequest.GetFormString("txtsforedate"); _eforedate = DTRequest.GetFormString("txteforedate"); _sdate = DTRequest.GetFormString("txtsdate"); _edate = DTRequest.GetFormString("txtedate"); _num = DTRequest.GetFormString("txtNum"); _chk = DTRequest.GetFormString("txtChk"); _numdate = DTRequest.GetFormString("txtNumDate"); _sign = DTRequest.GetFormString("ddlsign"); _money = DTRequest.GetFormString("txtMoney"); _moneyType = DTRequest.GetFormString("ddlmoneyType"); _type = DTRequest.GetFormString("ddlType"); _addperson = DTRequest.GetFormString("txtAddPerson"); BLL.ReceiptPay bll = new BLL.ReceiptPay(); DataTable dt = bll.GetList(this.pageSize, this.page, "rp_type=0 " + CombSqlTxt(), "isnull(rp_date,'3000-01-01') desc,isnull(pm_sort,-1) asc,rp_id desc", out this.totalCount, out _tmoney, out _tunmoney, false).Tables[0]; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=付款通知列表.xlsx"); //HttpUtility.UrlEncode(fileName)); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HSSFWorkbook hssfworkbook = new HSSFWorkbook(); ISheet sheet = hssfworkbook.CreateSheet("明细"); IFont font = hssfworkbook.CreateFont(); font.Boldweight = short.MaxValue; font.FontHeightInPoints = 11; #region 表格样式 //设置单元格的样式:水平垂直对齐居中 ICellStyle cellStyle = hssfworkbook.CreateCellStyle(); cellStyle.Alignment = HorizontalAlignment.Center; cellStyle.VerticalAlignment = VerticalAlignment.Center; cellStyle.BorderBottom = BorderStyle.Thin; cellStyle.BorderLeft = BorderStyle.Thin; cellStyle.BorderRight = BorderStyle.Thin; cellStyle.BorderTop = BorderStyle.Thin; cellStyle.BottomBorderColor = HSSFColor.Black.Index; cellStyle.LeftBorderColor = HSSFColor.Black.Index; cellStyle.RightBorderColor = HSSFColor.Black.Index; cellStyle.TopBorderColor = HSSFColor.Black.Index; cellStyle.WrapText = true;//自动换行 //设置表头的样式:水平垂直对齐居中,加粗 ICellStyle titleCellStyle = hssfworkbook.CreateCellStyle(); titleCellStyle.Alignment = HorizontalAlignment.Center; titleCellStyle.VerticalAlignment = VerticalAlignment.Center; titleCellStyle.FillForegroundColor = HSSFColor.Grey25Percent.Index; //图案颜色 titleCellStyle.FillPattern = FillPattern.SparseDots; //图案样式 titleCellStyle.FillBackgroundColor = HSSFColor.Grey25Percent.Index; //背景颜色 //设置边框 titleCellStyle.BorderBottom = BorderStyle.Thin; titleCellStyle.BorderLeft = BorderStyle.Thin; titleCellStyle.BorderRight = BorderStyle.Thin; titleCellStyle.BorderTop = BorderStyle.Thin; titleCellStyle.BottomBorderColor = HSSFColor.Black.Index; titleCellStyle.LeftBorderColor = HSSFColor.Black.Index; titleCellStyle.RightBorderColor = HSSFColor.Black.Index; titleCellStyle.TopBorderColor = HSSFColor.Black.Index; //设置字体 titleCellStyle.SetFont(font); #endregion //表头 IRow headRow = sheet.CreateRow(0); headRow.HeightInPoints = 25; headRow.CreateCell(0).SetCellValue("付款对象"); headRow.CreateCell(1).SetCellValue("凭证"); headRow.CreateCell(2).SetCellValue("付款内容"); headRow.CreateCell(3).SetCellValue("客户银行账号"); headRow.CreateCell(4).SetCellValue("付款金额"); headRow.CreateCell(5).SetCellValue("未分配金额"); headRow.CreateCell(6).SetCellValue("预付日期"); headRow.CreateCell(7).SetCellValue("付款方式"); headRow.CreateCell(8).SetCellValue("实付日期"); headRow.CreateCell(9).SetCellValue("申请人"); headRow.CreateCell(10).SetCellValue("财务审批"); headRow.CreateCell(11).SetCellValue("总经理审批"); headRow.CreateCell(12).SetCellValue("确认收款"); headRow.GetCell(0).CellStyle = titleCellStyle; headRow.GetCell(1).CellStyle = titleCellStyle; headRow.GetCell(2).CellStyle = titleCellStyle; headRow.GetCell(3).CellStyle = titleCellStyle; headRow.GetCell(4).CellStyle = titleCellStyle; headRow.GetCell(5).CellStyle = titleCellStyle; headRow.GetCell(6).CellStyle = titleCellStyle; headRow.GetCell(7).CellStyle = titleCellStyle; headRow.GetCell(8).CellStyle = titleCellStyle; headRow.GetCell(9).CellStyle = titleCellStyle; headRow.GetCell(10).CellStyle = titleCellStyle; headRow.GetCell(11).CellStyle = titleCellStyle; headRow.GetCell(12).CellStyle = titleCellStyle; sheet.SetColumnWidth(0, 15 * 256); sheet.SetColumnWidth(1, 20 * 256); sheet.SetColumnWidth(2, 20 * 256); sheet.SetColumnWidth(3, 20 * 256); sheet.SetColumnWidth(4, 20 * 256); sheet.SetColumnWidth(5, 15 * 256); sheet.SetColumnWidth(6, 20 * 256); sheet.SetColumnWidth(7, 20 * 256); sheet.SetColumnWidth(8, 20 * 256); sheet.SetColumnWidth(9, 20 * 256); sheet.SetColumnWidth(10, 20 * 256); sheet.SetColumnWidth(11, 20 * 256); sheet.SetColumnWidth(12, 20 * 256); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { IRow row = sheet.CreateRow(i + 1); row.HeightInPoints = 22; row.CreateCell(0).SetCellValue(dt.Rows[i]["c_name"].ToString() + (Utils.StrToBool(Utils.ObjectToStr(dt.Rows[i]["rp_isExpect"]), false) ? "[预]" : "")); row.CreateCell(1).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["ce_num"])); row.CreateCell(2).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rp_content"])); row.CreateCell(3).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["cb_bankName"]) + "\r\n" + Utils.ObjectToStr(dt.Rows[i]["cb_bankNum"]) + "\r\n" + Utils.ObjectToStr(dt.Rows[i]["cb_bank"])); row.CreateCell(4).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rp_money"])); row.CreateCell(5).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["undistribute"])); row.CreateCell(6).SetCellValue(ConvertHelper.toDate(dt.Rows[i]["rp_foredate"]).Value.ToString("yyyy-MM-dd")); row.CreateCell(7).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["pm_name"])); row.CreateCell(8).SetCellValue(ConvertHelper.toDate(dt.Rows[i]["rp_date"]) == null ? "" : ConvertHelper.toDate(dt.Rows[i]["rp_date"]).Value.ToString("yyyy-MM-dd")); row.CreateCell(9).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rp_personName"])); row.CreateCell(10).SetCellValue(dt.Rows[i]["rp_flag"].ToString() == "0" ? "待审批" : dt.Rows[i]["rp_flag"].ToString() == "1" ? "审批未通过" : "审批通过"); row.CreateCell(11).SetCellValue(dt.Rows[i]["rp_flag1"].ToString() == "0" ? "待审批" : dt.Rows[i]["rp_flag1"].ToString() == "1" ? "审批未通过" : "审批通过"); row.CreateCell(12).SetCellValue(Utils.StrToBool(Utils.ObjectToStr(dt.Rows[i]["rp_isConfirm"]), false) ? "已收款" : "待收款"); row.GetCell(0).CellStyle = cellStyle; row.GetCell(1).CellStyle = cellStyle; row.GetCell(2).CellStyle = cellStyle; row.GetCell(3).CellStyle = cellStyle; row.GetCell(4).CellStyle = cellStyle; row.GetCell(5).CellStyle = cellStyle; row.GetCell(6).CellStyle = cellStyle; row.GetCell(7).CellStyle = cellStyle; row.GetCell(8).CellStyle = cellStyle; row.GetCell(9).CellStyle = cellStyle; row.GetCell(10).CellStyle = cellStyle; row.GetCell(11).CellStyle = cellStyle; row.GetCell(12).CellStyle = cellStyle; } } MemoryStream file = new MemoryStream(); hssfworkbook.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); }
/// <summary> /// 删除收付款明细 /// </summary> public string Delete(int id, Model.manager manager) { Model.ReceiptPayDetail model = GetModel(id); if (model == null) { return("数据不存在"); } Model.Order order = new BLL.Order().GetModel(model.rpd_oid); if (order == null) { return("订单不存在"); } if (!new BLL.permission().checkHasPermission(manager, "0401"))//如果不是财务 { //验证权限:在同一个订单里,业务员与业务报账员可以对未审核地接进行编辑与删除!执行人员只能对自己地址进行编辑与删除操作! if (model.rpd_personNum != manager.user_name && order.personlist.Where(p => p.op_number == manager.user_name && (p.op_type == 3 || p.op_type == 4)).ToArray().Length > 0) { return("无权限删除"); } } else { if (model.rpd_personNum != manager.user_name && !new BLL.permission().checkHasPermission(manager, "0403")) { return("非申请人或没有删除他人数据权限不能删除"); } } bool flag = false; if (model.rpd_type.Value) { if (model.rpd_rpid > 0) { Model.ReceiptPay rp = new BLL.ReceiptPay().GetModel(model.rpd_rpid.Value); if (rp.rp_isConfirm.Value) { return("已确认收款,不能再删除"); } } flag = dal.DeleteReceiptDetail(model); } else { if (model.rpd_flag3 == 2 && model.rpd_money >= 0) { return("最终审批通过不能再编辑"); } flag = dal.Delete(id); if (flag) { //删除图片附件 new BLL.payPic().deleteFileByid(id, 1); } } string typeText = "收款"; if (!model.rpd_type.Value) { typeText = "付款"; } if (flag) { Model.business_log logmodel = new Model.business_log(); logmodel.ol_oid = model.rpd_oid; logmodel.ol_relateID = model.rpd_id.Value; logmodel.ol_cid = model.rpd_cid.Value; logmodel.ol_title = "删除" + typeText + "明细"; logmodel.ol_content = "记录ID:" + id + ",金额:" + model.rpd_money + ""; logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Delete.ToString(), logmodel, manager.user_name, manager.real_name); //记录日志 return(""); } return("删除失败"); }
/// <summary> /// 编辑收付款明细 /// </summary> /// <param name="model"></param> /// <param name="content"></param> /// <param name="manager"></param> /// <param name="updateMoney">是否修改了收款明细的金额</param> /// <returns></returns> public string Update(Model.ReceiptPayDetail model, string content, Model.manager manager, bool updateMoney = false, bool updateMethod = false) { if (model == null) { return("数据不存在"); } Model.Order order = new BLL.Order().GetModel(model.rpd_oid); if (order == null) { return("订单不存在"); } if (!new BLL.permission().checkHasPermission(manager, "0401"))//如果不是财务 { //验证权限:在同一个订单里,业务员与业务报账员可以对未审核地接进行编辑与删除!执行人员只能对自己地址进行编辑与删除操作! if (model.rpd_personNum != manager.user_name && order.personlist.Where(p => p.op_number == manager.user_name && (p.op_type == 3 || p.op_type == 4)).ToArray().Length > 0) { return("无权限编辑"); } } else { if (model.rpd_personNum != manager.user_name && !new BLL.permission().checkHasPermission(manager, "0403")) { return("无权限编辑"); } } string typeText = "收款"; if (!model.rpd_type.Value) { typeText = "付款"; } if (model.rpd_cid == 0) { return("请选择" + typeText + "对象"); } if (model.rpd_money == 0) { return("请填写" + typeText + "金额"); } if (model.rpd_foredate == null) { return("请选择" + (model.rpd_type.Value ? "预收" : "预付") + "日期"); } bool flag = false; if (model.rpd_type.Value) { if (model.rpd_method == 0) { return("请选择收款方式"); } if (model.rpd_rpid > 0) { Model.ReceiptPay rp = new BLL.ReceiptPay().GetModel(model.rpd_rpid.Value); if (rp.rp_isConfirm.Value) { return("已确认收款,不能再编辑"); } } flag = UpdateReceiptDetail(model, updateMoney); } else { if (updateMethod) { if (model.rpd_rpid > 0) { return("已经汇总的不能修改付款方式"); } } else if (updateMoney) { if (model.rpd_money >= 0) { model.rpd_flag1 = 0; model.rpd_checkNum1 = ""; model.rpd_checkName1 = ""; model.rpd_checkRemark1 = ""; model.rpd_checkTime1 = null; model.rpd_flag2 = 0; model.rpd_checkNum2 = ""; model.rpd_checkName2 = ""; model.rpd_checkRemark2 = ""; model.rpd_checkTime2 = null; model.rpd_flag3 = 0; model.rpd_checkNum3 = ""; model.rpd_checkName3 = ""; model.rpd_checkRemark3 = ""; model.rpd_checkTime3 = null; } else { model.rpd_flag1 = 2; model.rpd_checkTime1 = DateTime.Now; model.rpd_flag2 = 2; model.rpd_checkTime2 = DateTime.Now; model.rpd_flag3 = 2; model.rpd_checkTime3 = DateTime.Now; } } else if (model.rpd_money >= 0 && model.rpd_flag1 == 2 && model.rpd_flag2 != 1 && model.rpd_flag3 != 1) { return("部门审批已通过,不能再编辑"); } //编辑后清空审批内容,如果只是修改付款方式则不需要情况 2020-05-30 if ((model.rpd_flag1 == 1 || model.rpd_flag2 == 1 || model.rpd_flag3 == 1) && !updateMethod) { model.rpd_flag1 = 0; model.rpd_checkNum1 = ""; model.rpd_checkName1 = ""; model.rpd_checkRemark1 = ""; model.rpd_checkTime1 = null; model.rpd_flag2 = 0; model.rpd_checkNum2 = ""; model.rpd_checkName2 = ""; model.rpd_checkRemark2 = ""; model.rpd_checkTime2 = null; model.rpd_flag3 = 0; model.rpd_checkNum3 = ""; model.rpd_checkName3 = ""; model.rpd_checkRemark3 = ""; model.rpd_checkTime3 = null; } flag = dal.Update(model); } if (flag) { Model.business_log logmodel = new Model.business_log(); logmodel.ol_oid = model.rpd_oid; logmodel.ol_relateID = model.rpd_id.Value; logmodel.ol_cid = model.rpd_cid.Value; logmodel.ol_title = "编辑" + typeText + "明细"; logmodel.ol_content = content.ToString(); logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Edit.ToString(), logmodel, manager.user_name, manager.real_name); //记录日志 //钉钉通知 if (!model.rpd_type.Value && !string.IsNullOrEmpty(content)) { DataTable userDt = new BLL.manager().getUserByPermission("0603", model.rpd_area).Tables[0]; if (userDt != null) { string replaceContent = model.rpd_oid + "," + model.rpd_money + "," + model.rpd_content; string replaceUser = model.rpd_personNum + "," + model.rpd_personName; foreach (DataRow dr in userDt.Rows) { //钉钉推送通知 if (!string.IsNullOrEmpty(Utils.ObjectToStr(dr["oauth_userid"]))) { new BLL.selfMessage().sentDingMessage("添加付款通知", dr["oauth_userid"].ToString(), replaceContent, replaceUser); } } } } return(""); } return("编辑失败"); }
private string DoEdit(int _id) { BLL.certificates bll = new BLL.certificates(); Model.certificates model = bll.GetModel(_id); if (model.ce_flag == 2) { return("凭证号已经审批通过,不能编辑"); } if (string.IsNullOrEmpty(txtNum.Text.Trim())) { return("请填写凭证号"); } if (string.IsNullOrEmpty(txtDate.Text.Trim())) { return("请填写凭证日期"); } string _content = string.Empty; bool _update = false; if (model.ce_num != txtNum.Text.Trim()) { _update = true; _content += "凭证号:" + model.ce_num + "→<font color='red'>" + txtNum.Text.Trim() + "</font><br/>"; } model.ce_num = txtNum.Text.Trim(); if (model.ce_date != Convert.ToDateTime(txtDate.Text.Trim())) { _update = true; _content += "凭证日期:" + model.ce_date.Value.ToString("yyyy-MM-dd") + "→<font color='red'>" + txtNum.Text.Trim() + "</font><br/>"; } model.ce_date = Convert.ToDateTime(txtDate.Text.Trim()); if (_update) { //判断是否被使用 DataSet ds = new BLL.ReceiptPay().GetList(0, "rp_ceid=" + id, ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { return("该凭证已被使用,不能修改凭证号和凭证日期,只能修改备注"); } } if (model.ce_remark != txtRemark.Text.Trim()) { _content += "备注:" + model.ce_remark + "→<font color='red'>" + txtRemark.Text.Trim() + "</font><br/>"; } model.ce_remark = txtRemark.Text.Trim(); if (bll.Exists(model.ce_num, model.ce_date, _id)) { return("凭证号、凭证日期重复"); } if (bll.Update(model)) { if (!string.IsNullOrEmpty(_content)) { logmodel = new Model.business_log(); logmodel.ol_relateID = _id; logmodel.ol_title = "修改凭证"; logmodel.ol_content = _content; logmodel.ol_operateDate = DateTime.Now; AddBusinessLog(DTEnums.ActionEnum.Edit.ToString(), logmodel); //记录日志 } return(""); } return("修改失败"); }