//批量删除
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
}
