/// <summary> /// 删除订单 /// </summary> /// <param name="id">订单的id值</param> private void Del(int id) { To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(id); if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); if (model == null || model.auditstatus != "01") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('订单已删除或审核员已审核')</script>"); } else if (!To_OrderInfoManager.CanDelete(id)) { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('该订单关联过收款或付款或退款或报销,无法删除')</script>"); } else { string strdel = " jobflowid=" + jobflowid; AuditJobFlowManager.Delete(strdel); JobFlowManager.Delete(jobflowid); To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(id)); To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(id)); To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(id)); To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(id)); } } }
/// <summary> /// 更新的方法 /// </summary> private string AuditUpdate(string args, string auditstatus, int id) { To_OrderInfo orderModle = To_OrderInfoManager.getTo_OrderInfoById(id); JobFlow jobModel = JobFlowManager.GetModel(orderModle.JobflowID); jobModel.savestatus = args; jobModel.auditstatus = auditstatus; JobFlowManager.Update(jobModel); return(orderModle.OrderNum); }
public static bool updateOrderGross(To_OrderInfo orderInfo) { string sql = "update To_OrderInfo set gross=@gross where id=@id "; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@gross", orderInfo.Gross), new SqlParameter("@id", orderInfo.Id) }; return(DBHelper.ExecuteCommand(sql, sp) > 0); }
public static To_OrderInfo getTo_OrderInfoByOrderNum(string orderID) { To_OrderInfo to_orderinfo = null; string sql = "select * from To_OrderInfo where orderNum=@orderNum"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@orderNum", orderID) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { to_orderinfo = new To_OrderInfo(); foreach (DataRow dr in dt.Rows) { to_orderinfo.Id = Convert.ToInt32(dr["id"]); to_orderinfo.OrderNum = Convert.ToString(dr["orderNum"]); to_orderinfo.OrderType = Convert.ToString(dr["orderType"]); to_orderinfo.OutTime = Convert.ToDateTime(dr["outTime"]); to_orderinfo.TeamNum = Convert.ToString(dr["teamNum"]); to_orderinfo.Natrue = Convert.ToString(dr["natrue"]); to_orderinfo.Tour = Convert.ToString(dr["tour"]); to_orderinfo.TourRemark = Convert.ToString(dr["tourRemark"]); to_orderinfo.MarkId = Convert.ToInt32(dr["markId"]); to_orderinfo.MakerName = Convert.ToString(dr["makerName"]); to_orderinfo.MakerTime = Convert.ToDateTime(dr["makerTime"]); to_orderinfo.Gross = Convert.ToDouble(dr["gross"]); to_orderinfo.JobflowID = Convert.ToInt32(dr["jobflowID"]); to_orderinfo.Verify = Convert.ToInt32(dr["verify"]); to_orderinfo.ApprovalID = Convert.ToInt32(dr["approvalID"]); to_orderinfo.CollectAmount = Convert.ToDouble(dr["collectAmount"]); to_orderinfo.CollectCusID = Convert.ToString(dr["collectCusID"]); to_orderinfo.PayAmount = Convert.ToDouble(dr["payAmount"]); to_orderinfo.PayCusID = Convert.ToString(dr["payCusID"]); to_orderinfo.RefundAmount = Convert.ToDouble(dr["refundAmount"]); to_orderinfo.RefundID = Convert.ToString(dr["refundID"]); to_orderinfo.ReimAmount = Convert.ToDouble(dr["reimAmount"]); to_orderinfo.ReimID = Convert.ToString(dr["reimID"]); to_orderinfo.Codeformat = Convert.ToString(dr["codeformat"]); to_orderinfo.Codenum = Convert.ToString(dr["codenum"]); to_orderinfo.DepartAutoCode = Convert.ToString(dr["departautocode"]); to_orderinfo.IsCancel = Convert.ToString(dr["iscancel"]); to_orderinfo.Inputer = Convert.ToString(dr["inputer"]); to_orderinfo.InputerID = Convert.ToInt32(dr["inputerID"]); to_orderinfo.InputerTc = Convert.ToDouble(dr["inputerTc"]); to_orderinfo.InputerTc_status = Convert.ToString(dr["inputerTc_status"]); } } return(to_orderinfo); }
/// <summary> /// 绑定数据 /// </summary> private void OrderLoad() { //string jfId = Request.QueryString["jobflowid"].ToString(); //string sqlstring = " jobflowID=" + jfId; //DataTable dtOrder = To_OrderInfoManager.GetLists(sqlstring); //if (dtOrder.Rows.Count == 0) //{ // Page.ClientScript.RegisterStartupScript(this.GetType(), "audit", "alert('数据出错,订单可能已删除!');location.href='../Job/AuditJobFlow.aspx'", true); // return; //} int id = Convert.ToInt32(Request.QueryString["id"]); //int id = Convert.ToInt32(dtOrder.Rows[0]["id"]); To_OrderInfo order = To_OrderInfoManager.getTo_OrderInfoById(id); DataTable dt = To_OrderInfoManager.GetLists(" id = " + id); if (dt.Rows.Count > 0) { this.lblOrderCode.Text = order.OrderNum.ToString(); this.lblOrderType.Text = Convert.ToInt32(order.OrderType) == 1 ? "常规订单" : "非常规订单"; this.lblOutDate.Text = order.OutTime.ToShortDateString(); //出团日期 this.lblTotal.Text = order.TeamNum.ToString(); //团队总数 this.lblnature.Text = order.Natrue.ToString(); //性质 this.lblyjml.Text = order.Gross.ToString("F2"); //预计毛利 this.lblLine.Text = GetLineName(order.Tour); //线路 this.lblLineremark.Text = order.TourRemark; //线路描述 this.lblMarkTime.Text = order.MakerTime.ToShortDateString(); //制单时间 this.lblMakeID.Text = order.MakerName.ToString(); //制单人 this.lblIsCancel.Text = order.IsCancel == "Y" ? "是" : "否"; this.lblinputer.Text = order.Inputer; //操作人员 //收款 decimal col = LoadCol(id); //付款 decimal pay = LoadPay(id); //退款 decimal ret = LoadRet(id); //报销 decimal reim = LoadRem(id); this.lblsjml.Text = (col - pay + ret - reim).ToString("F2"); } LoadAuditImg(int.Parse(dt.Rows[0]["ruleid"].ToString())); optiniontxt.InnerHtml = ShowOpiniontxt(int.Parse(dt.Rows[0]["jobflowid"].ToString()));//审核人意见 LoadNowAudit(dt.Rows[0]["jobflowid"].ToString()); }
/// <summary> ///根据SQL语句获取集合 /// </summary> public static IList <To_OrderInfo> getTo_OrderInfosBySql(string sql) { IList <To_OrderInfo> list = new List <To_OrderInfo>(); DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { To_OrderInfo to_orderinfo = new To_OrderInfo(); to_orderinfo.Id = Convert.ToInt32(dr["id"]); to_orderinfo.OrderNum = Convert.ToString(dr["orderNum"]); to_orderinfo.OrderType = Convert.ToString(dr["orderType"]); to_orderinfo.OutTime = Convert.ToDateTime(dr["outTime"]); to_orderinfo.TeamNum = Convert.ToString(dr["teamNum"]); to_orderinfo.Natrue = Convert.ToString(dr["natrue"]); to_orderinfo.Tour = Convert.ToString(dr["tour"]); to_orderinfo.TourRemark = Convert.ToString(dr["tourRemark"]); to_orderinfo.MarkId = Convert.ToInt32(dr["markId"]); to_orderinfo.MakerName = Convert.ToString(dr["makerName"]); to_orderinfo.MakerTime = Convert.ToDateTime(dr["makerTime"]); to_orderinfo.Gross = Convert.ToDouble(dr["gross"]); to_orderinfo.JobflowID = Convert.ToInt32(dr["jobflowID"]); to_orderinfo.Verify = Convert.ToInt32(dr["verify"]); to_orderinfo.ApprovalID = Convert.ToInt32(dr["approvalID"]); to_orderinfo.CollectAmount = Convert.ToDouble(dr["collectAmount"]); to_orderinfo.CollectCusID = Convert.ToString(dr["collectCusID"]); to_orderinfo.PayAmount = Convert.ToDouble(dr["payAmount"]); to_orderinfo.PayCusID = Convert.ToString(dr["payCusID"]); to_orderinfo.RefundAmount = Convert.ToDouble(dr["refundAmount"]); to_orderinfo.RefundID = Convert.ToString(dr["refundID"]); to_orderinfo.ReimAmount = Convert.ToDouble(dr["reimAmount"]); to_orderinfo.ReimID = Convert.ToString(dr["reimID"]); to_orderinfo.Codeformat = Convert.ToString(dr["codeformat"]); to_orderinfo.Codenum = Convert.ToString(dr["codenum"]); to_orderinfo.DepartAutoCode = Convert.ToString(dr["departautocode"]); to_orderinfo.IsCancel = Convert.ToString(dr["iscancel"]); to_orderinfo.Inputer = Convert.ToString(dr["inputer"]); to_orderinfo.InputerID = Convert.ToInt32(dr["inputerID"]); to_orderinfo.InputerTc = Convert.ToDouble(dr["inputerTc"]); to_orderinfo.InputerTc_status = Convert.ToString(dr["inputerTc_status"]); list.Add(to_orderinfo); } } return(list); }
/// <summary> /// 编辑订单 /// </summary> /// <param name="id">订单id</param> private void Edit(int id) { To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(id); if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); if (model == null || model.auditstatus != "01") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('订单已删除或审核员已审核')</script>"); } else { Response.Redirect("UpdateOrder.aspx?id=" + Convert.ToInt32(id)); } } }
/// <summary> /// 删除订单 /// </summary> /// <param name="id">订单的id值</param> private void Del(int id) { To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(id); if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); string strdel = " jobflowid=" + jobflowid; AuditJobFlowManager.Delete(strdel); JobFlowManager.Delete(jobflowid); To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(id)); To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(id)); To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(id)); To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(id)); } }
protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e) { string delId = ""; //先遍历取得选中项 for (int i = 0; i < this.rpPoliy.Items.Count; i++) { CheckBox cbx = (CheckBox)(rpPoliy.Items[i].FindControl("cbx")); Label lbl = (Label)rpPoliy.Items[i].FindControl("lbl"); if (cbx != null || cbx.Text != "") { if (cbx.Checked) { delId += lbl.Text + ","; } } } //去掉最后一个, delId = (delId + ")").Replace(",)", ""); IList check = delId.Split(','); for (int i = 0; i < check.Count; i++) { To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(check[i])); if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); string strdel = " jobflowid=" + jobflowid; AuditJobFlowManager.Delete(strdel); JobFlowManager.Delete(jobflowid); To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(check[i])); To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(check[i])); To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(check[i])); To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(check[i])); } } BindData(); }
/// <summary> ///[To_OrderInfo]表修改的方法 /// </summary> public static int updateTo_OrderInfoById(To_OrderInfo to_orderinfo) { string sql = "update To_OrderInfo set orderNum=@orderNum,orderType=@orderType,outTime=@outTime,teamNum=@teamNum,natrue=@natrue,tour=@tour,tourRemark=@tourRemark,markId=@markId,makerName=@makerName,makerTime=@makerTime,gross=@gross,jobflowID=@jobflowID,verify=@verify,approvalID=@approvalID,collectAmount=@collectAmount,collectCusID=@collectCusID,payAmount=@payAmount,payCusID=@payCusID,refundAmount=@refundAmount,refundID=@refundID,reimAmount=@reimAmount,reimID=@reimID,codeformat=@codeformat,codenum=@codenum,departautocode=@departautocode,iscancel=@iscancel,inputer=@inputer,inputerID=@inputerID,inputerTc=@inputerTc where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", to_orderinfo.Id), new SqlParameter("@orderNum", to_orderinfo.OrderNum), new SqlParameter("@orderType", to_orderinfo.OrderType), new SqlParameter("@outTime", to_orderinfo.OutTime), new SqlParameter("@teamNum", to_orderinfo.TeamNum), new SqlParameter("@natrue", to_orderinfo.Natrue), new SqlParameter("@tour", to_orderinfo.Tour), new SqlParameter("@tourRemark", to_orderinfo.TourRemark), new SqlParameter("@markId", to_orderinfo.MarkId), new SqlParameter("@makerName", to_orderinfo.MakerName), new SqlParameter("@makerTime", to_orderinfo.MakerTime), new SqlParameter("@gross", to_orderinfo.Gross), new SqlParameter("@jobflowID", to_orderinfo.JobflowID), new SqlParameter("@verify", to_orderinfo.Verify), new SqlParameter("@approvalID", to_orderinfo.ApprovalID), new SqlParameter("@collectAmount", to_orderinfo.CollectAmount), new SqlParameter("@collectCusID", to_orderinfo.CollectCusID), new SqlParameter("@payAmount", to_orderinfo.PayAmount), new SqlParameter("@payCusID", to_orderinfo.PayCusID), new SqlParameter("@refundAmount", to_orderinfo.RefundAmount), new SqlParameter("@refundID", to_orderinfo.RefundID), new SqlParameter("@reimAmount", to_orderinfo.ReimAmount), new SqlParameter("@reimID", to_orderinfo.ReimID), new SqlParameter("@codeformat", to_orderinfo.Codeformat), new SqlParameter("@codenum", to_orderinfo.Codenum), new SqlParameter("@departautocode", to_orderinfo.DepartAutoCode), new SqlParameter("@iscancel", to_orderinfo.IsCancel), new SqlParameter("@inputer", to_orderinfo.Inputer), new SqlParameter("@inputerID", to_orderinfo.InputerID), new SqlParameter("@inputerTc", to_orderinfo.InputerTc) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///[To_OrderInfo]表添加的方法 /// </summary> public static int addTo_OrderInfo(To_OrderInfo to_orderinfo) { string sql = "insert into To_OrderInfo([orderNum],[orderType],[outTime],[teamNum],[natrue],[tour],[tourRemark],[markId],[makerName],[makerTime],[gross],[jobflowID],[verify],[approvalID],[collectAmount],[collectCusID],[payAmount],[payCusID],[refundAmount],[refundID],[reimAmount],[reimID],[codeformat],[codenum],[departautocode],[iscancel],[inputer],[inputerID],[inputerTc]) values (@orderNum,@orderType,@outTime,@teamNum,@natrue,@tour,@tourRemark,@markId,@makerName,@makerTime,@gross,@jobflowID,@verify,@approvalID,@collectAmount,@collectCusID,@payAmount,@payCusID,@refundAmount,@refundID,@reimAmount,@reimID,@codeformat,@codenum,@departautocode,@iscancel,@inputer,@inputerID,@inputerTc);select @@IDENTITY"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@orderNum", to_orderinfo.OrderNum), new SqlParameter("@orderType", to_orderinfo.OrderType), new SqlParameter("@outTime", to_orderinfo.OutTime), new SqlParameter("@teamNum", to_orderinfo.TeamNum), new SqlParameter("@natrue", to_orderinfo.Natrue), new SqlParameter("@tour", to_orderinfo.Tour), new SqlParameter("@tourRemark", to_orderinfo.TourRemark), new SqlParameter("@markId", to_orderinfo.MarkId), new SqlParameter("@makerName", to_orderinfo.MakerName), new SqlParameter("@makerTime", to_orderinfo.MakerTime), new SqlParameter("@gross", to_orderinfo.Gross), new SqlParameter("@jobflowID", to_orderinfo.JobflowID), new SqlParameter("@verify", to_orderinfo.Verify), new SqlParameter("@approvalID", to_orderinfo.ApprovalID), new SqlParameter("@collectAmount", to_orderinfo.CollectAmount), new SqlParameter("@collectCusID", to_orderinfo.CollectCusID), new SqlParameter("@payAmount", to_orderinfo.PayAmount), new SqlParameter("@payCusID", to_orderinfo.PayCusID), new SqlParameter("@refundAmount", to_orderinfo.RefundAmount), new SqlParameter("@refundID", to_orderinfo.RefundID), new SqlParameter("@reimAmount", to_orderinfo.ReimAmount), new SqlParameter("@reimID", to_orderinfo.ReimID), new SqlParameter("@codeformat", to_orderinfo.Codeformat), new SqlParameter("@codenum", to_orderinfo.Codenum), new SqlParameter("@departautocode", to_orderinfo.DepartAutoCode), new SqlParameter("@iscancel", to_orderinfo.IsCancel), new SqlParameter("@inputer", to_orderinfo.Inputer), new SqlParameter("@inputerID", to_orderinfo.InputerID), new SqlParameter("@inputerTc", to_orderinfo.InputerTc) }; //return DBHelper.ExecuteCommand(sql, sp); return(DBHelper.ExecuteScalar(sql, sp)); }
/// <summary> /// 绑定数据 /// </summary> private void OrderLoad() { string jfId = Request.QueryString["jobflowid"].ToString(); string sqlstring = " jobflowID=" + jfId; DataTable dtOrder = To_OrderInfoManager.GetLists(sqlstring); if (dtOrder.Rows.Count == 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "audit", "alert('数据出错,订单可能已删除!');location.href='../Job/AuditJobFlow.aspx'", true); return; } int id = Convert.ToInt32(dtOrder.Rows[0]["id"]); To_OrderInfo order = To_OrderInfoManager.getTo_OrderInfoById(id); this.lblOrderCode.Text = order.OrderNum.ToString(); this.lblOrderType.Text = Convert.ToInt32(order.OrderType) == 1 ? "常规订单" : "非常规订单"; this.lblOutDate.Text = order.OutTime.ToShortDateString(); this.lblTotal.Text = order.TeamNum.ToString(); this.lblnature.Text = order.Natrue.ToString(); this.lblyjml.Text = order.Gross.ToString("F2"); //预计毛利 this.lblLine.Text = GetLineName(order.Tour); //线路 this.lblLineremark.Text = order.TourRemark; //线路描述 this.lblMarkTime.Text = order.MakerTime.ToShortDateString(); this.lblMakeID.Text = order.MakerName.ToString(); this.lblinputer.Text = order.Inputer; //操作人员 //收款 decimal col = LoadCol(id); //付款 decimal pay = LoadPay(id); //退款 decimal ret = LoadRet(id); //报销 decimal reim = LoadRem(id); this.lblsjml.Text = (col - pay + ret - reim).ToString("F2"); }
/// <summary> /// 修改订单的预计毛利 /// </summary> /// <param name="orderInfo"></param> /// <returns></returns> public static bool updateOrderGross(To_OrderInfo orderInfo) { return(To_OrderInfoService.updateOrderGross(orderInfo)); }
public static int updateTo_OrderInfo(To_OrderInfo to_orderinfo) { return(To_OrderInfoService.updateTo_OrderInfoById(to_orderinfo)); }
public static int addTo_OrderInfo(To_OrderInfo to_orderinfo) { return(To_OrderInfoService.addTo_OrderInfo(to_orderinfo)); }
/// <summary> /// 操作 /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void cuslist_ItemCommand(object source, RepeaterCommandEventArgs e) { To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument)); switch (e.CommandName) { case "Delete": Del(Convert.ToInt32(e.CommandArgument)); //To_OrderReimDetialManager.deleteTo_OrderReimDetialByOrderID(Convert.ToInt32(e.CommandArgument)); break; case "Edit": if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); if (model.savestatus == "草稿" && model.auditstatus == "01") { Edit(Convert.ToInt32(e.CommandArgument)); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "edit", "alert('该订单已送审,无法修改,欲修改请先回收');", true); } } break; case "Detial": Response.Redirect("OrderDetial.aspx?id=" + Convert.ToInt32(e.CommandArgument)); break; case "Audit": if (orderinfo != null) { int jobflowid = orderinfo.JobflowID; JobFlow model = JobFlowManager.GetModel(jobflowid); if (model == null || model.auditstatus != "01" || model.savestatus == "已提交") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "audit", "<script>alert('订单已删除或订单已经送审或审核员已审核')</script>"); } else { To_OrderInfo orderModle = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument)); JobFlow jobModel = JobFlowManager.GetModel(orderModle.JobflowID); string ordernum = AuditUpdate("已提交", "01", Convert.ToInt32(e.CommandArgument)); CreateApproval(jobModel.ruleid, orderModle.JobflowID); SendMessage(ordernum.ToString(), jobModel.ruleid); } } break; case "Refresh": orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument)); Refresh(orderinfo.JobflowID); break; case "File": To_OrderInfoManager.updateFileStatus(1, Convert.ToInt32(e.CommandArgument)); break; case "delFile": To_OrderInfoManager.updateFileStatus(0, Convert.ToInt32(e.CommandArgument)); break; } OrderListBind(); }