private bool Check() { if (CommHelp.VerifesToNum(txtZhangQi.Text) == false || Convert.ToDecimal(txtZhangQi.Text) < 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目财务成本账期 格式有问题!');</script>"); return(false); } if (CommHelp.VerifesToNum(txtCeSuanDian.Text) == false || Convert.ToDecimal(txtCeSuanDian.Text) < 0 || Convert.ToDecimal(txtCeSuanDian.Text) > 1) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('财务成本测算点 格式有问题!');</script>"); return(false); } if (CommHelp.VerifesToNum(txtMonthLiLv.Text) == false || Convert.ToDecimal(txtMonthLiLv.Text) < 0 || Convert.ToDecimal(txtMonthLiLv.Text) > 1) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('财务成本月利率 格式有问题!');</script>"); return(false); } if (txtFrom.Text == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('考核前期日期 不能为空!');</script>"); return(false); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('考核前期日期 格式错误!');</script>"); return(false); } } return(true); }
protected void btnIsSelected_Click(object sender, EventArgs e) { if (btnEdit.Text == "取消编辑") { StringBuilder where = new StringBuilder(); for (int i = 0; i < this.gvList.Rows.Count; i++) { Label lblIds = (gvList.Rows[i].FindControl("Id")) as Label; TextBox EditGuestName = (gvList.Rows[i].FindControl("EditGuestName")) as TextBox; TextBox EditReceived = (gvList.Rows[i].FindControl("EditReceived")) as TextBox; if (CommHelp.VerifesToNum(EditReceived.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('到款金额格式错误!');</script>"); return; } //where.AppendFormat("update KIS.[KingdeeInvoice].[dbo].[Invoice] set GuestName='{1}',Received={2} where Id={0};", lblIds.Text, EditGuestName.Text, EditReceived.Text); where.AppendFormat("update [KingdeeInvoice].[dbo].[Invoice] set GuestName='{1}',Received={2} where Id={0};", lblIds.Text, EditGuestName.Text, EditReceived.Text); } if (where.ToString() != "") { DBHelp.ExeCommand(where.ToString()); } } if (ViewState["cbIsIsorder"] == null) { string where = " Id in ("; string expWhere = " Id in ("; for (int i = 0; i < this.gvList.Rows.Count; i++) { CheckBox cb = (gvList.Rows[i].FindControl("cbIsIsorder")) as CheckBox; if (cb.Checked) { Label lblIds = (gvList.Rows[i].FindControl("Id")) as Label; where += "'" + lblIds.Text + "',"; } else { Label lblIds = (gvList.Rows[i].FindControl("Id")) as Label; expWhere += "'" + lblIds.Text + "',"; } } if (where != " Id in (") { where = where.Substring(0, where.Length - 1) + ")"; //var sql = "update KIS.[KingdeeInvoice].[dbo].[Invoice] set Isorder=1 where " + where; var sql = "update [KingdeeInvoice].[dbo].[Invoice] set Isorder=1 where " + where; DBHelp.ExeCommand(sql); } if (expWhere != " Id in (") { expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; //var sql = "update KIS.[KingdeeInvoice].[dbo].[Invoice] set Isorder=null where " + expWhere; var sql = "update [KingdeeInvoice].[dbo].[Invoice] set Isorder=null where " + expWhere; DBHelp.ExeCommand(sql); } base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } }
public bool FormCheck() { if (this.ddlCarNo.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择车牌号!');</script>"); this.ddlCarNo.Focus(); return(false); } if (this.txtMaintenanceTime.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写保养/加油时间!');</script>"); this.txtMaintenanceTime.Focus(); return(false); } if (txtMaintenanceTime.Text != "") { try { Convert.ToDateTime(txtMaintenanceTime.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的日期格式有误!');</script>"); txtMaintenanceTime.Focus(); return(false); } } if (this.txtDistance.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写公里数!');</script>"); this.txtDistance.Focus(); return(false); } if (CommHelp.VerifesToNum(txtDistance.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('公里数 格式错误!');</script>"); this.txtDistance.Focus(); return(false); } if (txtTotal.Text != "") { try { Convert.ToDecimal(txtTotal.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('金额格式有误!');</script>"); this.txtTotal.Focus(); return(false); } } return(true); }
protected void btnSave_Click(object sender, EventArgs e) { var propertyList = this.FIN_PropertyService.GetListArray(" MyProperty='个性'"); List <FIN_SpecCost> commCostList = new List <FIN_SpecCost>(); foreach (var m in propertyList) { if (!string.IsNullOrEmpty(Request["pro_" + m.Id])) { var newM = new FIN_SpecCost(); newM.CaiYear = ddlYear.Text + ddlMonth.Text; newM.CompId = Convert.ToInt32(ddlCompany.Text); newM.CostTypeId = m.Id; if (CommHelp.VerifesToNum(Request["pro_" + m.Id].ToString()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数值 格式错误!');</script>"); return; } newM.Total = Convert.ToDecimal(Request["pro_" + m.Id]); newM.UserID = Convert.ToInt32(ddlUser.Text); commCostList.Add(newM); } } FIN_SpecCostService commSer = new FIN_SpecCostService(); commSer.AddList(commCostList); base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); }
private bool Check() { if (string.IsNullOrEmpty(txtSupplierName.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('供应商名称不能为空!');</script>")); return false; } if (string.IsNullOrEmpty(txtTotal.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('金额不能为空!');</script>")); return false; } if (CommHelp.VerifesToNum(txtTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('金额格式错误!');</script>")); return false; } if (string.IsNullOrEmpty(dllUse.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('请选择用途!');</script>")); return false; } return true; }
public bool FormCheck() { string strErr = ""; if (this.txtBasePoType.Text.Trim().Length == 0) { strErr += "名称不能为空!\\n"; } if (CommHelp.VerifesToNum(txtReward.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('系数 格式错误!');</script>"); return(false); } try { Convert.ToDecimal(txtReward.Text); } catch (Exception) { strErr += "系数格式错误!\\n"; } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } return(true); }
public bool FormCheck() { if (this.txtPAItemName.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写绩效考核项名称!');</script>"); this.txtPAItemName.Focus(); return(false); } if (!string.IsNullOrEmpty(txtPAItemScore.Text)) { if (CommHelp.VerifesToNum(txtPAItemScore.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('分值 格式错误!');</script>"); return(false); } } if (!string.IsNullOrEmpty(txtPAItemAmount.Text)) { if (CommHelp.VerifesToNum(txtPAItemAmount.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('奖罚金额 格式错误!');</script>"); return(false); } } if (base.Request["PAItemId"] != null) { if (Convert.ToInt32(DBHelp.ExeScalar(string.Format("select count(*) from A_PAItem where A_PAItemName='{0}' and A_PAItemId<>{1}", this.txtPAItemName.Text.Trim(), base.Request["PAItemId"]))) > 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('绩效考核项名称已经存在,请重新填写!');</script>"); this.txtPAItemName.Focus(); return(false); } } else { if (Convert.ToInt32(DBHelp.ExeScalar(string.Format("select count(*) from A_PAItem where A_PAItemName='{0}'", this.txtPAItemName.Text.Trim()))) > 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('绩效考核项名称已经存在,请重新填写!');</script>"); this.txtPAItemName.Focus(); return(false); } } return(true); }
public bool FormCheck() { string strErr = ""; if (this.txtTeamLever.Text.Trim().Length == 0) { strErr += "姓名不能为空!\\n"; } //if (this.txtCardNo.Text.Trim().Length == 0) //{ // strErr += "身份证号不能为空!\\n"; //} if (this.txtContractStartTime.Text.Trim().Length == 0) { strErr += "合作起始时间不能为空!\\n"; } if (CommHelp.VerifesToDateTime(txtContractStartTime.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('合作起始时间 格式错误!');</script>"); return(false); } if (this.txtTeamPersonCount.Text.Trim().Length == 0) { strErr += "人员规模不能为空!\\n"; } if (CommHelp.VerifesToNum(txtTeamPersonCount.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('人员规模 格式错误!');</script>"); return(false); } if (!string.IsNullOrEmpty(txtPhone.Text) && txtPhone.Text.Length != 11) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('手机号码 格式错误!');</script>"); return(false); } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } return(true); }
public bool FormCheck() { string strErr = ""; if (this.txtTypeValue.Text.Trim().Length == 0) { strErr = "信息不能为空!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); this.txtTypeValue.Focus(); return(false); } if (CommHelp.VerifesToNum(txtTypeValue.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数字(天) 格式错误!');</script>"); return(false); } return(true); }
private void Show() { string sql = ""; if (txtYear.Text != "") { if (CommHelp.VerifesToNum(txtYear.Text) == false) { } sql += string.Format(" Jyear= {0}", txtYear.Text); } List <Fin_JieDate> list = this.jieDateService.GetListArray(sql); AspNetPager1.RecordCount = list.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = list; this.gvList.DataBind(); }
public bool FormCheck() { if (CommHelp.VerifesToNum(txtZhangQi.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成本账期 格式错误!');</script>"); return(false); } if (CommHelp.VerifesToNum(txtCeSuanDian.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成本测算 格式错误!');</script>"); return(false); } if (CommHelp.VerifesToNum(txtMonthLiLv.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成本月利率 格式错误!');</script>"); return(false); } return(true); }
public bool FormCheck() { string strErr = ""; if (this.txtWarnDays.Text.Trim().Length == 0) { strErr += "警示天数不能为空!\\n"; } else { if (CommHelp.VerifesToNum(txtWarnDays.Text) == false) { strErr += "警示天数格式错误!\\n"; } } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } return(true); }
public bool FormCheck() { string strErr = ""; if (this.txtPromiseSellTotal.Text.Trim().Length == 0 || CommHelp.VerifesToNum(txtPromiseSellTotal.Text) == false) { strErr = "承诺销售额指标 格式错误!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); this.txtPromiseSellTotal.Focus(); return(false); } if (this.txtPromiseProfit.Text.Trim().Length == 0 || CommHelp.VerifesToNum(txtPromiseProfit.Text) == false) { strErr = "承诺利润 格式错误!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); this.txtPromiseProfit.Focus(); return(false); } if (this.txtAddGuetSellTotal.Text.Trim().Length == 0 || CommHelp.VerifesToNum(txtAddGuetSellTotal.Text) == false) { strErr = "新客户承诺销售额 格式错误!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); this.txtAddGuetSellTotal.Focus(); return(false); } if (this.txtAddGuestProfit.Text.Trim().Length == 0 || CommHelp.VerifesToNum(txtAddGuestProfit.Text) == false) { strErr = "新客户承诺利润 格式错误!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); this.txtAddGuestProfit.Focus(); return(false); } return(true); }
private void Show() { if (!string.IsNullOrEmpty(txtGoodAvgPrice.Text)) { if (CommHelp.VerifesToNum(txtGoodAvgPrice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('商品均价 格式错误!');</script>"); return; } } List <TB_Good> gooQGooddList = this.goodSer.GetListArray_New(GetSql()); lblHadInvoice.Text = string.Format("{0:n2}", gooQGooddList.Sum(t => t.HadInvoice)); lblNoInvoice.Text = string.Format("{0:n2}", gooQGooddList.Sum(t => t.NoInvoice)); lblHouseTotal.Text = string.Format("{0:n2}", gooQGooddList.Sum(t => t.GoodTotal)); AspNetPager1.RecordCount = gooQGooddList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = gooQGooddList; this.gvList.DataBind(); }
public bool FormCheck() { string strErr = ""; if (txtPayXiShu.Text == "") { strErr += "激励系数格式错误!\\n"; base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } if (CommHelp.VerifesToNum(txtPayXiShu.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('激励系数 格式错误!');</script>"); return(false); } try { Convert.ToDecimal(txtPayXiShu.Text); } catch (Exception) { strErr += "激励系数格式错误!\\n"; } if (Convert.ToDecimal(txtPayXiShu.Text) > 1000 || Convert.ToDecimal(txtPayXiShu.Text) < 0) { strErr += "激励系数格式在数值0---1000之间!\\n"; } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } return(true); }
public string GetWhereSql() { string sql = " 1=1 "; if (string.IsNullOrEmpty(txtFrom.Text) || string.IsNullOrEmpty(txtTo.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择盘点日期!');</script>"); return("-1"); } if (CommHelp.VerifesToDateTime(txtFrom.Text) == false || CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('盘点日期 格式错误!');</script>"); return("-1"); } if (txtGoodAvgPrice.Text != "") { try { if (Convert.ToDecimal(txtGoodAvgPrice.Text) <= 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('商品均价必须大于0!');</script>"); return(""); } sql += string.Format(" and GoodAvgPrice {0} {1}", ddlPrice.Text, txtGoodAvgPrice.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('商品均价格式有误!');</script>"); return("-1"); } } if (txtCaiKuNum.Text != "") { if (CommHelp.VerifesToNum(txtCaiKuNum.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('采购需出格式出错!');</script>"); return("-1"); } sql += string.Format("and isnull(SumKuXuCai,0){0}{1}", ddlCaiKuNum.Text, txtCaiKuNum.Text); } if (txtZhiLiuNum.Text != "") { if (CommHelp.VerifesToNum(txtZhiLiuNum.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('滞留库存格式出错!');</script>"); return("-1"); } sql += string.Format("and (isnull(GoodNum,0)-isnull(SumKuXuCai,0)){0}{1}", ddlZhiLiuNum.Text, txtZhiLiuNum.Text); } if (!string.IsNullOrEmpty(txtNum.Text)) { if (CommHelp.VerifesToNum(txtNum.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('库存格式出错!');</script>"); return("-1"); } sql += string.Format(" and isnull(GoodNum,0){0}{1}", ddlFuHao.SelectedItem.Text, txtNum.Text); } if (txtZhuJi.Text != "") { //string goodName = txtZhuJi.Text.Replace(@"\", ","); string[] allList = txtZhuJi.Text.Split('\\'); if (allList.Length != 7) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('商品格式不正确!');</script>"); return("-1"); } int goodId = goodsSer.GetGoodId(allList[1], allList[3], allList[4], allList[2], allList[5]); if (goodId == 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的商品不存在!');</script>"); return("-1"); } sql += string.Format(" and TB_Good.GoodId={0}", goodId); } if (ddlGoodSmType.Text != "" && ddlGoodType.Text != "") { sql += string.Format(" and GoodTypeSmName ='{0}' ", ddlGoodSmType.SelectedItem.Value); } else { if (ddlGoodSmType.Text != "" && ddlGoodType.Text == "") { sql += string.Format(" and GoodTypeSmName ='{0}' ", ddlGoodSmType.SelectedItem.Value); } if (ddlGoodSmType.Text == "" && ddlGoodType.Text != "") { sql += string.Format(" and GoodTypeName ='{0}'", ddlGoodType.SelectedItem.Value); } } if (ddlHouse.Text != "" && ddlHouse.Text != "0") { sql += string.Format(" and HouseId ={0}", ddlHouse.SelectedItem.Value); } if (txtGoodNo.Text != "") { sql += string.Format(" and TB_Good.GoodNo like '%{0}%'", txtGoodNo.Text); } if (txtNameOrTypeOrSpec.Text != "" && txtNameOrTypeOrSpecTwo.Text != "") { sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') or (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))", txtNameOrTypeOrSpec.Text, txtNameOrTypeOrSpecTwo.Text); } else if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "") { var NameOrTypeOrSpec = ""; if (txtNameOrTypeOrSpec.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpec.Text; } if (txtNameOrTypeOrSpecTwo.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo.Text; } sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')", NameOrTypeOrSpec); } if (txtNameOrTypeOrSpec2.Text != "" || txtNameOrTypeOrSpecTwo2.Text != "") { if (txtNameOrTypeOrSpec2.Text != "" && txtNameOrTypeOrSpecTwo2.Text != "") { sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') and (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))", txtNameOrTypeOrSpec2.Text, txtNameOrTypeOrSpecTwo2.Text); } else if (txtNameOrTypeOrSpec2.Text != "" || txtNameOrTypeOrSpecTwo2.Text != "") { var NameOrTypeOrSpec = ""; if (txtNameOrTypeOrSpec2.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpec2.Text; } if (txtNameOrTypeOrSpecTwo2.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo2.Text; } sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')", NameOrTypeOrSpec); } } if (ddlArea.Text != "") { sql += string.Format(" and GoodArea='{0}'", ddlArea.Text); } if (ddlNumber.Text != "") { sql += string.Format(" and GoodNumber='{0}'", ddlNumber.Text); } if (ddlRow.Text != "") { sql += string.Format(" and GoodRow='{0}'", ddlRow.Text); } if (ddlCol.Text != "") { sql += string.Format(" and GoodCol='{0}'", ddlCol.Text); } return(sql); }
private List <ElectronicInvoice> GetData() { billTypeList = new Invoice_BillTypeService().GetListArray(" IsStop=0"); personList = new Invoice_PersonService().GetListArray(" IsStop=0"); var sql = ""; var sumWhere = "having 1=1"; if (txtSmallTotal.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtSmallTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('金额 格式错误!');</script>"); return(null); } sumWhere += string.Format(" and {1}{0}isnull(sum(ActPay),0) ", ddlLeftTotal.Text, txtSmallTotal.Text.Trim()); } if (txtBigTotal.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtBigTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('金额 格式错误!');</script>"); return(null); } sumWhere += string.Format(" and isnull(sum(ActPay),0){0} {1}", ddlTotal.Text, txtBigTotal.Text.Trim()); } if (txtPFNo.Text.Trim() != "") { sql += string.Format(" and LastFPNo like '%{0}%'", txtPFNo.Text.Trim()); } //if (txtNotPFNo.Text.Trim() != "") //{ // sql += string.Format(" and LastFPNo <>'{0}'", txtNotPFNo.Text.Trim()); //} if (txtSupplierBrandName.Text.Trim() != "") { sql += string.Format(" and SupplierBrandName like '%{0}%'", txtSupplierBrandName.Text.Trim()); } if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return(null); } sql += string.Format(" and PONo like '%{0}%'", txtPONo.Text.Trim()); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目日期 格式错误!');</script>"); return(null); } sql += string.Format(" and PODate>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目日期 格式错误!');</script>"); return(null); } sql += string.Format(" and PODate<='{0} 23:59:59'", txtTo.Text); } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return(null); } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (ddlUser.Text != "-1") { sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text); } //if (ddlCompany.Text != "-1") //{ // sql += string.Format(" and AE='{0}'", ddlCompany.SelectedItem.Text); //} if (!string.IsNullOrEmpty(txtSupplierName.Text)) { if (cbSupplierName.Checked == false) { sql += string.Format(" and SupplierName like '%{0}%'", txtSupplierName.Text.Trim()); } else { sql += string.Format(" and SupplierName='{0}'", txtSupplierName.Text.Trim()); } } if (!string.IsNullOrEmpty(txtSupplierSimpName.Text)) { if (cbSupplierSimpName.Checked == false) { sql += string.Format(" and SupplieSimpeName like '%{0}%'", txtSupplierSimpName.Text.Trim()); } else { sql += string.Format(" and SupplieSimpeName='{0}'", txtSupplierSimpName.Text.Trim()); } } if (ddlPayType.Text != "-1") { sql += string.Format(" and busType='{0}'", ddlPayType.Text); } if (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } if (ddlPeculiarity.Text != "全部") { sql += string.Format(" and Peculiarity='{0}'", ddlPeculiarity.Text); } if (ddlProvince.Text != "") { sql += string.Format(" and Province='{0}'", ddlProvince.SelectedItem.Text); } if (ddlCity.Text != "") { sql += string.Format(" and City='{0}'", ddlCity.SelectedItem.Text); } var list = this.electronicInvoiceSer.GetReport(sql, sumWhere); var countList = list.GroupBy(t => t.busType + t.ProNo).Where(t => t.Count() > 1); foreach (var m in countList) { hb.Add(m.Key, null); } return(list); }
public void Show() { txtGuestName.Text = txtGuestName.Text.Trim(); txtInvoiceNo.Text = txtInvoiceNo.Text.Trim(); txtPOName.Text = txtPOName.Text.Trim(); if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } } List <InvoiceReport> invoiceList = new List <InvoiceReport>(); if (isSelect) { string sql = " where Sell_OrderFP.Status='通过' and Sell_OrderFP.FPNo<>'' "; string sql_1 = "where 1=1 "; if (txtGuestName.Text.Trim() != "") { sql_1 += string.Format(" and Sell_OrderFP.GuestNAME like '%{0}%'", txtGuestName.Text.Trim()); } if (txtInvoiceNo.Text.Trim() != "") { sql_1 += string.Format(" and FPNo like '%{0}%'", txtInvoiceNo.Text.Trim()); } if (cbZhengShu.Checked == false && txtInvoice.Text != "") { if (CommHelp.VerifesToNum(txtInvoice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误!');</script>"); return; } if (ddlInvTotal.Text == "=") { sql_1 += string.Format(" and Sell_OrderFP.Total in ({0},{1})", Convert.ToDecimal(txtInvoice.Text), -Convert.ToDecimal(txtInvoice.Text)); } else { sql_1 += string.Format(" and Sell_OrderFP.Total {0} {1}", ddlInvTotal.Text, txtInvoice.Text); } } if (cbZhengShu.Checked && txtInvoice.Text != "") { if (CommHelp.VerifesToNum(txtInvoice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误!');</script>"); return; } if (ddlInvTotal.Text == "=") { sql_1 += string.Format(" and Sell_OrderFP.Total ={0} ", txtInvoice.Text); } else { sql_1 += string.Format(" and Sell_OrderFP.Total {0} {1}", ddlInvTotal.Text, txtInvoice.Text); } } string param = "CG_POOrder.Status='通过'"; string temp = ""; if (ddlClose.Text != "-1" || ddlIsSelect.Text != "-1" || ddlHanShui.Text != "-1" || cbIsSpecial.Checked || cbJiaoFu.Checked || ddlUser.Text != "-1" || txtPOFrom.Text != "" || txtPOTo.Text != "" || txtPONo.Text != "" || ddlCompany.Text != "-1" || ddlModel.Text != "全部") { if (ddlClose.Text != "-1") { param += string.Format(" and IsClose={0}", ddlClose.Text); } if (ddlIsSelect.Text != "-1") { param += string.Format(" and IsSelected={0}", ddlIsSelect.Text); } if (ddlHanShui.Text != "-1") { param += string.Format(" and IsPoFax={0}", ddlHanShui.Text); } if (ddlModel.Text != "全部") { param += string.Format(" and Model='{0}'", ddlModel.Text); } if (cbIsSpecial.Checked) { param += string.Format(" and IsSpecial=0 "); } if (cbJiaoFu.Checked) { param += string.Format(" and POStatue2='已交付' "); } if (txtPOFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtPOFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } param += string.Format(" and PODate>='{0} 00:00:00'", txtPOFrom.Text); } if (txtPOTo.Text != "") { if (CommHelp.VerifesToDateTime(txtPOTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } param += string.Format(" and PODate<='{0} 23:59:59'", txtPOTo.Text); } if (ddlUser.Text != "-1") { param += string.Format(" and AppName={0} ", ddlUser.Text); } if (ddlCompany.Text != "-1") { string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]); param += string.Format(" and AppName IN(select id from tb_User where {0}) ", where); } if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return; } param += string.Format(" and Sell_OrderFP.PONO like '%{0}%' ", txtPONo.Text.Trim()); } if (!string.IsNullOrEmpty(txtPOName.Text)) { param += string.Format(" and Sell_OrderFP.PONAME like '%{0}%'", txtPOName.Text); } sql += string.Format(" and exists(select id from CG_POOrder where {0} and CG_POOrder.PONO=Sell_OrderFP.PONO and ifzhui=0)", param); temp = string.Format(" and exists(select id from CG_POOrder where {0} and CG_POOrder.PONO=Sell_OrderFP.PONO and ifzhui=0)", param); } if (ddlIsXiaozhang.Text != "-1") { } if (ddlCompare.Text == "2") { invoiceList = this.invoiceSer.GetAllInvoiceReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, "1", cbInvoTotalToge.Checked, ddlIsorder.Text, cbZhengShu.Checked, "", ddlIsXiaozhang.Text, param, temp); invoiceList.AddRange(this.invoiceSer.GetAllInvoiceReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, "0", cbInvoTotalToge.Checked, ddlIsorder.Text, cbZhengShu.Checked, "", ddlIsXiaozhang.Text, param, temp)); } else { if (Request["PONo"] != null) { invoiceList = this.invoiceSer.GetAllInvoiceReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, ddlCompare.Text, cbInvoTotalToge.Checked, ddlIsorder.Text, cbZhengShu.Checked, txtPONo.Text, ddlIsXiaozhang.Text, param, temp); } else { invoiceList = this.invoiceSer.GetAllInvoiceReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, ddlCompare.Text, cbInvoTotalToge.Checked, ddlIsorder.Text, cbZhengShu.Checked, "", ddlIsXiaozhang.Text, param, temp); } } isSelect = false; ViewState["myList"] = invoiceList; } else { invoiceList = ViewState["myList"] as List <InvoiceReport>; } AspNetPager1.RecordCount = invoiceList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; string allPONOs = ""; int pageIndex = gvList.PageIndex; for (int i = (pageIndex * 10); i < ((pageIndex + 1) * 10); i++) { if (i >= invoiceList.Count) { break; } if (!string.IsNullOrEmpty(invoiceList[i].OA_PONO)) { allPONOs += "'" + invoiceList[i].OA_PONO + "',"; } } allPONOs = allPONOs.Trim(','); if (allPONOs != "") { string ponos = string.Format(@"SELECT PONO,AE from CG_POOrder where Status='通过' and IFZhui=0 AND PONO IN ({0})", allPONOs); DataTable dt = DBHelp.getDataTable(ponos); list = new List <BaseModel>(); foreach (DataRow dr in dt.Rows) { list.Add(new BaseModel { key = dr[0].ToString(), AE = dr[1].ToString() }); } } this.gvList.DataSource = invoiceList; this.gvList.DataBind(); decimal OA_InvoiceTotal = 0; decimal Kingdee_InvoiceTotal = 0; Hashtable hs = new Hashtable(); Hashtable hs1 = new Hashtable(); foreach (var m in invoiceList) { if (!hs.ContainsKey(m.Kingdee_Id)) { Kingdee_InvoiceTotal += m.Kingdee_InvoiceTotal ?? 0; hs.Add(m.Kingdee_Id, null); } if (!hs1.ContainsKey(m.OA_FPId)) { OA_InvoiceTotal += m.OA_InvoiceTotal ?? 0; hs1.Add(m.OA_FPId, null); } } lblAllTotal.Text = invoiceList.Sum(t => t.All_InvoiceTotal ?? 0).ToString(); lblOATotal.Text = OA_InvoiceTotal.ToString(); lblKingdeeTotal.Text = Kingdee_InvoiceTotal.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { if (txtNum.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtNum.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量 格式错误!');</script>"); return; } } if (txtCostPrice.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtCostPrice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('单价 格式错误!');</script>"); return; } } //int goodId = goodsSer.GetGoodId(txtInvName.Text, lblSpec.Text, txtModel.Text,lblGoodSmTypeName.Text,txtUnit.Text); //if (goodId == 0) //{ // base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的商品不存在!');</script>"); // return; //} try { Convert.ToDecimal(txtCostPrice.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的单价格式有误!');</script>"); return; } //var good= goodsSer.GetModel(goodId); tb_QuotePrice_InvDetails s = new tb_QuotePrice_InvDetails(); s.InvUnit = txtUnit.Text; s.InvPrice = Convert.ToDecimal(txtCostPrice.Text); s.InvGoodId = 0; s.InvName = txtInvName.Text; s.InvNum = Convert.ToDecimal(txtNum.Text); s.InvModel = lblSpec.Text; s.GoodBrand = txtGoodBrand.Text; s.Total = s.InvNum * s.InvPrice; s.Product = txtProduct.Text; s.GoodNo = txtGoodNo.Text; s.GoodTypeSmName = lblGoodSmTypeName.Text; s.InvRemark = txtRemark.Text; //修改 if (Request["index"] != null) { int index = Convert.ToInt32(Request["index"]); tb_QuotePrice_InvDetails model = ViewState["m"] as tb_QuotePrice_InvDetails; s.Id = model.Id; s.IfUpdate = true; s.UpdateIndex = Convert.ToInt32(Request["index"]); Session["m"] = s; this.ClientScript.RegisterStartupScript(this.GetType(), null, "<script> window.close();</script>"); } else { if (Session["InvDetails"] == null) { List <tb_QuotePrice_InvDetails> invDetails = new List <tb_QuotePrice_InvDetails>(); invDetails.Insert(invDetails.Count, s); Session["InvDetails"] = invDetails; } else { List <tb_QuotePrice_InvDetails> invDetails = Session["InvDetails"] as List <tb_QuotePrice_InvDetails>; invDetails.Insert(invDetails.Count, s); Session["InvDetails"] = invDetails; } clear(); } // this.ClientScript.RegisterStartupScript(this.GetType(), null, "<script> window.close();</script>"); }
private void Show() { if (ddlFKDF.Text != "-1" && !string.IsNullOrEmpty(txtFKDF.Text)) { if (CommHelp.VerifesToNum(txtFKDF.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('反馈得分 格式错误!');</script>"); return; } } if (ddlAllScore.Text != "-1" && !string.IsNullOrEmpty(txtAllScore.Text)) { if (CommHelp.VerifesToNum(txtAllScore.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('综合得分 格式错误!');</script>"); return; } } string sql = " "; if (ddlCompany.Text != "-1") { string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]); sql += string.Format(" and exists (select id from tb_User where IFZhui=0 and {0} and CG_POOrder.appName=id)", where); } if (txtPONo.Text != "") { sql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text); } if (ttxPOName.Text != "") { sql += string.Format(" and CG_POOrder.POName like '%{0}%'", ttxPOName.Text); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } sql += string.Format(" and CG_POOrder.PODate>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } sql += string.Format(" and CG_POOrder.PODate<='{0} 23:59:59'", txtTo.Text); } if (txtGuestName.Text != "") { sql += string.Format(" and CG_POOrder.GuestName like '%{0}%'", txtGuestName.Text); } var isColse = ""; if (ddlIsClose.Text != "-1") { isColse = " and IsClose=" + ddlIsClose.Text; } if (ddlIsSelect.Text != "-1") { isColse += " and IsSelected=" + ddlIsSelect.Text; } if (ddlPOTyle.Text != "-1") { isColse += " and CG_POOrder.POType=" + ddlPOTyle.Text; } if (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } if (ddlJieIsSelected.Text != "-1") { isColse += " and JieIsSelected=" + ddlJieIsSelected.Text; } //if (ViewState["showAll"] != null) //{ // sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]); //} //if (ddlGuestTypeList.SelectedValue != "全部") //{ // sql += string.Format(" and EXISTS (select id from TB_GuestTrack where MyGuestType='{0}' and TB_GuestTrack.id=CG_POOrder.GuestId )",ddlGuestTypeList.SelectedValue); //} if (ddlGuestTypeList.SelectedValue != "全部") { sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue); } if (ddlGuestProList.SelectedValue != "-2") { sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue); } if (ddlUser.Text == "-1")//显示所有用户 { if (ddlIsSpecial.Text != "-1") { sql += string.Format(" and IsSpecial={1} {0} ", isColse, ddlIsSpecial.Text); //sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=0 AND PONO=JXC_REPORT.PONO {0})", isColse); } //else //{ // sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=1 AND PONO=JXC_REPORT.PONO {0})", isColse); //} //var model = Session["userInfo"] as User; //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职') AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]); } else if (ddlUser.Text == "0")//显示部门信息 { var model = Session["userInfo"] as User; //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO )", model.LoginIPosition); if (ddlIsSpecial.Text != "-1") { sql += string.Format(" and CG_POOrder.AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') and IsSpecial={2} {1}", model.LoginIPosition, isColse, ddlIsSpecial.Text); // sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", model.LoginIPosition, isColse); } else { sql += string.Format(" and CG_POOrder.AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') {1}", model.LoginIPosition, isColse); //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", model.LoginIPosition, isColse); } } else { if (ddlIsSpecial.Text != "-1") { sql += string.Format(" and CG_POOrder.AppName={0} and IsSpecial={2} {1} ", ddlUser.Text, isColse, ddlIsSpecial.Text); //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", ddlUser.Text, isColse); } else { sql += string.Format(" and CG_POOrder.AppName={0} {1} ", ddlUser.Text, isColse); //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", ddlUser.Text, isColse); } //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", ddlUser.Text); } if (CheckBox1.Checked || CheckBox2.Checked || CheckBox3.Checked || CheckBox4.Checked) { sql += " and exists ( select ID from CG_POOrder where PONO=JXC_REPORT.PONO"; if (CheckBox1.Checked) { sql += string.Format(" and POStatue='{0}'", CheckBox1.Text); } if (CheckBox2.Checked) { sql += string.Format(" and POStatue2='{0}'", CheckBox2.Text); } if (CheckBox3.Checked) { sql += string.Format(" and POStatue3='{0}'", CheckBox3.Text); } if (CheckBox4.Checked) { sql += string.Format(" and POStatue4='{0}'", CheckBox4.Text); } sql += ")"; } string having = " having "; if (CheckBox5.Checked && CheckBox6.Checked) { having += string.Format(" (avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null) and (avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null)"); } else if (CheckBox5.Checked || CheckBox6.Checked) { if (CheckBox5.Checked) { having += string.Format(" avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null "); } if (CheckBox6.Checked) { having += string.Format(" avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null "); } } else { having = ""; } string fuhao = " where 1=1 "; if (ddlFKDF.Text != "-1" && !string.IsNullOrEmpty(txtFKDF.Text)) { fuhao += string.Format(" and MyValue{0}{1}", ddlFKDF.Text, txtFKDF.Text); } if (ddlFuHao.Text != "-1") { fuhao = string.Format(" where SumPOTotal {0} isnull(goodSellTotal,0)", ddlFuHao.Text); } if (ddlPOFaTotal.Text != "-1") { fuhao += string.Format(" and SumPOTotal {0} isnull(SellFPTotal,0)", ddlPOFaTotal.Text); } if (ddlShiJiDaoKuan.Text != "-1") { fuhao += string.Format(" and SumPOTotal {0} isnull(InvoTotal,0)", ddlShiJiDaoKuan.Text); } if (ddlEquPOTotal.Text != "-1") { if (CommHelp.VerifesToNum(txtEquTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误!');</script>"); return; } fuhao += string.Format(" and SumPOTotal{0}{1}", ddlEquPOTotal.Text, txtEquTotal.Text); } if (ddlJingLiTotal.Text != "-1") { fuhao += string.Format(" and maoliTotal {0} (isnull(InvoTotal,0)-isnull(goodTotal,0))", ddlJingLiTotal.Text); } if (!string.IsNullOrEmpty(txtProProfit.Text) && ddlProProfit.Text != "-1") { if (CommHelp.VerifesToNum(txtProProfit.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目净利 格式错误!');</script>"); return; } fuhao += string.Format(" and maoliTotal {0} {1}", ddlProProfit.Text, txtProProfit.Text); } if (!string.IsNullOrEmpty(txtProTureProfit.Text) && ddlProTureProfit.Text != "-1") { if (CommHelp.VerifesToNum(txtProTureProfit.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('实际净利 格式错误!');</script>"); return; } fuhao += string.Format(" and InvoTotal-goodTotal {0} {1}", ddlProTureProfit.Text, txtProTureProfit.Text); } if (ddlPaiGong.Text != "-1") { //fuhao += string.Format(" and OutDispater={0}", ddlPaiGong.Text); if (ddlPaiGong.Text != "-1000") { fuhao += string.Format(" and OutDispater={0}", ddlPaiGong.Text); } else { string userIds = ""; foreach (ListItem item in ddlPaiGong.Items) { if (item.Value != "-1" && item.Value != "-1000") { userIds += string.Format("{0},", item.Value); } } fuhao += string.Format(" and OutDispater not in ({0})", userIds.Trim(',')); } } if (txtPGFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtPGFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('派工时间 格式错误!');</script>"); return; } fuhao += string.Format(" and DisDate>='{0} 00:00:00'", txtPGFrom.Text); } if (txtPGTo.Text != "") { if (CommHelp.VerifesToDateTime(txtPGTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('派工时间 格式错误!');</script>"); return; } fuhao += string.Format(" and DisDate<='{0} 23:59:59'", txtPGTo.Text); } if (ddlJingLi.Text != "-1" && !string.IsNullOrEmpty(txtJingLi.Text)) { if (CommHelp.VerifesToNum(txtJingLi.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('净利润率 格式错误!');</script>"); return; } } List <JXC_REPORTTotal> pOOrderList = this.POSer.GetSkill_Total(sql, having, fuhao); if (ddlTrueZhangQI.Text != "-1") { if (ddlTrueZhangQI.Text == "1") { pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi <= 30); } if (ddlTrueZhangQI.Text == "2") { pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 30 && T.trueZhangQi <= 60); } if (ddlTrueZhangQI.Text == "3") { pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 60 && T.trueZhangQi <= 90); } if (ddlTrueZhangQI.Text == "4") { pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 90 && T.trueZhangQi <= 120); } if (ddlTrueZhangQI.Text == "5") { pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 120); } } if (ddlJingLi.Text != "-1" && !string.IsNullOrEmpty(txtJingLi.Text)) { decimal jingLi = Convert.ToDecimal(txtJingLi.Text); if (ddlJingLi.Text == ">") { pOOrderList = pOOrderList.FindAll(t => t.JingLi > jingLi); } if (ddlJingLi.Text == "<") { pOOrderList = pOOrderList.FindAll(t => t.JingLi < jingLi); } if (ddlJingLi.Text == ">=") { pOOrderList = pOOrderList.FindAll(t => t.JingLi >= jingLi); } if (ddlJingLi.Text == "<=") { pOOrderList = pOOrderList.FindAll(t => t.JingLi <= jingLi); } if (ddlJingLi.Text == "=") { pOOrderList = pOOrderList.FindAll(t => t.JingLi == jingLi); } } if (ddlAllScore.Text != "-1" && !string.IsNullOrEmpty(txtAllScore.Text)) { if (CommHelp.VerifesToNum(txtAllScore.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('综合得分 格式错误!');</script>"); return; } fuhao = ddlAllScore.Text; decimal allScore = Convert.ToDecimal(txtAllScore.Text); if (fuhao == ">") { pOOrderList = pOOrderList.FindAll(t => t.allScore > allScore); } if (fuhao == "<") { pOOrderList = pOOrderList.FindAll(t => t.allScore < allScore); } if (fuhao == ">=") { pOOrderList = pOOrderList.FindAll(t => t.allScore >= allScore); } if (fuhao == "<=") { pOOrderList = pOOrderList.FindAll(t => t.allScore <= allScore); } if (fuhao == "=") { pOOrderList = pOOrderList.FindAll(t => t.allScore == allScore); } if (fuhao == "<>") { pOOrderList = pOOrderList.FindAll(t => t.allScore == allScore); } } //var getAllPONos = pOOrderList.Aggregate("", (current, m) => current + ("'" + m.PONo + "',")).Trim(','); //lblVisAllPONO.Text = getAllPONos; Hashtable ht = new Hashtable(); decimal jlr = 0; decimal sumgoodSellTotal = 0; decimal sumTrueLiRun = 0; decimal sumSellFPTotal = 0; decimal sumSumPOTotal = 0; decimal sumInvoiceTotal = 0; foreach (var m in pOOrderList) { if (!ht.ContainsKey(m.PONo)) { jlr += m.maoliTotal; sumgoodSellTotal += m.goodSellTotal; sumTrueLiRun += m.TrueLiRun; sumSellFPTotal += m.SellFPTotal; sumSumPOTotal += m.SumPOTotal; sumInvoiceTotal += m.InvoiceTotal; ht.Add(m.PONo, null); } } lblJLR.Text = string.Format("{0:n6}", jlr); lblXSE.Text = string.Format("{0:n6}", sumgoodSellTotal); var trueLiRun = sumTrueLiRun; lblSJLR.Text = string.Format("{0:n6}", trueLiRun); lblFP.Text = string.Format("{0:n6}", sumSellFPTotal); // 项目总额:XXX decimal allPoTotal = sumSumPOTotal; lblAllPoTotal.Text = string.Format("{0:n6}", allPoTotal); //项目总利润率:YYY = 项目净利合计/XXX lblAllLRLv.Text = "0"; if (allPoTotal > 0) { lblAllLRLv.Text = string.Format("{0:f2}", (jlr / allPoTotal * 100)); } // 实际总利润率:ZZZ= 实际利润合计/XXX lblAllTrunLv.Text = "0"; if (allPoTotal > 0) { lblAllTrunLv.Text = string.Format("{0:f2}", (trueLiRun / allPoTotal * 100)); } //项目到款总额:TTT= 实到帐的合计 var allDaoKuan = sumInvoiceTotal; lblAllDaoKuan.Text = string.Format("{0:n6}", allDaoKuan); //到款率: VVV=TTT/XXX lblAllDaoKuanLv.Text = "0"; if (allPoTotal > 0) { lblAllDaoKuanLv.Text = string.Format("{0:f2}", (allDaoKuan / allPoTotal * 100)); } //开票率:LLL= 发票总额合计 /XXX var faPiaoTotal = sumSellFPTotal;// pOOrderList.Sum(t => t.SellFPTotal); lblAllFaPiaoLv.Text = "0"; if (allPoTotal > 0) { lblAllFaPiaoLv.Text = string.Format("{0:f2}", (faPiaoTotal / allPoTotal * 100)); } var sumAllScore = pOOrderList.Sum(t => t.allScore); var sumMyValue = pOOrderList.Sum(t => t.MyValue); var count = pOOrderList.Count(t => t.DisDate != null); lblAllScore.Text = string.Format("{0:f2}", sumAllScore); lblFanKuiScore.Text = string.Format("{0:f2}", sumMyValue); if (count == 0) { lblAvgScore.Text = string.Format("{0:f2}", 0); lblAvgFKscore.Text = string.Format("{0:f2}", 0); } else { lblAvgScore.Text = string.Format("{0:f2}", sumAllScore / count); lblAvgFKscore.Text = string.Format("{0:f2}", sumMyValue / count); } AspNetPager1.RecordCount = pOOrderList.Count; this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //pager.TotalCount = pOOrderList.Count; //PagerControl page= gvMain.BottomPagerRow.Cells[0].FindControl("myPage") as PagerControl; //page.TotalCount = pOOrderList.Count; //page.BindData(); // AspNetPager1.CustomInfoHTML = "第<font color='red'><b>%currentPageIndex%</b></font>页,共%PageCount%页,每页显示%PageSize%条记录"; }
private void Show(bool isPrint = false) { string sql = " 1=1 "; if (txtBusFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtBusFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('公交费发票号码 格式错误!');</script>"); return; } if (txtRepastFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtRepastFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('餐饮发票号码 格式错误!');</script>"); return; } if (txtHotelFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtHotelFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('住宿发票号码 格式错误!');</script>"); return; } if (txtOilFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtOilFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('汽油发票号码 格式错误!');</script>"); return; } if (txtGuoBeginFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtGuoBeginFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('过路费发票号码 格式错误!');</script>"); return; } if (txtPostFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtPostFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('邮寄发票号码 格式错误!');</script>"); return; } if (txtOtherFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtOtherFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('其它费用发票号码 格式错误!');</script>"); return; } if (txtCaiFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtCaiFPNO.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('小额采购发票号码 格式错误!');</script>"); return; } if (txtBusFPNO.Text.Trim() != "") { sql += string.Format(" and BusFPNO like '%{0}%'", txtBusFPNO.Text.Trim()); } if (txtRepastFPNO.Text.Trim() != "") { sql += string.Format(" and RepastFPNO like '%{0}%'", txtRepastFPNO.Text.Trim()); } if (txtHotelFPNO.Text.Trim() != "") { sql += string.Format(" and HotelFPNO like '%{0}%'", txtHotelFPNO.Text.Trim()); } if (txtOilFPNO.Text.Trim() != "") { sql += string.Format(" and OilFPNO like '%{0}%'", txtOilFPNO.Text); } if (txtGuoBeginFPNO.Text.Trim() != "") { sql += string.Format(" and GuoBeginFPNO like '%{0}%'", txtGuoBeginFPNO.Text.Trim()); } if (txtPostFPNO.Text.Trim() != "") { sql += string.Format(" and PostFPNO like '%{0}%'", txtPostFPNO.Text.Trim()); } if (txtOtherFPNO.Text.Trim() != "") { sql += string.Format(" and OtherFPNO like '%{0}%'", txtOtherFPNO.Text.Trim()); } if (txtCaiFPNO.Text.Trim() != "") { sql += string.Format(" and CaiFPNO like '%{0}%'", txtCaiFPNO.Text.Trim()); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误!');</script>"); return; } sql += string.Format(" and Tb_DispatchList.CreateTime>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误!');</script>"); return; } sql += string.Format(" and Tb_DispatchList.CreateTime<='{0} 23:59:59'", txtTo.Text); } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and Tb_DispatchList.GuestName like '%{0}%'", txtGuestName.Text.Trim()); } if (txtPOName.Text.Trim() != "") { sql += string.Format(" and Tb_DispatchList.POName like '%{0}%'", txtPOName.Text.Trim()); } if (txtPONO.Text.Trim() != "") { if (CheckPoNO(txtPONO.Text) == false) { return; } sql += string.Format(" and Tb_DispatchList.PONo like '%{0}%'", txtPONO.Text.Trim()); } if (ddlFuHao.Text != "-1" && !string.IsNullOrEmpty(txtTotal.Text)) { if (CommHelp.VerifesToNum(txtTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('报销金额 格式错误!');</script>"); return; } sql += string.Format(" and ISNULL(BusTotal,0)+ISNULL(RepastTotal,0)+ISNULL(HotelTotal,0)+ISNULL(OilTotal,0)+ISNULL(GuoTotal,0)+ISNULL(PostTotal,0)+ISNULL(Tb_DispatchList.PoTotal,0)+ISNULL(OtherTotal,0) {0}{1}", ddlFuHao.Text, txtTotal.Text); } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and Tb_DispatchList.CardNo like '%{0}%'", txtProNo.Text.Trim()); } if (ddlFundType.Text != "-1") { if (ddlFundType.Text == "0")//公交费 { sql += string.Format(" and BusTotal is not null and BusTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "1")//餐饮费 { sql += string.Format(" and RepastTotal is not null and RepastTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "2")//住宿费 { sql += string.Format(" and HotelTotal is not null and HotelTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "3")//汽油补贴 { sql += string.Format(" and OilTotal is not null and OilTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "4")//过路费 { sql += string.Format(" and GuoTotal is not null and GuoTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "5")//邮寄费 { sql += string.Format(" and PostTotal is not null and PostTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "6")//小额采购 { sql += string.Format(" and Tb_DispatchList.PoTotal is not null and Tb_DispatchList.PoTotal>0", ddlFundType.Text); } else if (ddlFundType.Text == "7")//其他费用 { sql += string.Format(" and OtherTotal is not null and OtherTotal>0", ddlFundType.Text); } } if (ddlCompany.Text != "-1") { sql += string.Format(" and TB_Company.ComCode='{0}'", ddlCompany.Text.Split(',')[2]); } if (ddlUser.Text != "-1") { sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text); } if (ddlState.Text != "全部") { sql += string.Format(" and Tb_DispatchList.state='{0}'", ddlState.Text); } if (!string.IsNullOrEmpty(txtKeyWords.Text)) { sql += string.Format(@" and ([BusFromAddress] like '%{0}%' or [BusFromAddress] like '%{0}%' or [BusToAddress] like '%{0}%' or CONVERT(varchar(100), BusFromTime, 120) like '%{0}%' or CONVERT(varchar(100), BusToTime, 120) like '%{0}%' or [RepastAddress] like '%{0}%' or [RepastTotal] like '%{0}%' or [RepastPerNum] like '%{0}%' or [RepastPers] like '%{0}%' or [HotelAddress] like '%{0}%' or [HotelName] like '%{0}%' or [OilFromAddress] like '%{0}%' or [OilToAddress] like '%{0}%' or [OilLiCheng] like '%{0}%' or [GuoBeginAddress] like '%{0}%' or [GuoToAddress] like '%{0}%' or [PostFromAddress] like '%{0}%' or [PostToAddress] like '%{0}%' or [PoContext] like '%{0}%' or [OtherContext] like '%{0}%' or [BusRemark] like '%{0}%' or [RepastRemark] like '%{0}%' or [HotelRemark] like '%{0}%' or [OilRemark] like '%{0}%' or [GuoRemark] like '%{0}%' or [PostRemark] like '%{0}%' or Tb_DispatchList.[PoRemark] like '%{0}%' or [OtherRemark] like '%{0}%' or [PostNo] like '%{0}%' or [PostCompany] like '%{0}%' or [PostContext] like '%{0}%' or [PostToPer] like '%{0}%' or [Post_No] like '%{0}%')", txtKeyWords.Text); } if (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } //增加查询条件 if (ddlGuestTypeList.SelectedValue != "全部") { sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue); } if (ddlGuestProList.SelectedValue != "-2") { sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue); } if (ddlClose.Text != "-1") { sql += string.Format(" and CG_POOrder.IsClose={0} ", ddlClose.Text); } if (ddlIsSelect.Text != "-1") { sql += string.Format(" and CG_POOrder.IsSelected={0} ", ddlIsSelect.Text); } if (ddlJieIsSelected.Text != "-1") { sql += string.Format(" and CG_POOrder.JieIsSelected={0} ", ddlJieIsSelected.Text); } if (ddlIsSpecial.Text != "-1") { sql += string.Format(" and CG_POOrder.IsSpecial={0} ", ddlIsSpecial.Text); } if (!string.IsNullOrEmpty(txtPOSTNO.Text.Trim())) { sql += string.Format(" and PostNo LIKE '%{0}%' ", txtPOSTNO.Text.Trim()); } List <Tb_DispatchList> dispatchList = this.dispatchSer.GetListArrayReport(sql); if (isPrint) { Tb_DispatchList sumTotal = new Tb_DispatchList(); sumTotal.Total = dispatchList.Sum(t => t.Total); dispatchList.Add(sumTotal); } lblTotal.Text = dispatchList.Sum(t => t.Total).ToString(); AspNetPager1.RecordCount = dispatchList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = dispatchList; this.gvList.DataBind(); }
private void Show() { string sql = "1=1"; if (!string.IsNullOrEmpty(txtContract_No.Text.Trim())) { sql += string.Format(" and Contract_No like '%{0}%'", txtContract_No.Text.Trim()); } if (!string.IsNullOrEmpty(txtContract_Unit.Text.Trim())) { sql += string.Format(" and Contract_Unit like '%{0}%'", txtContract_Unit.Text.Trim()); } if (!string.IsNullOrEmpty(txtContract_Name.Text.Trim())) { sql += string.Format(" and Contract_Name like '%{0}%'", txtContract_Name.Text.Trim()); } if (!string.IsNullOrEmpty(txtContract_Summary.Text.Trim())) { sql += string.Format(" and Contract_Summary like '%{0}%'", txtContract_Summary.Text.Trim()); } if (!string.IsNullOrEmpty(txtPONo.Text.Trim())) { if (CheckPoNO(txtPONo.Text) == false) { return; } sql += string.Format(" and PONo like '%{0}%'", txtPONo.Text.Trim()); } if (!string.IsNullOrEmpty(txtContract_ProNo.Text)) { sql += string.Format(" and Contract_ProNo like '%{0}%'", txtContract_ProNo.Text.Trim()); } if (!string.IsNullOrEmpty(txtContract_Remark.Text)) { sql += string.Format(" and Contract_Remark like '%{0}%'", txtContract_Remark.Text.Trim()); } if (ddlContract_Type.Text != "-1") { sql += string.Format(" and Contract_Type={0}", ddlContract_Type.Text); } if (ddlContract_Use.Text != "-1") { sql += string.Format(" and Contract_Use='{0}'", ddlContract_Use.Text); } if (!string.IsNullOrEmpty(txtContract_Total.Text)) { if (CommHelp.VerifesToNum(txtContract_Total.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('总金额 格式错误!');</script>"); return; } sql += string.Format(" and Contract_Total{0}{1}", ddlContract_Total.Text, txtContract_Total.Text); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('签订时间 格式错误!');</script>"); return; } sql += string.Format(" and Contract_Date>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('签订时间 格式错误!');</script>"); return; } sql += string.Format(" and Contract_Date<='{0} 23:59:59'", txtTo.Text); } if (!string.IsNullOrEmpty(txtContract_PageCount.Text)) { if (CommHelp.VerifesToNum(txtContract_PageCount.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('合同总页数 格式错误!');</script>"); return; } sql += string.Format(" and Contract_PageCount{0}{1}", ddlContract_PageCount.Text, txtContract_PageCount.Text); } if (!string.IsNullOrEmpty(txtContract_AllCount.Text)) { if (CommHelp.VerifesToNum(txtContract_AllCount.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('合同总份数 格式错误!');</script>"); return; } sql += string.Format(" and Contract_AllCount{0}{1}", ddlContract_AllCount.Text, txtContract_AllCount.Text); } if (!string.IsNullOrEmpty(txtContract_BCount.Text)) { if (CommHelp.VerifesToNum(txtContract_BCount.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('己方份数 格式错误!');</script>"); return; } sql += string.Format(" and Contract_BCount{0}{1}", ddlContract_BCount.Text, txtContract_BCount.Text); } if (ddlAE.Text != "全部") { sql += string.Format(" and AE='{0}'", ddlAE.Text); } if (ddlContract_Brokerage.Text != "全部") { sql += string.Format(" and Contract_Brokerage='{0}'", ddlContract_Brokerage.Text); } if (ddlContract_IsSign.Text != "-1") { sql += string.Format(" and Contract_IsSign={0}", ddlContract_IsSign.Text); } if (ddlContract_Local.Text != "-1") { sql += string.Format(" and Contract_Local='{0}'", ddlContract_Local.Text); } if (ddlContract_Year.Text != "-1") { sql += string.Format(" and Contract_Year={0}", ddlContract_Year.Text); } if (ddlContract_Month.Text != "-1") { sql += string.Format(" and Contract_Month={0}", ddlContract_Month.Text); } if (ddlContract_IsRequire.Text != "-1") { sql += string.Format(" and Contract_IsRequire={0}", ddlContract_IsRequire.Text); } if (ddlModel.Text != "全部") { sql += string.Format(" and EXISTS (select ID from CG_POOrder where Model='{0}' AND PONO=Contract.PONO) ", ddlModel.Text); } List <Contract> caiList = this.contractSer.GetListArray(sql); lblTotal.Text = caiList.Sum(t => t.Contract_Total).ToString(); AspNetPager1.RecordCount = caiList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = caiList; this.gvList.DataBind(); }
public void Show() { string sql = " where Status='通过' "; string sql_1 = "where 1=1 "; txtGuestName.Text = txtGuestName.Text.Trim(); txtInvoiceNo.Text = txtInvoiceNo.Text.Trim(); if (txtGuestName.Text.Trim() != "") { sql_1 += string.Format(" and Sell_OrderFP.GuestNAME like '%{0}%'", txtGuestName.Text.Trim()); } if (txtInvoiceNo.Text != "") { sql_1 += string.Format(" and FPNo like '%{0}%'", txtInvoiceNo.Text); } if (cbZhengShu.Checked == false && txtInvoice.Text != "") { if (CommHelp.VerifesToNum(txtInvoice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误!');</script>"); return; } if (ddlInvTotal.Text == "=") { sql_1 += string.Format(" and Sell_OrderFP.Total in ({0},{1})", Convert.ToDecimal(txtInvoice.Text), -Convert.ToDecimal(txtInvoice.Text)); } else { sql_1 += string.Format(" and Sell_OrderFP.Total {0} {1}", ddlInvTotal.Text, txtInvoice.Text); } } if (cbZhengShu.Checked && txtInvoice.Text != "") { if (CommHelp.VerifesToNum(txtInvoice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误!');</script>"); return; } if (ddlInvTotal.Text == "=") { sql_1 += string.Format(" and Sell_OrderFP.Total ={0} ", txtInvoice.Text); } else { sql_1 += string.Format(" and Sell_OrderFP.Total {0} {1}", ddlInvTotal.Text, txtInvoice.Text); } } string param = "Status='通过'"; if (ddlClose.Text != "-1" || ddlIsSelect.Text != "-1" || ddlHanShui.Text != "-1" || cbIsSpecial.Checked || cbJiaoFu.Checked || ddlUser.Text != "-1" || txtPOFrom.Text != "" || txtPOTo.Text != "" || txtPONo.Text != "" || ddlCompany.Text != "-1" || ddlModel.Text != "全部") { if (ddlClose.Text != "-1") { param += string.Format(" and IsClose={0}", ddlClose.Text); } if (ddlIsSelect.Text != "-1") { param += string.Format(" and IsSelected={0}", ddlIsSelect.Text); } if (ddlHanShui.Text != "-1") { param += string.Format(" and IsPoFax={0}", ddlHanShui.Text); } if (cbIsSpecial.Checked) { param += string.Format(" and IsSpecial=0 "); } if (cbJiaoFu.Checked) { param += string.Format(" and POStatue2='已交付' "); } if (ddlModel.Text != "全部") { param += string.Format(" and Model='{0}'", ddlModel.Text); } if (txtPOFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtPOFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目日期 格式错误!');</script>"); return; } param += string.Format(" and PODate>='{0} 00:00:00'", txtPOFrom.Text); } if (txtPOTo.Text != "") { if (CommHelp.VerifesToDateTime(txtPOTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目日期 格式错误!');</script>"); return; } param += string.Format(" and PODate<='{0} 23:59:59'", txtPOTo.Text); } if (ddlUser.Text != "-1") { param += string.Format(" and AppName={0} ", ddlUser.Text); } if (ddlCompany.Text != "-1") { string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]); param += string.Format(" and AppName IN(select id from tb_User where {0}) ", where); } if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return; } param += string.Format(" and PONO like '%{0}%' ", txtPONo.Text.Trim()); } sql += string.Format(" and exists(select id from CG_POOrder where {0} and CG_POOrder.PONO=Sell_OrderFP.PONO and ifzhui=0)", param); } string diffDate = ""; if (ddlTime.Text == "0") { diffDate = " DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())<=30 "; } if (ddlTime.Text == "1") { diffDate = " DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())>30 and DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())<=60"; } if (ddlTime.Text == "2") { diffDate = " DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())>60 and DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())<=90"; } if (ddlTime.Text == "3") { diffDate = " DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())>90 and DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())<=120"; } if (ddlTime.Text == "4") { diffDate = " DATEDIFF(DAY,MAX(MaxRuTime),GETDATE())>120"; } if (string.IsNullOrEmpty(lblQuanXian.Text)) { gvList.Columns[6].Visible = true; } else { gvList.Columns[6].Visible = false; } if (!string.IsNullOrEmpty(txtFrom.Text)) { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } } if (!string.IsNullOrEmpty(txtTo.Text)) { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票日期 格式错误!');</script>"); return; } } List <AccountReport> invoiceList = new List <AccountReport>(); if (ddlCompare.Text == "2") { invoiceList = this.invoiceSer.GetAllAccountReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, "1", cbInvoTotalToge.Checked, ddlIsorder.Text, cbSameFP.Checked, diffDate, cbZhengShu.Checked); if (ddlCompareList.Text == "-1") { invoiceList.AddRange(this.invoiceSer.GetAllAccountReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, "0", cbInvoTotalToge.Checked, ddlIsorder.Text, cbSameFP.Checked, diffDate, cbZhengShu.Checked)); } } else { invoiceList = this.invoiceSer.GetAllAccountReports(txtGuestName.Text, txtInvoiceNo.Text, txtInvoice.Text, ddlInvTotal.Text, txtFrom.Text, txtTo.Text, sql, ddlCompare.Text, cbInvoTotalToge.Checked, ddlIsorder.Text, cbSameFP.Checked, diffDate, cbZhengShu.Checked, ddlCompareList.Text); } //if (ddlCompare.Text == "1" || ddlCompare.Text == "2") //{ // if (ddlCompareList.Text == "0") // { // invoiceList = invoiceList.FindAll(accountReport => accountReport.All_InvoiceTotal != null); // invoiceList = invoiceList.FindAll(accountReport => accountReport.All_OATotal == accountReport.All_InvoiceTotal // && accountReport.All_AccountTotal < accountReport.All_InvoiceTotal); // var invoiceList2= invoiceList.FindAll(accountReport => accountReport.All_InvoiceTotal != null); // invoiceList2 = invoiceList2.FindAll(accountReport => !(accountReport.All_OATotal < accountReport.All_InvoiceTotal // && accountReport.All_AccountTotal == accountReport.All_InvoiceTotal)); // invoiceList2 = invoiceList2.FindAll(accountReport => !((accountReport.All_OATotal == accountReport.All_InvoiceTotal // && accountReport.All_AccountTotal == accountReport.All_InvoiceTotal) || (accountReport.All_OATotal < accountReport.All_InvoiceTotal // && accountReport.All_AccountTotal < accountReport.All_InvoiceTotal))); // invoiceList2 = invoiceList2.FindAll(accountReport => !(accountReport.All_OATotal == accountReport.All_InvoiceTotal // && accountReport.All_AccountTotal < accountReport.All_InvoiceTotal)); // invoiceList.AddRange(invoiceList2); // } //} invoiceList = (from items in invoiceList orderby items.MaxDate descending select items).ToList(); AspNetPager1.RecordCount = invoiceList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; int pageIndex = gvList.PageIndex; string allFPNo = ""; string allPONOs = ""; for (int i = (pageIndex * 10); i < ((pageIndex + 1) * 10); i++) { if (i >= invoiceList.Count) { break; } if (!string.IsNullOrEmpty(invoiceList[i].All_InvoiceNo)) { allFPNo += "'" + invoiceList[i].All_InvoiceNo + "',"; allPONOs += "'" + invoiceList[i].All_PONO + "',"; } if (!string.IsNullOrEmpty(invoiceList[i].OA_InvoiceNo) && string.IsNullOrEmpty(invoiceList[i].OA_GuestName)) { allFPNo += "'" + invoiceList[i].OA_InvoiceNo + "',"; } } allFPNo = allFPNo.Trim(','); if (allFPNo != "") { string ponos = string.Format("SELECT FPNO,PONO,GuestNAME from Sell_OrderFP where Status='通过' and FPNO in ({0})GROUP BY FPNO,PONO,GuestNAME ", allFPNo); DataTable dt = DBHelp.getDataTable(ponos); list = new List <BaseModel>(); foreach (DataRow dr in dt.Rows) { list.Add(new BaseModel { key = dr[0].ToString(), value = dr[1].ToString(), value1 = dr[2].ToString() }); } } lblSumTotal.Text = ""; List <AccountReport> resultInvoiceList = new List <AccountReport>(); resultInvoiceList = invoiceList.FindAll(t => t.All_WeiInvoiceTotal > 0); //int[] b = { 53, 575, 55, 78, 340, 9, 121, 338, 39, 15 }; ViewState["result"] = resultInvoiceList; if (resultInvoiceList.Count <= 50) { Button1.Enabled = true; } else { Button1.Enabled = false; } lblSumTotal.Text = ""; this.gvList.DataSource = invoiceList; this.gvList.DataBind(); decimal OA_InvoiceTotal = 0; decimal Kingdee_InvoiceTotal = 0; Hashtable hs = new Hashtable(); Hashtable hs1 = new Hashtable(); foreach (var m in invoiceList) { if (!hs.ContainsKey(m.Kingdee_Id)) { Kingdee_InvoiceTotal += m.Kingdee_InvoiceTotal ?? 0; hs.Add(m.Kingdee_Id, null); } if (!hs1.ContainsKey(m.OA_FPId)) { OA_InvoiceTotal += m.OA_InvoiceTotal ?? 0; hs1.Add(m.OA_FPId, null); } } lblAllTotal.Text = invoiceList.Sum(t => t.All_InvoiceTotal ?? 0).ToString(); var All_OATotal = invoiceList.Sum(t => t.All_OATotal ?? 0); lblAllOATotal.Text = All_OATotal.ToString(); var All_AccountTotal = invoiceList.Sum(t => t.All_AccountTotal ?? 0); lblAllKinDaoTotal.Text = All_AccountTotal.ToString(); lblAllFPTotal.Text = invoiceList.Sum(t => t.All_InvoiceTotal ?? 0).ToString(); lblALLDiffTotal.Text = (All_OATotal - All_AccountTotal).ToString(); lblWeiAllOATotal.Text = invoiceList.Sum(t => t.All_WeiOATotal ?? 0).ToString(); lblWeiAllKinDaoTotal.Text = invoiceList.Sum(t => t.All_WeiInvoiceTotal).ToString(); lblOATotal.Text = OA_InvoiceTotal.ToString(); lblKingdeeTotal.Text = Kingdee_InvoiceTotal.ToString(); }
public bool FormCheck() { string strErr = ""; if (this.txtProNo.Text.Trim().Length == 0) { strErr += "单据号不能为空!\\n"; } if (this.txtOutTotal.Text.Trim().Length == 0) { strErr += "出账金额不能为空!\\n"; } if (CommHelp.VerifesToNum(this.txtOutTotal.Text.Trim()) == false) { strErr += "出账金额格式错误!\\n"; } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } if (ddlOutType.Text == "支付单" || ddlOutType.Text == "预付款单" || ddlOutType.Text == "申请请款单" || ddlOutType.Text == "预期报销单") { if (string.IsNullOrEmpty(txtTotal.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", "请点击获取单据金额")); return(false); } //当下拉框选择 预付款单和支付单 时,点击获取样金额 后,单据的抬头必须严格和收款人名称一(除了单据抬头是淘宝,本部门,本部门(含税),淘宝(含1.33税) , //京东 ,京东商城 可以不一样) ,修改或添加 才能保存数据,否则提示预付款单和支付单 抬头必须一致 if (ddlOutType.Text == "支付单" || ddlOutType.Text == "预付款单") { //中文括号转为英文 string name = txtName.Text.Trim().Replace("(", "(").Replace(")", ")"); if (lblInPayeeName.Text.Replace("(", "(").Replace(")", ")") != name && (name != "淘宝" && name != "本部门" && name != "本部门(含税)" && name != "淘宝(含1.33税)" && name != "上海圆迈贸易有限公司")) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", "预付款单和支付单 抬头必须一致")); return(false); } } decimal total = Convert.ToDecimal(txtTotal.Text); decimal outTotal = Convert.ToDecimal(txtOutTotal.Text); string sqlsumTotal = string.Format("select isnull(sum(OutTotal),0) from Out_BankFlow where ProNo='{0}' and OutType='{1}'", txtProNo.Text.Trim(), ddlOutType.Text); if (base.Request["Id"] != null) { sqlsumTotal += " and id<>" + Request["Id"]; } var sumTotal = Convert.ToDecimal(DBHelp.ExeScalar(sqlsumTotal)); if (sumTotal + outTotal > total) { strErr = "该单据号剩余金额" + (total - sumTotal) + " !\\n"; } if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } } string sql = string.Format("select ISNULL(SUM(OutTotal),0) AS SUMOutTotal FROM Out_BankFlow where ReferenceNumber='{0}'", lblReferenceNumber.Text); if (base.Request["Id"] != null) { sql += " and id<>" + Request["Id"]; } string mainSql = string.Format("select TradeAmount from BankFlow where TransactionReferenceNumber='{0}'", lblReferenceNumber.Text); decimal lastTotal = System.Math.Abs(Convert.ToDecimal(DBHelp.ExeScalar(mainSql))) - Convert.ToDecimal(DBHelp.ExeScalar(sql)); if (lastTotal < Convert.ToDecimal(txtOutTotal.Text)) { strErr = string.Format("出账剩余总金额:{0},请重新填写", lastTotal); base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } if (txtProNo.Text != "") { txtProNo.Text = txtProNo.Text.Trim(); if (CheckProNo(txtProNo.Text) == false) { return(false); } } return(true); }
private void Show() { if (ddlFPType.Items.Count >= 2) { ddlFPType.Items[ddlFPType.Items.Count - 2].Attributes.Add("style", "background-color: red"); } string sql = " 1=1 "; if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text.Trim()) == false) { return; } sql += string.Format(" and Sell_OrderFP.PONo like '%{0}%'", txtPONo.Text.Trim()); } if (ttxPOName.Text.Trim() != "") { sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text.Trim()); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误!');</script>"); return; } sql += string.Format(" and RuTime>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误!');</script>"); return; } sql += string.Format(" and RuTime<='{0} 23:59:59'", txtTo.Text); } if (ddlStatue.Text != "") { sql += string.Format(" and Status='{0}'", ddlStatue.Text); } else { sql += string.Format(" and Status<>'不通过'"); } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text.Trim()) == false) { return; } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); } if (!string.IsNullOrEmpty(txtFPTotal.Text)) { if (CommHelp.VerifesToNum(txtFPTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误!');</script>"); return; } sql += string.Format(" and Total {0}{1}", ddlPOFaTotal.Text, txtFPTotal.Text); } if (!string.IsNullOrEmpty(txtOldFPTotal.Text)) { if (CommHelp.VerifesToNum(txtOldFPTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('原金额 格式错误!');</script>"); return; } sql += string.Format(" and TopTotal {0}{1}", ddlOldPOFaTotal.Text, txtOldFPTotal.Text); } if (txtOldFPNo.Text != "") { sql += string.Format(" and TopFPNo like '%{0}%'", txtOldFPNo.Text); } if (ddlIsSelect.Text != "-1" && ddlIsClose.Text != "-1" && ddlJieIsSelected.Text != "-1" && ddlIsSpecial.Text != "-1" && ddlModel.Text != "全部") { sql += string.Format(" and exists(select id from CG_POOrder where Status='通过' and IsClose={0} and IsSelected={1} and JieIsSelected={2} and IsSpecial={3} and model={4} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsClose.Text, ddlIsSelect.Text, ddlJieIsSelected.Text, ddlIsSpecial.Text, ddlModel.Text); } else { if (ddlIsClose.Text != "-1") { sql += string.Format(" and exists(select id from CG_POOrder where Status='通过' and IsClose={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsClose.Text); } if (ddlIsSelect.Text != "-1") { sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and IsSelected={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsSelect.Text); } if (ddlJieIsSelected.Text != "-1") { sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and JieIsSelected={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlJieIsSelected.Text); } if (ddlIsSpecial.Text != "-1") { sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and IsSpecial={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsSpecial.Text); } if (ddlModel.Text != "全部") { sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and model='{0}' and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlModel.Text); } } if (ddlUser.Text != "-1") { sql += string.Format(" and CreateUserId={0}", ddlUser.Text); } if (ddlCompany.Text != "-1") { string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]); sql += string.Format(" and CreateUserId IN(select id from tb_User where {0})", where); } if (txtFPNo.Text.Trim() != "") { sql += string.Format(" and FPNo like '%{0}%'", txtFPNo.Text.Trim()); } if (ddlType.Text == "0") { sql += string.Format(" and exists(select Sell_OrderFPBack.id from Sell_OrderFPBack where Status='通过' and FPNo=Sell_OrderFP.FPNo )"); } if (ddlType.Text == "1") { sql += string.Format(" and not exists(select Sell_OrderFPBack.id from Sell_OrderFPBack where Status='通过' and FPNo=Sell_OrderFP.FPNo)"); } if (ddlPOInvoiceState.Text == "1")//发票数<项目数 { //sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal>sumTotal )"); sql += string.Format(" and SumPoTotal-TuiTotal>sumTotal "); } else if (ddlPOInvoiceState.Text == "2")//发票数>项目数 { //sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal<sumTotal )"); sql += string.Format(" and SumPoTotal-TuiTotal<sumTotal "); } else if (ddlPOInvoiceState.Text == "3")//发票数=项目数 { //sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal=sumTotal )"); sql += string.Format(" and SumPoTotal-TuiTotal=sumTotal "); } if (ddlFPType.Text != "-1") { if (ddlFPType.SelectedItem.Text != "其他") { sql += string.Format(" and FPNoStyle='{0}'", ddlFPType.SelectedItem.Text); } else { sql += string.Format(" and FPNoStyle not in (select FpType from FpTypeBaseInfo) and FPNoStyle<>''"); } } if (ddlGuestTypeList.SelectedValue != "全部" || ddlGuestProList.SelectedValue != "-2") { string where = ""; if (ddlGuestTypeList.SelectedValue != "全部") { where += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue); } if (ddlGuestProList.SelectedValue != "-2") { where += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue); } sql += string.Format("and exists(select id from CG_POOrder where Status='通过' {0} and CG_POOrder.PONO=Sell_OrderFP.PONO and IFZhui=0) ", where); } List <Sell_OrderFP> pOOrderList = this.POSer.GetListArray(sql); decimal allTotal = 0; decimal allPoTotal = 0; System.Collections.Hashtable hs = new Hashtable(); foreach (var m in pOOrderList) { allTotal += m.Total; if (!hs.Contains(m.PONo)) { allPoTotal += m.AllPoTotal; hs.Add(m.PONo, null); } } lblAllTotal.Text = allTotal.ToString(); lblAllPoTotal.Text = allPoTotal.ToString(); AspNetPager1.RecordCount = pOOrderList.Count; this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //if (pOOrderList.Count > 0) //{ // CG_POOrderService orderSer = new CG_POOrderService(); // var list = orderSer.GetOrder_ToInvoice_1(string.Format(" PONo='{0}'", pOOrderList[0].PONo)); // if (list.Count > 0) // { // lblPOTotal.Text = "项目(" + pOOrderList[0].PONo+")---" + (list[0].POTotal - list[0].TuiTotal).ToString(); // } // else // { // lblPOTotal.Text = "0"; // } //lblPOTotal.Text = ""; //} //子单 List <Sell_OrderFPs> orders = new List <Sell_OrderFPs>(); gvList.DataSource = orders; gvList.DataBind(); }
private void AdvancePaymentShow() { string sql = " CAI_POOrder.Status='通过' "; if (txtAdvancePaymentPoNo.Text.Trim() != "") { if (CheckPoNO(txtAdvancePaymentPoNo.Text) == false) { return; } sql += string.Format(" and PONo like '%{0}%'", txtAdvancePaymentPoNo.Text.Trim()); } if (txtAdvancePaymentPoName.Text.Trim() != "") { sql += string.Format(" and POName like '%{0}%'", txtAdvancePaymentPoName.Text.Trim()); } if (txtAdvancePaymentProNo.Text.Trim() != "") { if (CheckProNo(txtAdvancePaymentProNo.Text) == false) { return; } sql += string.Format(" and CAI_POOrder.ProNo like '%{0}%'", txtAdvancePaymentProNo.Text.Trim()); } if (txtAdvancePaymentSupplierName.Text.Trim() != "") { if (cbAdvancePiPei.Checked == false) { sql += string.Format(" and lastSupplier like '%{0}%'", txtAdvancePaymentSupplierName.Text.Trim()); } else { sql += string.Format(" and lastSupplier ='{0}'", txtAdvancePaymentSupplierName.Text.Trim()); } } if (cbNoKuCun.Checked) { sql += string.Format(" and lastSupplier<>'库存'"); } if (txtAdvancePaymentGoodNo.Text != "") { sql += string.Format(" and GoodNo like '%{0}%'", txtAdvancePaymentGoodNo.Text); } if (txtNameOrTypeOrSpec1.Text != "" || txtNameOrTypeOrSpecTwo1.Text != "") { if (txtNameOrTypeOrSpec1.Text != "" && txtNameOrTypeOrSpecTwo1.Text != "") { sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') or (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))", txtNameOrTypeOrSpec1.Text, txtNameOrTypeOrSpecTwo1.Text); } else if (txtNameOrTypeOrSpec1.Text != "" || txtNameOrTypeOrSpecTwo1.Text != "") { var NameOrTypeOrSpec = ""; if (txtNameOrTypeOrSpec1.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpec1.Text; } if (txtNameOrTypeOrSpecTwo1.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo1.Text; } sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')", NameOrTypeOrSpec); } } if (txtCaiNum1.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtCaiNum1.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('采购数 格式错误!');</script>"); return; } sql += string.Format(" and Num{0} {1}", ddlCaiNum1.Text, txtCaiNum1.Text.Trim()); } if (txtCaiPrice1.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtCaiPrice1.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('采购单价 格式错误!');</script>"); return; } sql += string.Format(" and lastPrice{0} {1}", ddlCaiPrice1.Text, txtCaiPrice1.Text.Trim()); } if (ddlAdvanceTemp.Text != "-1") { sql += " and IsCAITemp=" + ddlAdvanceTemp.Text; } if (ddlAdvUserList.Text != "-1") { sql += string.Format(" and CAI_POOrder.AE='{0}'", ddlAdvUserList.SelectedItem.Text); } string poDateSql = ""; if (txtYuPoDateFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtYuPoDateFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } poDateSql += string.Format(" and PODate>='{0} 00:00:00'", txtYuPoDateFrom.Text); } if (txtYuPoDateTo.Text != "") { if (CommHelp.VerifesToDateTime(txtYuPoDateTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } poDateSql += string.Format(" and PODate<='{0} 23:59:59'", txtYuPoDateTo.Text); } if (!string.IsNullOrEmpty(poDateSql)) { sql += string.Format(@" and (EXISTS (select ID from CG_POOrder where CG_POOrder.PONO=CAI_POOrder.PONO and IFZhui=0 {0}) or (1=1 {0}))", poDateSql); } //去除不必要的 //model.IfRuKu || (model.GoodNum * model.GoodPrice - model.SupplierInvoiceTotal) <= 0 List <SupplierToInvoiceView> pOOrderList = supplierToInvoiceSer.GetSupplierAdvancePaymentList(sql); if (cbAdvanceGuolv.Checked) { pOOrderList = pOOrderList.FindAll(t => t.IsShow); } AspNetPager2.RecordCount = pOOrderList.Count; this.gvAdvancePayment.PageIndex = AspNetPager2.CurrentPageIndex - 1; this.gvAdvancePayment.DataSource = pOOrderList; this.gvAdvancePayment.DataBind(); lblYuTotal.Text = YuTotal.ToString(); lblYu_ShengYuTotal.Text = Yu_ResultTotal.ToString(); lblYu_ShengyuzhijiaTotal.Text = Yu_ShengYuZhiJia.ToString(); }
public bool FormCheck() { string strErr = ""; if (this.txtPONo.Text.Trim().Length == 0) { strErr += "项目编号不能为空!\\n"; } //if (this.txtGuestName.Text.Trim().Length == 0) //{ // strErr += "客户名称不能为空!\\n"; //} if (this.txtSalesUnit.Text.Trim().Length == 0) { strErr += "采购单位不能为空!\\n"; } if (string.IsNullOrEmpty(txtName.Text)) { strErr += "签呈单名称不能为空!\\n"; } if (this.txtSummary.Text.Trim().Length == 0) { strErr += "签呈单摘要不能为空!\\n"; } if (CommHelp.VerifesToNum(txtTotal.Text) == false) { strErr += "总金额格式错误!\\n"; } if (CommHelp.VerifesToDateTime(txtSignDate.Text) == false) { strErr += "签订起始日期时间格式错误!\\n"; } if (CommHelp.VerifesToNum(txtSumPages.Text) == false) { strErr += "签呈单总页数格式错误!\\n"; } if (CommHelp.VerifesToNum(txtSumCount.Text) == false) { strErr += "签呈单总份数格式错误!\\n"; } if (CommHelp.VerifesToNum(txtBCount.Text) == false) { strErr += "己方份数格式错误!\\n"; } //if (cbIsRequire.Checked == false) //{ // if (this.txtPONo.Text.Trim().Length == 0) // { // strErr += "项目编号不能为空!\\n"; // } // if (this.txtAE.Text.Trim().Length == 0) // { // strErr += "AE不能为空!\\n"; // } //} if (strErr != "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr)); return(false); } return(true); }
private void Show() { //if(txtSupplier.Text=="") //{ // base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择供应商');</script>"); // return ; //} string sql = " 1=1 "; if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return; } sql += string.Format(" and PONo like '%{0}%'", txtPONo.Text.Trim()); } if (ttxPOName.Text.Trim() != "") { sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text.Trim()); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('入库时间 格式错误!');</script>"); return; } sql += string.Format(" and RuTime>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('入库时间 格式错误!');</script>"); return; } sql += string.Format(" and RuTime<='{0} 23:59:59'", txtTo.Text); } string poDateSql = ""; if (txtPoDateFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtPoDateFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } poDateSql += string.Format(" and PODate>='{0} 00:00:00'", txtPoDateFrom.Text); } if (txtPoDateTo.Text != "") { if (CommHelp.VerifesToDateTime(txtPoDateTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误!');</script>"); return; } poDateSql += string.Format(" and PODate<='{0} 23:59:59'", txtPoDateTo.Text); } if (!string.IsNullOrEmpty(poDateSql)) { sql += string.Format(@" and (EXISTS (select ID from CG_POOrder where CG_POOrder.PONO=CAI_OrderInHouse.PONO and IFZhui=0 {0}) or EXISTS (select ID from CAI_POOrder where CAI_POOrder.PONO = CAI_OrderInHouse.PONO and BusType = 1 {0}))", poDateSql); } if (ddlStatue.Text != "") { sql += string.Format(" and CAI_OrderInHouse.Status='{0}'", ddlStatue.Text); } else { sql += string.Format(" and CAI_OrderInHouse.Status<>'不通过'"); } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and CAI_OrderInHouse.ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (txtChcekProNo.Text.Trim() != "") { if (CheckProNo(txtChcekProNo.Text) == false) { return; } sql += string.Format(" and ChcekProNo like '%{0}%'", txtChcekProNo.Text.Trim()); } if (txtSupplier.Text.Trim() != "") { if (cbPiPei.Checked == false) { sql += string.Format(" and Supplier like '%{0}%'", txtSupplier.Text.Trim()); } else { sql += string.Format(" and Supplier ='{0}'", txtSupplier.Text.Trim()); } } if (ddlHouse.Text != "0") { sql += string.Format(" and HouseID={0}", ddlHouse.Text); } if (txtGoodNo.Text != "") { sql += string.Format(" and GoodNo like '%{0}%'", txtGoodNo.Text); } if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "") { if (txtNameOrTypeOrSpec.Text != "" && txtNameOrTypeOrSpecTwo.Text != "") { sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') or (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))", txtNameOrTypeOrSpec.Text, txtNameOrTypeOrSpecTwo.Text); } else if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "") { var NameOrTypeOrSpec = ""; if (txtNameOrTypeOrSpec.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpec.Text; } if (txtNameOrTypeOrSpecTwo.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo.Text; } sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')", NameOrTypeOrSpec); } } if (txtCaiNum.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtCaiNum.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('入库数 格式错误!');</script>"); return; } sql += string.Format(" and GoodNum{0} {1}", ddlCaiNum.Text, txtCaiNum.Text.Trim()); } if (txtCaiPrice.Text.Trim() != "") { if (CommHelp.VerifesToNum(txtCaiPrice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('采购单价 格式错误!');</script>"); return; } sql += string.Format(" and GoodPrice{0} {1}", ddlCaiPrice.Text, txtCaiPrice.Text.Trim()); } if (ddlTemp.Text != "-1") { sql += " and IsTemp=" + ddlTemp.Text; } if (ddlUser.Text != "-1") { sql += string.Format(" and EXISTS (select ID from CG_POOrder where CG_POOrder.PONO=CAI_OrderInHouse.PONO and AE='{0}')", ddlUser.SelectedItem.Text); } List <SupplierToInvoiceView> pOOrderList = supplierToInvoiceSer.GetListArray_New(sql); //过滤库存,库存的信息不要显示出来 pOOrderList = pOOrderList.FindAll(t => t.GuestName != "库存"); if (cbGuolv.Checked) { pOOrderList = pOOrderList.FindAll(t => t.IsShow); //pOOrderList = pOOrderList.FindAll(t => t.LastTotal != t.ResultTotal); } AspNetPager1.RecordCount = pOOrderList.Count; var temp = pOOrderList.Sum(t => t.ResultTotal); this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); lblTotalZhi.Text = TotalZhi.ToString(); lblShengYuTotal.Text = ResultTotal.ToString(); lblShengyuzhijiaTotal.Text = ShengYuZhiJia.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtNum.Text)&&CommHelp.VerifesToNum(txtNum.Text)==false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量 格式有误!');</script>"); return; } if (!string.IsNullOrEmpty(txtOtherCost.Text) && CommHelp.VerifesToNum(txtOtherCost.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('管理费 格式有误!');</script>"); return; } if (!string.IsNullOrEmpty(txtSellPrice.Text) && CommHelp.VerifesToNum(txtSellPrice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('销售单价 格式有误!');</script>"); return; } if (!string.IsNullOrEmpty(txtCostPrice.Text) && CommHelp.VerifesToNum(txtCostPrice.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成本单价 格式有误!');</script>"); return; } if (txtToTime.Text != "") { try { Convert.ToDateTime(txtToTime.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('到帐日期格式有误!');</script>"); return; } } if (CommHelp.GetByteLen(lblModel.Text) > 20 * 2) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('型号长度不能超过20个汉字符,请修正!');</script>"); return; } if (CommHelp.GetByteLen(txtDetailRemark.Text) > 20 * 2) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('备注长度不能超过20个汉字符,请修正!');</script>"); return; } int goodId = goodsSer.GetGoodId(txtInvName.Text, lblSpec.Text, lblModel.Text,lblGoodSmTypeName.Text,lblUnit.Text); if (goodId == 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的商品不存在!');</script>"); return; } try { Convert.ToDecimal(txtSellPrice.Text); Convert.ToDecimal(txtCostPrice.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的单价格式有误!');</script>"); return; } // var goodModel = goodsSer.GetModel(goodId); CG_POOrders s = new CG_POOrders(); s.GoodNo = txtGoodNo.Text;// goodModel.GoodNo; s.GoodId = goodId; s.GoodUnit =lblUnit.Text; s.GoodName = txtInvName.Text; s.GoodSpec = lblSpec.Text; s.Good_Model = lblModel.Text; s.GoodTypeSmName = lblGoodSmTypeName.Text; s.CostPrice = Convert.ToDecimal(txtCostPrice.Text); s.DetailRemark = txtDetailRemark.Text; s.InvName = txtInvName.Text; s.Num = Convert.ToDecimal(txtNum.Text); if (txtOtherCost.Text != "") s.OtherCost = Convert.ToDecimal(txtOtherCost.Text); if (txtProfit.Text != "") s.Profit = Convert.ToDecimal(txtProfit.Text); s.SellPrice = Convert.ToDecimal(txtSellPrice.Text); if (txtToTime.Text != "") { s.ToTime = Convert.ToDateTime(txtToTime.Text); } s.CostTotal = s.CostPrice * s.Num; s.SellTotal=s.SellPrice*s.Num; s.YiLiTotal = s.SellTotal - s.CostTotal - s.OtherCost; if (s.SellTotal != 0) s.Profit = s.YiLiTotal / s.SellTotal * 100; else if (s.YiLiTotal != 0) { s.Profit = -100; } else { s.Profit = 0; } //修改 if (Request["index"] != null) { int index = Convert.ToInt32(Request["index"]); //List<CG_POOrders> POOrders = Session["Orders"] as List<CG_POOrders>; CG_POOrders model = ViewState["m"] as CG_POOrders; s.Ids = model.Ids; s.IfUpdate = true; s.UpdateIndex = Convert.ToInt32(Request["index"]); Session["m"] = s; this.ClientScript.RegisterStartupScript(this.GetType(), null, "<script> window.close();</script>"); } else { if (ViewState["Orders"] == null) { List<CG_POOrders> POOrders = new List<CG_POOrders>(); POOrders.Insert(POOrders.Count, s); ViewState["Orders"] = POOrders; } else { List<CG_POOrders> POOrders = ViewState["Orders"] as List<CG_POOrders>; POOrders.Insert(POOrders.Count , s); ViewState["Orders"] = POOrders; } clear(); } // this.ClientScript.RegisterStartupScript(this.GetType(), null, "<script> window.close();</script>"); }
public bool FormCheck() { if (this.txtGuestName.Text.Trim() == "" || txtGuestName.Text == "0") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择客户名称!');</script>"); this.txtGuestName.Focus(); return(false); } if (this.txtRemark.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写报价概要!');</script>"); this.txtRemark.Focus(); return(false); } List <tb_QuotePrice_InvDetails> invDetails = Session["DataInvDetails"] as List <tb_QuotePrice_InvDetails>; if (invDetails.Count <= 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请添加报价内容!');</script>"); return(false); } if (cbYH.Checked && string.IsNullOrEmpty(txtResultYH.Text)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请添填写最终优惠价!');</script>"); return(false); } //最终优惠价:ZZ,ZZ是一个输入框内的值,缺省=报价单内的所有费用合计, //但可以修改,修改的值不能超过 缺省值,否则提交 提示“优惠价格必须小于合计价格” if (cbYH.Checked) { //计算总价 //只要小于 计税设备材料人工基数+工程计税 var sumTotal = Convert.ToDecimal(lblTotalDetailsXiao.Text) + Convert.ToDecimal(string.IsNullOrEmpty(txtLaborCost.Text) ? "0" : txtLaborCost.Text) + Convert.ToDecimal(string.IsNullOrEmpty(txtEngineeringTax.Text) ? "0" : txtEngineeringTax.Text); if (Convert.ToDecimal(txtResultYH.Text) >= sumTotal) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('优惠价格必须小于合计价格!');</script>"); return(false); } } if (!string.IsNullOrEmpty(txtLaborCost.Text)) { if (CommHelp.VerifesToNum(txtLaborCost.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('人工费用 格式错误!');</script>"); return(false); } } if (!string.IsNullOrEmpty(txtXX.Text)) { if (CommHelp.VerifesToNum(txtXX.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('工程计税 格式错误!');</script>"); return(false); } } if (!string.IsNullOrEmpty(txtResultYH.Text)) { if (CommHelp.VerifesToNum(txtResultYH.Text.Trim()) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('最终优惠价 格式错误!');</script>"); return(false); } } return(true); }