//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("sys_payment_detail1", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); string result = ""; int success = 0, error = 0; StringBuilder sb = new StringBuilder(); manager = GetAdminInfo(); 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("Receiptdetail_list.aspx", "page={0}&txtorderid={1}&txtsforedate={2}&txteforedate={3}&ddlmethod={4}&txtCusName={5}&hCusId={6}&ddlarea={7}&txtPerson1={8}&txtsdate={9}&txtedate={10}", "__id__", _oID, _sforedate, _eforedate, _method, _cusName, _cid, _area, _person1, _sdate, _edate)); }
private string DoAdd(out int id) { id = 0; Model.ReceiptPayDetail model = new Model.ReceiptPayDetail(); BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); manager = GetAdminInfo(); model.rpd_type = true; model.rpd_oid = oID; model.rpd_cid = Utils.StrToInt(hCusId.Value, 0); model.rpd_content = txtContent.Text.Trim(); model.rpd_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); model.rpd_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); model.rpd_method = Utils.StrToInt(ddlmethod.SelectedValue, 0); //model.rpd_content = txtContent.Text.Trim(); model.rpd_personNum = manager.user_name; model.rpd_personName = manager.real_name; model.rpd_adddate = DateTime.Now; model.rpd_flag1 = 2; //model.rpd_area = manager.area; model.rpd_cbid = 0; if (model.rpd_money < 0) { model.rpd_cbid = Utils.StrToInt(hBankId.Value, 0); } return(bll.AddReceiptPay(model, manager, out id)); }
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; // } //} }
private void ShowInfo(int _id) { BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); DataSet ds = bll.GetList(0, "rpd_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["rpd_cid"].ToString(); txtMoney.Text = dr["rpd_money"].ToString(); if (Utils.StrToFloat(dr["rp_money"].ToString(), 0) < 0) { isFushu = true; } if (dr["rpd_foredate"] != null) { txtforedate.Text = Convert.ToDateTime(dr["rpd_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["rpd_method"].ToString(); txtContent.Text = dr["rpd_content"].ToString(); if (dr["pm_type"].ToString() == "True") { isChongzhang = true; } } }
private void RptBind(string _strWhere, string _orderby) { if (!this.isSearch) { this.page = DTRequest.GetQueryInt("page", 1); } else { this.page = 1; } BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); DataTable dt = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, manager, out this.totalCount, out decimal _tmoney, true).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; if (dt != null) { foreach (DataRow dr in dt.Rows) { _pmoney += Utils.ObjToDecimal(dr["rpd_money"], 0); } } pMoney.Text = _pmoney.ToString(); tCount.Text = totalCount.ToString(); tMoney.Text = _tmoney.ToString(); txtCusName.Text = _cusName; hCusId.Value = _cid; ddlchecktype.SelectedValue = this._check; ddlcheck1.SelectedValue = this._check1; ddlcheck2.SelectedValue = this._check2; ddlcheck3.SelectedValue = this._check3; txtforesdate.Text = _foresdate; txtforeedate.Text = _foreedate; ddlcollect.SelectedValue = _collect; txtPerson.Text = _person; ddlsign.SelectedValue = _sign; txtMoney.Text = _money; txtorderid.Text = _oID; ddlarea.SelectedValue = _area; txtPerson1.Text = _person1; txtsdate.Text = _sdate; txtedate.Text = _edate; ddlmethod1.SelectedValue = _method1; }
private void ShowInfo(int _id) { BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); DataSet ds = bll.GetList(0, "rpd_id=" + _id + "", ""); btnAudit.Visible = false; if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; oID = dr["rpd_oid"].ToString(); txtCusName.Text = dr["c_name"].ToString(); txtCusName.Enabled = false; hCusId.Value = dr["rpd_cid"].ToString(); txtBank.Text = dr["cb_bank"].ToString() + "(" + dr["cb_bankName"].ToString() + "/" + dr["cb_bankNum"].ToString() + ")"; hBankId.Value = dr["rpd_cbid"].ToString(); txtMoney.Text = dr["rpd_money"].ToString(); if (dr["rpd_foredate"] != null) { txtforedate.Text = Convert.ToDateTime(dr["rpd_foredate"]).ToString("yyyy-MM-dd"); } txtContent.Text = dr["rpd_content"].ToString(); rptAlbumList.DataSource = new BLL.payPic().GetList(1, "pp_type=1 and pp_rid=" + _id + "", "pp_addDate desc"); rptAlbumList.DataBind(); if ((manager.area == dr["rpd_area"].ToString() && new BLL.permission().checkHasPermission(manager, "0603")) || new 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, "0603"))//部门审批 { ddlchecktype.SelectedValue = "1"; ddlflag.SelectedValue = dr["rpd_flag1"].ToString(); txtCheckRemark.Text = dr["rpd_checkRemark1"].ToString(); } else if (new BLL.permission().checkHasPermission(manager, "0402"))//财务审批 { ddlchecktype.SelectedValue = "2"; ddlflag.SelectedValue = dr["rpd_flag2"].ToString(); txtCheckRemark.Text = dr["rpd_checkRemark2"].ToString(); } else if (new BLL.permission().checkHasPermission(manager, "0601"))//总经理审批 { ddlchecktype.SelectedValue = "3"; ddlflag.SelectedValue = dr["rpd_flag3"].ToString(); txtCheckRemark.Text = dr["rpd_checkRemark3"].ToString(); } } } }
private string DoEdit(int _id) { BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); Model.ReceiptPayDetail model = bll.GetModel(_id); manager = GetAdminInfo(); string _content = string.Empty; if (model.rpd_cid.ToString() != hCusId.Value) { _content += "收款对象ID:" + model.rpd_cid + "→<font color='red'>" + hCusId.Value + "</font><br/>"; } model.rpd_cid = Utils.StrToInt(hCusId.Value, 0); bool updateMoney = false; if (model.rpd_money.ToString() != txtMoney.Text.Trim()) { updateMoney = true; _content += "收款金额:" + model.rpd_money + "→<font color='red'>" + txtMoney.Text.Trim() + "</font><br/>"; } model.rpd_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); if (model.rpd_foredate.Value.ToString("yyyy-MM-dd") != txtforedate.Text.Trim()) { _content += "预收日期:" + model.rpd_foredate.Value.ToString("yyyy-MM-dd") + "→<font color='red'>" + txtforedate.Text.Trim() + "</font><br/>"; } model.rpd_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); if (model.rpd_method.ToString() != ddlmethod.SelectedValue) { _content += "收款方式ID:" + model.rpd_method + "→<font color='red'>" + ddlmethod.SelectedItem.Text + "</font><br/>"; } model.rpd_method = Utils.StrToInt(ddlmethod.SelectedValue, 0); if (model.rpd_content != txtContent.Text.Trim()) { _content += "收款内容:" + model.rpd_content + "→<font color='red'>" + txtContent.Text.Trim() + "</font><br/>"; } model.rpd_content = txtContent.Text.Trim(); if (model.rpd_cbid != Utils.StrToInt(hBankId.Value, 0)) { _content += "客户银行账号:" + model.rpd_cbid + "→<font color='red'>" + hBankId.Value + "</font><br/>"; } model.rpd_cbid = Utils.StrToInt(hBankId.Value, 0); return(bll.Update(model, _content, manager, updateMoney)); }
private string DoAdd(out int id) { id = 0; Model.ReceiptPayDetail model = new Model.ReceiptPayDetail(); BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); manager = GetAdminInfo(); model.rpd_type = false; model.rpd_oid = oID; model.rpd_cid = Utils.StrToInt(hCusId.Value, 0); model.rpd_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); model.rpd_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); model.rpd_content = txtContent.Text.Trim(); model.rpd_personNum = manager.user_name; model.rpd_personName = manager.real_name; model.rpd_adddate = DateTime.Now; model.rpd_cbid = Utils.StrToInt(hBankId.Value, 0); model.rpd_flag1 = 0; model.rpd_flag2 = 0; model.rpd_flag3 = 0; //model.rpd_area = manager.area; if (fileUp.HasFile) { string fileext = ""; for (int i = 0; i < fileUp.PostedFiles.Count; i++) { fileext = System.IO.Path.GetExtension(fileUp.PostedFiles[i].FileName).TrimStart('.');//jpg,jpge,png,gif //检查文件扩展名是否合法 if (!CheckFileExt(fileext)) { return("不允许上传" + fileext + "类型的文件"); } byte[] byteData = FileHelper.ConvertStreamToByteBuffer(fileUp.PostedFiles[i].InputStream); //获取文件流 //检查文件大小是否合法 if (!CheckFileSize(fileext, byteData.Length)) { return("文件超过限制的大小"); } } } return(bll.AddReceiptPay(model, manager, out id)); }
private string DoEdit(int _id) { BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); Model.ReceiptPayDetail model = bll.GetModel(_id); manager = GetAdminInfo(); string _content = string.Empty; //if (model.rpd_cid.ToString() != hCusId.Value) //{ // _content += "付款对象ID:" + model.rpd_cid + "→<font color='red'>" + hCusId.Value + "</font><br/>"; //} //model.rpd_cid = Utils.StrToInt(hCusId.Value, 0); bool updateMoney = false; if (model.rpd_money.ToString() != txtMoney.Text.Trim()) { if ((model.rpd_money < 0 && Utils.ObjToDecimal(txtMoney.Text.Trim(), 0) >= 0) || (model.rpd_money >= 0 && Utils.ObjToDecimal(txtMoney.Text.Trim(), 0) < 0)) { updateMoney = true;//表示金额从负数改为正数,或从正数改为负数 } _content += "付款金额:" + model.rpd_money + "→<font color='red'>" + txtMoney.Text.Trim() + "</font><br/>"; } model.rpd_money = Utils.StrToDecimal(txtMoney.Text.Trim(), 0); if (model.rpd_foredate.Value.ToString("yyyy-MM-dd") != txtforedate.Text.Trim()) { _content += "预付日期:" + model.rpd_foredate.Value.ToString("yyyy-MM-dd") + "→<font color='red'>" + txtforedate.Text.Trim() + "</font><br/>"; } model.rpd_foredate = ConvertHelper.toDate(txtforedate.Text.Trim()); if (model.rpd_content != txtContent.Text.Trim()) { _content += "付款内容:" + model.rpd_content + "→<font color='red'>" + txtContent.Text.Trim() + "</font><br/>"; } model.rpd_content = txtContent.Text.Trim(); if (model.rpd_cbid != Utils.StrToInt(hBankId.Value, 0)) { _content += "客户银行账号:" + model.rpd_cbid + "→<font color='red'>" + hBankId.Value + "</font><br/>"; } model.rpd_cbid = Utils.StrToInt(hBankId.Value, 0); return(bll.Update(model, _content, manager, updateMoney)); }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { if (_self != "1") { ChkAdminLevel("sys_payment_detail0", DTEnums.ActionEnum.Delete.ToString()); //检查权限 } BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); string result = ""; int success = 0, error = 0; StringBuilder sb = new StringBuilder(); manager = GetAdminInfo(); 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++; //删除文件 if (Directory.Exists(Server.MapPath("~/uploadPay/1/" + id + "/"))) { Directory.Delete(Server.MapPath("~/uploadPay/1/" + id + "/"), true); } } else { error++; sb.Append(result + "<br/>"); } } } JscriptMsg("共选择" + (success + error) + "条记录,成功" + success + "条,失败" + error + "条<br/>" + sb.ToString(), Utils.CombUrlTxt("paydetail_list.aspx", "page={0}&ddlcheck1={1}&ddlcheck2={2}&ddlcheck3={3}&txtforesdate={4}&txtforeedate={5}&self={6}&txtCusName={7}&hCusId={8}&ddlcollect={9}&txtPerson={10}&ddlsign={11}&txtmoney={12}&txtorderid={13}&ddlarea={14}&txtPerson1={15}&txtsdate={16}&txtedate={17}", "__id__", _check1, _check2, _check3, _foresdate, _foreedate, _self, _cusName, _cid, _collect, _person, _sign, _money, _oID, _area, _person1, _sdate, _edate)); }
private void RptBind(string _strWhere, string _orderby) { if (!this.isSearch) { this.page = DTRequest.GetQueryInt("page", 1); } else { this.page = 1; } BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); DataTable dt = bll.getCollectList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount, out decimal tmoney).Tables[0]; this.rptList.DataSource = dt; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("paydetailcollect.aspx", "page={0}&txtCusName={1}&hCusId={2}&txtsforedate={3}&txteforedate={4}", "__id__", _cusName, _cid, _sforedate, _eforedate); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); pCount.Text = dt.Rows.Count.ToString(); decimal _pmoney = 0; if (dt != null) { foreach (DataRow dr in dt.Rows) { _pmoney += Utils.ObjToDecimal(dr["total"], 0); } } pMoney.Text = _pmoney.ToString(); tCount.Text = totalCount.ToString(); tMoney.Text = tmoney.ToString(); }
protected void btnExcel_Click(object sender, EventArgs e) { _cusName = DTRequest.GetString("txtCusName"); _cid = DTRequest.GetString("hCusId"); _oID = DTRequest.GetFormString("txtorderid"); _area = DTRequest.GetFormString("ddlarea"); _sforedate = DTRequest.GetFormString("txtsforedate"); _eforedate = DTRequest.GetFormString("txteforedate"); _method = DTRequest.GetFormString("ddlmethod"); _person1 = DTRequest.GetFormString("txtPerson1"); _sdate = DTRequest.GetFormString("txtsdate"); _edate = DTRequest.GetFormString("txtedate"); _addperson = DTRequest.GetFormString("txtAddPerson"); _num = DTRequest.GetFormString("txtnum"); BLL.ReceiptPayDetail bll = new BLL.ReceiptPayDetail(); DataTable dt = bll.GetList(this.pageSize, this.page, "rpd_type=1" + CombSqlTxt(), "rpd_adddate desc,rpd_id desc", manager, out this.totalCount, out decimal _tmoney, false, 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.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; 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); 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]["rpd_oid"].ToString()); row.CreateCell(1).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["c_name"])); row.CreateCell(2).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rpd_content"])); row.CreateCell(3).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rpd_money"])); row.CreateCell(4).SetCellValue(ConvertHelper.toDate(dt.Rows[i]["rpd_foredate"]).Value.ToString("yyyy-MM-dd")); row.CreateCell(5).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["pm_name"])); row.CreateCell(6).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rpd_personNum"]) + "-" + Utils.ObjectToStr(dt.Rows[i]["rpd_personName"])); row.CreateCell(7).SetCellValue(BusinessDict.checkStatus()[Utils.ObjToByte(dt.Rows[i]["rpd_flag1"])]); row.CreateCell(8).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rp_confirmerName"])); row.CreateCell(9).SetCellValue(ConvertHelper.toDate(dt.Rows[i]["rp_date"]) == null?"":ConvertHelper.toDate(dt.Rows[i]["rp_date"]).Value.ToString("yyyy-MM-dd")); row.CreateCell(10).SetCellValue(Utils.ObjectToStr(dt.Rows[i]["rpd_num"])); 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; } } MemoryStream file = new MemoryStream(); hssfworkbook.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); }
private void ShowInfo(string _oid) { rptEmployee0.Visible = false; liemployee0.Visible = false; BLL.Order bll = new BLL.Order(); DataSet ds = bll.GetList(0, "o_id='" + _oid + "'", "o_addDate desc"); if (ds == null || ds.Tables[0].Rows.Count == 0) { JscriptMsg("订单不存在!", ""); return; } DataRow dr = ds.Tables[0].Rows[0]; labOwner.Text = new MettingSys.BLL.department().getAreaText(dr["op_area"].ToString()) + "," + dr["op_number"] + "," + dr["op_name"]; txtCusName.Text = dr["c_name"].ToString(); hCusId.Value = dr["c_id"].ToString(); List <Model.Contacts> contactlist = new BLL.Contacts().getList("co_cid=" + hCusId.Value + "", " co_flag desc,co_id asc"); if (contactlist != null) { ddlcontact.DataSource = contactlist; ddlcontact.DataTextField = "co_name"; ddlcontact.DataValueField = "co_id"; ddlcontact.DataBind(); } ddlcontact.SelectedValue = dr["o_coid"].ToString(); txtPhone.Text = dr["co_number"].ToString(); ddlcontractPrice.SelectedValue = dr["o_contractPrice"].ToString(); txtsDate.Text = ConvertHelper.toDate(dr["o_sdate"]).Value.ToString("yyyy-MM-dd"); txteDate.Text = ConvertHelper.toDate(dr["o_edate"]).Value.ToString("yyyy-MM-dd"); txtAddress.Text = dr["o_address"].ToString(); txtContent.Text = dr["o_content"].ToString(); txtContract.Text = dr["o_contractContent"].ToString(); txtRemark.Text = dr["o_remarks"].ToString(); ddlfStatus.SelectedValue = dr["o_status"].ToString(); //ddldstatus.SelectedValue = dr["o_dstatus"].ToString(); ddlpushStatus.SelectedValue = dr["o_isPush"].ToString(); labFlag.Text = Common.BusinessDict.checkStatus()[Utils.ObjToByte(dr["o_flag"])]; ddlflag.SelectedValue = dr["o_flag"].ToString(); labLockStatus.Text = Common.BusinessDict.lockStatus()[Utils.ObjToByte(dr["o_lockStatus"])]; labfinanceCost.Text = dr["o_financeCust"].ToString(); txtCost.Text = dr["o_financeCust"].ToString(); finCost = Utils.StrToDecimal(dr["o_financeCust"].ToString(), 0); ddllockstatus.SelectedValue = dr["o_lockStatus"].ToString(); labFinRemarks.Text = dr["o_finRemarks"].ToString(); txtFinRemark.Text = dr["o_finRemarks"].ToString(); labStatusTime.Text = Utils.ObjectToStr(dr["o_statusTime"]) == "" ? "" : Utils.StrToDateTime(Utils.ObjectToStr(dr["o_statusTime"])).ToString("yyyy-MM-dd HH:mm:ss"); #region 归属地 string placeStr = dr["o_place"].ToString(); if (!string.IsNullOrEmpty(placeStr)) { Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); string[] list = placeStr.Split(','); foreach (string item in list) { if (areaDic.ContainsKey(item)) { orderAreaDic.Add(item, areaDic[item]); } } rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); } #endregion #region 人员 DataTable pdt = bll.GetPersonList(0, "op_oid='" + _oid + "'", "op_id asc").Tables[0]; if (pdt != null && pdt.Rows.Count > 0) { rptEmployee1.DataSource = pdt.Select("op_type=2"); rptEmployee1.DataBind(); rptEmployee2.DataSource = pdt.Select("op_type=3"); rptEmployee2.DataBind(); rptEmployee3.DataSource = pdt.Select("op_type=4"); rptEmployee3.DataBind(); rptEmployee4.DataSource = pdt.Select("op_type=5"); rptEmployee4.DataBind(); liplace.Visible = false; liemployee1.Visible = false; liemployee2.Visible = false; liemployee3.Visible = false; liemployee4.Visible = false; uploadDiv.Visible = false; uploadDiv2.Visible = false; btnSave.Visible = false; btnDstatus.Visible = false; btnFlag.Visible = false; btnLockstatus.Visible = false; btnUpdateCost.Visible = false; btnUnBusinessPay.Visible = false; btnReceiptPay.Visible = false; btnFinRemark.Visible = false; //btnPay.Visible = false; btnInvoince.Visible = false; //btnExcelIn.Visible = false; btnSharing.Visible = false; trFile.Visible = false; #region 根据当前登录账户显示不同按钮 DataRow[] drs1 = pdt.Select("op_type=1 and op_number='" + manager.user_name + "'"); //业务员 DataRow[] drs2 = pdt.Select("op_type=2 and op_number='" + manager.user_name + "'"); //业务报账人员 DataRow[] drs3 = pdt.Select("op_type=3 and op_number='" + manager.user_name + "'"); //业务策划人员 DataRow[] drs4 = pdt.Select("op_type=4 and op_number='" + manager.user_name + "'"); //业务执行人员 DataRow[] drs6 = pdt.Select("op_type=5 and op_number='" + manager.user_name + "'"); //业务设计人员 bool showDetail = false; if (drs4.Length > 0) { isExecutiver = true; showDetail = true; uploadDiv.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; } if (drs3.Length > 0 || drs6.Length > 0) { showDetail = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnDstatus.Visible = true; trFile.Visible = true; if (drs3.Length > 0) { ddldstatus.SelectedValue = drs3[0]["op_dstatus"].ToString(); } else if (drs6.Length > 0) { ddldstatus.SelectedValue = drs6[0]["op_dstatus"].ToString(); } } if (drs2.Length > 0) { isExecutiver = false; showDetail = true; liplace.Visible = true; liemployee2.Visible = true; liemployee3.Visible = true; liemployee4.Visible = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; btnSave.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; trFile.Visible = true; } if (drs1.Length > 0) { isExecutiver = false; showDetail = true; liplace.Visible = true; liemployee1.Visible = true; liemployee2.Visible = true; liemployee3.Visible = true; liemployee4.Visible = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnSave.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; trFile.Visible = true; } DataRow[] drs5 = pdt.Select("op_type=1"); //判断是否含有查看本区域数据的权限 if (new BLL.permission().checkHasPermission(manager, "0602") && (drs5[0]["op_area"].ToString() == manager.area || Utils.ObjectToStr(dr["o_place"]).IndexOf(manager.area) > -1)) { showDetail = true; trFile.Visible = true; } string groupArea = new BLL.department().getGroupArea();//总部 //判断是否是本区域,且含有财务基本权限 if ((drs5[0]["op_area"].ToString() == manager.area || groupArea == manager.area) && new BLL.permission().checkHasPermission(manager, "0401")) { showDetail = true; trFile.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; uploadDiv2.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; } //判断是否含有查看本区域审批权限 if (drs5[0]["op_area"].ToString() == manager.area && new BLL.permission().checkHasPermission(manager, "0603")) { trFile.Visible = true; showDetail = true; btnFlag.Visible = true; } // if (groupArea == manager.area) { if (new BLL.permission().checkHasPermission(manager, "0401")) { showDetail = true; trFile.Visible = true; } if (new BLL.permission().checkHasPermission(manager, "0405")) { showDetail = true; btnLockstatus.Visible = true; btnUpdateCost.Visible = true; trFile.Visible = true; } } if (new BLL.permission().checkHasPermission(manager, "0401")) { btnFinRemark.Visible = true; if (!Utils.StrToBool(dr["o_lockStatus"].ToString(), false)) { btnSharing.Visible = true; } } //以上都没有权限的,不能查看订单详细 if (!showDetail) { string msgbox = "parent.jsdialog(\"错误提示\", \"您没有管理该页面的权限,请勿非法进入!\", \"back\")"; Response.Write("<script type=\"text/javascript\">" + msgbox + "</script>"); Response.End(); } #endregion } #endregion if (dr["o_lockStatus"].ToString() == "1") { liplace.Visible = false; liemployee1.Visible = false; liemployee2.Visible = false; liemployee3.Visible = false; liemployee4.Visible = false; uploadDiv.Visible = false; uploadDiv2.Visible = false; btnSave.Visible = false; btnDstatus.Visible = false; btnFlag.Visible = false; btnUpdateCost.Visible = false; btnUnBusinessPay.Visible = false; btnReceiptPay.Visible = false; //btnPay.Visible = false; btnInvoince.Visible = true; //btnExcelIn.Visible = false; } #region 活动文件 DataTable fdt = bll.GetFileList(0, "f_oid='" + _oid + "'", "f_addDate asc,f_id asc").Tables[0]; if (fdt != null && fdt.Rows.Count > 0) { rptAlbumList.DataSource = fdt.Select("f_type=1"); rptAlbumList.DataBind(); rptAlbumList2.DataSource = fdt.Select("f_type=2"); rptAlbumList2.DataBind(); } #endregion string sqlwhere = ""; #region 执行备用金借款明细 if (isExecutiver) { sqlwhere = " and uba_PersonNum='" + manager.user_name + "'"; } DataSet unBusinessData = new BLL.unBusinessApply().GetList(0, "uba_oid='" + _oid + "' " + sqlwhere + "", "uba_addDate desc,uba_id desc"); if (unBusinessData != null && unBusinessData.Tables[0].Rows.Count > 0) { rptunBusinessList.DataSource = unBusinessData; rptunBusinessList.DataBind(); } #endregion #region 应收付 DataTable natureData = new BLL.finance().getNature(_oid, isExecutiver ? manager.user_name : ""); if (natureData != null && natureData.Rows.Count > 0) { rptNature.DataSource = natureData; rptNature.DataBind(); } #endregion #region 发票 if (isExecutiver) { sqlwhere = " and inv_personNum='" + manager.user_name + "'"; } DataTable invoiceData = new BLL.invoices().GetList(0, "inv_oid='" + _oid + "' " + sqlwhere + "", "inv_addDate desc,inv_id desc").Tables[0]; if (invoiceData != null && invoiceData.Rows.Count > 0) { foreach (DataRow inv in invoiceData.Rows) { if (inv["inv_flag1"].ToString() != "1" && inv["inv_flag2"].ToString() != "1" && inv["inv_flag3"].ToString() != "1") { requestMoney += Utils.StrToDecimal(inv["inv_money"].ToString(), 0); } if (Utils.StrToBool(inv["inv_isConfirm"].ToString(), false)) { confirmMoney += Utils.StrToDecimal(inv["inv_money"].ToString(), 0); } } rptInvoiceList.DataSource = invoiceData; rptInvoiceList.DataBind(); } #endregion #region 已收付款 if (isExecutiver) { sqlwhere = " and rpd_personNum='" + manager.user_name + "'"; } DataTable rpData = new BLL.ReceiptPayDetail().GetList(0, "rpd_oid='" + _oid + "'", "rpd_type desc,rpd_adddate desc,rpd_id desc").Tables[0]; if (rpData != null && rpData.Rows.Count > 0) { rptList.DataSource = rpData; rptList.DataBind(); } #endregion #region 结算汇总 if (!isExecutiver)//执行人员不可查看 { DataTable collectData = bll.getOrderCollect(_oid); if (collectData != null && collectData.Rows.Count > 0) { foreach (DataRow inv in collectData.Rows) { finProfit += Utils.StrToDecimal(inv["profit"].ToString(), 0); if (inv["fin_type"].ToString() == "True") { fin1 += Utils.StrToDecimal(inv["finMoney"].ToString(), 0); } else { fin0 += Utils.StrToDecimal(inv["finMoney"].ToString(), 0); } } rptCollect.DataSource = collectData; rptCollect.DataBind(); } } #endregion }