using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;using Pur.Entity;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm;
using Pur.Entity.configureEntity;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Pur.Entity.pur_orderEntiy;
using Pur.configure;
using Pur.Pop_upWindow;
using Pur.require_plan;
using Core.Mes.Client.Comm.Tool;
using com.hnshituo.pur.vo;
using Infragistics.Win.UltraWinEditors;
using Pur.balance;
using Core.Mes.Client.Comm.Server;
using Infragistics.Win;
using CoreFS.SA06;
using Bpm;
using Pur.Balance;
using com.hnshituo.ck;
using Pur.Entity.ck;
using System.Web;
namespace Pur.order
{
public partial class FrmOrderMNew : FrmPmsBase
{
//合同条款区使用变量
string init_bcm_Id = "";
//价格政策
string init_balance_Id = "";
//合同上传
String fileName = "";
int intNum = 2;
public static string suppName = "";
//构造函数
public FrmOrderMNew()
{
InitializeComponent();
this.IsLoadUserView = true;
}
private DataTable dt_addItem = new DataTable();
//load
private void FrmOrderMNew_Load(object sender, EventArgs e)//load
{
DateTime now = DateTime.Now;
txt_StartDate2.Value = now.ToString("yyyy-MM-dd");
//打印参数
txt_printMs.Value = intNum;
ultraExpandableGroupBox1.Expanded = false;
ultraTabControl2.Tabs["change"].Visible = false;
//初始化
Init();
}
#region toolbar工具栏
///
/// toolbar菜单
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)// toolbar菜单
{
switch (ToolbarKey)
{
case "Query":
GetPUR_ORDER_M();
break;
case "Add":
AddPUR_ORDER_M();
break;
case "Update":
UpdPUR_ORDER_M();
break;
case "Delete":
DelPUR_ORDER_M();
break;
case "Submittal":
SubPUR_ORDER_M();
break;
case "Revocation":
RevPUR_ORDER_M("0");
break;
case "RevocationMaster"://已经审批合同撤回
RevPUR_ORDER_M("1");
break;
case "getReport":
getReportHT();
break;
case "getReportJY":
getReportJY();
break;
case "Process":
Process();
break;
case "OrderChange":
OrderChange();
break;
case "UltraGridToExcel":
UltraGridToExcel();
break;
case "FinishedAuditOutline"://一键审批（废除）
FinishedAuditOutline();
break;
case "maintainJhyItem"://批量维护检验项目（废除）
maintainJhyItem();
break;
case "FinishFile"://完成归档
finishFile();
break;
case "ChangeOrder"://合同拆分
ChangeOrder();
break;
case "CancelChangeOrder"://撤销合同拆分
CancelChangeOrder();
break;
case "doClose"://完成归档
this.Close();
break;
}
}
//合同拆分
private void ChangeOrder()
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("合同头编号为空！");
return;
}
FrmChangeOrder frm = new FrmChangeOrder(this.ob, strOrderId);
frm.ShowDialog();
if (frm.strTips == "1")
{
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
}
///
/// 合同变更申请
///
private void OrderChange()
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("合同头编号为空！");
return;
}
FrmOrderChange frm = new FrmOrderChange(this.ob, strOrderId);
frm.ShowDialog();
if (frm.strTips == "1")
{
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
}
///
/// 导出Excel
///
private void UltraGridToExcel()
{
try
{
ArrayList alUltraGrid = new ArrayList();
alUltraGrid.Add(ultraGrid1);
alUltraGrid.Add(ultraGrid2);
alUltraGrid.Add(ultraGrid3);
ArrayList alSheeft = new ArrayList();
alSheeft.Add("合同主表");
alSheeft.Add("合同行表");
alSheeft.Add("合同条款");
if (ultraGrid1.Rows.Count > 0)
{
GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "合同");//导出excel
}
//MessageUtil.ShowTips("导出成功");
}
catch (Exception e)
{
MessageUtil.ShowTips("导出失败" + e.Message);
}
finally
{
}
}
//完成归档
private void finishFile()
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (testOrderMStatus(strOrderId, 8) == false)
{
return;
}
if (MessageBox.Show("确认归档合同[" + strOrderId + "]？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
OrderM Omg = new OrderM();
Omg.OrderId = strOrderId;
Omg.Status = "4";
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "doUpdate", new object[] { Omg });
if (rt.Resultcode != 0)
{
MessageUtil.ShowTips("操作失败：" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("操作成功！");
GetPUR_ORDER_M();
}
//维护检验项目
private void maintainJhyItem()
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
frmMaintainJhy frm = new frmMaintainJhy(strOrderId, this.ob);
frm.ShowDialog();
}
private void FinishedAuditOutline()
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
OrderM Odm = new OrderM();
Odm.OrderId = strOrderId;
Odm.OperatorUserId = UserInfo.GetUserID();
if (testOrderMStatus(strOrderId, 7) == false)
{
return;
}
if (MessageBox.Show("确认该合同[" + strOrderId + "]线下已经完成审批？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "finishedAuditOutline", new object[] { Odm });
if (rt.Resultcode != 0)
{
MessageUtil.ShowTips("操作失败：" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("操作成功！");
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
///
/// 撤销提报
///
private void RevPUR_ORDER_M(String tips)// 撤销提报
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
//验证合同头是否可以撤销提报
if (tips == "0")
{
if (testOrderMStatus(strOrderId, 4) == false)
{
return;
}
}
else
{
if (testOrderMStatus(strOrderId, 41) == false)
{
return;
}
}
OrderM Odm = new OrderM();
Odm.OrderId = strOrderId;
Odm.Status = "1";
Odm.OperatorUserId = UserInfo.GetUserID();
Odm.DeleteName = tips;
if (MessageBox.Show("确定撤销提报合同【" + uge.Cells["OrderId"].Value.ToString() + "】？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm});
if (rt.Resultcode != 0)
{
MessageUtil.ShowTips("撤销提报失败：" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("操作成功！");
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
///
/// 提报
///
private void SubPUR_ORDER_M()// 提报
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
//验证合同头是否可以提报
if (testOrderMStatus(strOrderId,3) == false)
{
return;
}
OrderM Odm = new OrderM();
Odm.OrderId = strOrderId;
Odm.Status = "2";
Odm.OperatorUserId = UserInfo.GetUserID();
if (MessageBox.Show("确定提报合同【" + strOrderId + "】？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm });
if (rt.Resultcode != 0)
{
MessageUtil.ShowTips("提交失败：" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("提交成功！");
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
///
/// 撤销合同拆分
///
private void CancelChangeOrder()// 撤销
{
try
{
ArrayList changeD = new ArrayList();
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (!strOrderId.Contains("BG"))
{
MessageUtil.ShowTips("不是变更过的合同，不允许撤销!");
return;
}
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text)
{
//验证合同头是否可以删
if (testOrderMStatus(strOrderId, 2) == false)
{
return;
}
OrderM Odm = new OrderM();
Odm.Validflag = "0";
Odm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
Odm.DeleteUserid = CoreUserInfo.UserInfo.GetUserID();
Odm.DeleteTime = DateTime.Now;
Odm.OrderId = strOrderId;
foreach (UltraGridRow urg in ultraGrid9.Rows)
{
OrderChangeD change = new OrderChangeD();
change.Validflag = "1";
change.OrderLineSqe = urg.Cells["ORDERLINESQE"].Text.ToString().Trim();
changeD.Add(change);
}
OrderC orderc = new OrderC();
orderc.OrderId = strOrderId;
orderc.Validflag = "1";
int count = this.execute("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { orderc });
if (count > 0)
{
if (MessageUtil.ShowYesNoAndQuestion("合同:" + strOrderId + "存在" + count + "条有效的合同行,确定一起删除？") != DialogResult.Yes)
{
return;
}
}
else
{
if (strOrderId.EndsWith("BG"))
{
if (MessageBox.Show("确定取消（删除）合同：" + strOrderId + "的变更申请？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
}
else
{
if (MessageBox.Show("确定删除合同：" + strOrderId + "？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
}
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "cancelOrderM1", new object[] { Odm,changeD });
if (rt.Resultcode != 0)
{
Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败！" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功！");
GetPUR_ORDER_M();
}
if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
{
UltraGridRow uRe = ultraGrid2.ActiveRow;
if (uRe == null)
{
MessageUtil.ShowTips("请选择需要操作的合同行！");
return;
}
String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderLineSqe))
{
MessageUtil.ShowTips("数据异常，该合同行无合同行号！");
return;
}
if (testOrderCStatus(strOrderLineSqe, 1) == false)
{
return;
}
OrderC odC = new OrderC();
odC.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
odC.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
odC.DeleteTime = DateTime.Now;
odC.Validflag = "0";
odC.OrderLineSqe = strOrderLineSqe;
if (MessageBox.Show("确定删除合同行：" + strOrderLineSqe + "？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, strOrderId });
if (rt.Resultcode != 0)
{
Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败！" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功！");
GetPUR_ORDER_M();
ConfigureClassCommon.doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, odC.OrderLineSqe);
}
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
{
UltraGridRow rowclause = ultraGrid3.ActiveRow;
if (rowclause == null)
{
MessageUtil.ShowTips("请选择合同条款行！");
return;
}
String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strClauseID))
{
MessageUtil.ShowTips("该合同条款编号为空！");
return;
}
//验证合同头是否可以增删改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
OrderCClause clause = new OrderCClause();
clause.Id = strClauseID;
clause.OrderId = strOrderId;
clause.Validflag = "0";
clause.DeleteName = UserInfo.GetUserName();
clause.DeleteTime = DateTime.Now;
clause.DeleteUserid = UserInfo.GetUserID();
if (MessageUtil.ShowYesNoAndQuestion("确定删除合同条款：" + strClauseID + "?") != DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderCClauseService", "doDelete_clause", new object[] { clause });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("删除失败！" + crt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功!");
getOrderClause(strOrderId, "");
}
if (ultraTabControl2.SelectedTab == ultraTabControl2.Tabs[4])
{
UltraGridRow rowAppend = ultraGrid4.ActiveRow;
if (rowAppend == null)
{
MessageUtil.ShowTips("请选择需删除的附件！");
return;
}
String strAppendID = rowAppend.Cells["ID"].Value.ToString().Trim();
String strcertPath = rowAppend.Cells["CERTPATH"].Value.ToString().Trim();
String strCertPathOld = rowAppend.Cells["CERTPATHOLD"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strAppendID))
{
MessageUtil.ShowTips("该合同附件编号为空！");
return;
}
if (String.IsNullOrEmpty(strCertPathOld))
{
MessageUtil.ShowTips("未获取到合同附件地址信息！");
return;
}
//验证合同头是否可以增删改
if (testOrderAppendStatus(strAppendID, 1) == false)
{
return;
}
OrderAppend append = new OrderAppend();
append.Id = strAppendID;
append.Validflag = "0";
append.DeleteName = UserInfo.GetUserName();
append.DeleteTime = DateTime.Now;
append.DeleteUserid = UserInfo.GetUserID();
if (MessageUtil.ShowYesNoAndQuestion("确定删除合同附件：" + strcertPath + "?") != DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderAppendService", "delete_append", new object[] { append });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("删除失败！" + crt.Resultmsg);
return;
}
else
{
bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Delete(strCertPathOld);
if (isSuccess)
{
MessageUtil.ShowTips("删除成功");
}
else
{
MessageBox.Show("删除成功");
}
}
getOrderAppend(strOrderId, "");
}
}
catch (Exception e)
{
MessageUtil.ShowTips("操作失败！ " + e);
return;
}
}
///
/// 删除
///
private void DelPUR_ORDER_M()// 删除
{
try
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text)
{
//验证合同头是否可以删
if (testOrderMStatus(strOrderId, 2) == false)
{
return;
}
OrderM Odm = new OrderM();
Odm.Validflag = "0";
Odm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
Odm.DeleteUserid = CoreUserInfo.UserInfo.GetUserID();
Odm.DeleteTime = DateTime.Now;
Odm.OrderId = strOrderId;
OrderC orderc = new OrderC();
orderc.OrderId = strOrderId;
orderc.Validflag = "1";
int count = this.execute("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { orderc });
if (count > 0)
{
if (MessageUtil.ShowYesNoAndQuestion("合同:" + strOrderId + "存在" + count + "条有效的合同行,确定一起删除？") != DialogResult.Yes)
{
return;
}
}
else
{
if (strOrderId.EndsWith("BG"))
{
if (MessageBox.Show("确定取消（删除）合同：" + strOrderId + "的变更申请？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
}
else
{
if (MessageBox.Show("确定删除合同：" + strOrderId + "？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
}
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "cancelOrderM", new object[] { Odm });
if (rt.Resultcode != 0)
{
Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败！" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功！");
GetPUR_ORDER_M();
}
if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
{
UltraGridRow uRe = ultraGrid2.ActiveRow;
if (uRe == null)
{
MessageUtil.ShowTips("请选择需要操作的合同行！");
return;
}
String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderLineSqe))
{
MessageUtil.ShowTips("数据异常，该合同行无合同行号！");
return;
}
if (testOrderCStatus(strOrderLineSqe, 1) == false)
{
return;
}
OrderC odC = new OrderC();
odC.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
odC.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
odC.DeleteTime = DateTime.Now;
odC.Validflag = "0";
odC.OrderLineSqe = strOrderLineSqe;
if (MessageBox.Show("确定删除合同行：" + strOrderLineSqe + "？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, strOrderId });
if (rt.Resultcode != 0)
{
Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败！" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功！");
GetPUR_ORDER_M();
ConfigureClassCommon.doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, odC.OrderLineSqe);
}
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
{
UltraGridRow rowclause = ultraGrid3.ActiveRow;
if (rowclause == null)
{
MessageUtil.ShowTips("请选择合同条款行！");
return;
}
String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strClauseID))
{
MessageUtil.ShowTips("该合同条款编号为空！");
return;
}
//验证合同头是否可以增删改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
OrderCClause clause = new OrderCClause();
clause.Id = strClauseID;
clause.OrderId = strOrderId;
clause.Validflag = "0";
clause.DeleteName = UserInfo.GetUserName();
clause.DeleteTime = DateTime.Now;
clause.DeleteUserid = UserInfo.GetUserID();
if (MessageUtil.ShowYesNoAndQuestion("确定删除合同条款：" + strClauseID + "?")!=DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderCClauseService", "doDelete_clause", new object[] { clause });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("删除失败！" + crt.Resultmsg);
return;
}
MessageUtil.ShowTips("删除成功!");
getOrderClause(strOrderId, "");
}
if (ultraTabControl2.SelectedTab== ultraTabControl2.Tabs[4])
{
UltraGridRow rowAppend = ultraGrid4.ActiveRow;
if (rowAppend == null)
{
MessageUtil.ShowTips("请选择需删除的附件！");
return;
}
String strAppendID = rowAppend.Cells["ID"].Value.ToString().Trim();
String strcertPath = rowAppend.Cells["CERTPATH"].Value.ToString().Trim();
String strCertPathOld = rowAppend.Cells["CERTPATHOLD"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strAppendID))
{
MessageUtil.ShowTips("该合同附件编号为空！");
return;
}
if (String.IsNullOrEmpty(strCertPathOld))
{
MessageUtil.ShowTips("未获取到合同附件地址信息！");
return;
}
//验证合同头是否可以增删改
if (testOrderAppendStatus(strAppendID, 1) == false)
{
return;
}
OrderAppend append = new OrderAppend();
append.Id = strAppendID;
append.Validflag = "0";
append.DeleteName = UserInfo.GetUserName();
append.DeleteTime = DateTime.Now;
append.DeleteUserid = UserInfo.GetUserID();
if (MessageUtil.ShowYesNoAndQuestion("确定删除合同附件：" + strcertPath + "?") != DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderAppendService", "delete_append", new object[] { append });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("删除失败！" + crt.Resultmsg);
return;
}
else
{
bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Delete(strCertPathOld);
if (isSuccess)
{
MessageUtil.ShowTips("删除成功");
}
else
{
MessageBox.Show("删除成功");
}
}
getOrderAppend(strOrderId,"");
}
}
catch (Exception e)
{
MessageUtil.ShowTips("操作失败！ " + e);
return;
}
}
///
/// 修改
///
private void UpdPUR_ORDER_M()// 修改
{
try
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
if (strOrderId.EndsWith("BG"))
{
MessageUtil.ShowTips("变更的临时审批合同不允许修改");
return;
}
if(String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
{
//验证合同头是否可以改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
//验证合同头输入数据的有效信息
if (testOrderM() == false)
{
return;
}
OrderM Odm = new OrderM();
Odm.Currency = txt_Currency.Value == null ? "" : txt_Currency.Value.ToString().Trim();
Odm.OrderType = txt_OrderType.Value.ToString().Trim();//合同类别
Odm.OrderClass = txt_OrderClass.Value.ToString().Trim();//合同分类
Odm.ExchangeRateCur = (txt_ExchangeRateCur.Value == null ? 0 : Convert.ToDouble(txt_ExchangeRateCur.Text));
Odm.OrderId = strOrderId;
Odm.OrderMoneyType = txt_OrderMoneyType.Value == null ? null : txt_OrderMoneyType.Value.ToString().Trim();
Odm.SignDate = Convert.ToDateTime(txt_SignDate.Value);//签订日期
Odm.SignAddress = txt_SignAddress.Text;
Odm.UpdateName = CoreUserInfo.UserInfo.GetUserName();
Odm.UpdateUserid = CoreUserInfo.UserInfo.GetUserID();
Odm.UpdateTime = DateTime.Now;
Odm.DeliveryCondition = txt_deliveryCondition.Value.ToString().Trim();//运输条件
Odm.DeliveryType = txt_deliveryType.Value.ToString().ToString().Trim();//运输方式
Odm.BuyerName = txt_buy_name.Text.Trim();
Odm.OrderForm = combo_order_type.Text.Trim();
if (MessageBox.Show("确定修改合同头[" + strOrderId + "]？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt = this.execute("com.hnshituo.pur.order.service.OrderMService", "doUpdate", new object[] { Odm });
if (rt.Resultcode != 0)
{
Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败！" + rt.Resultmsg);
return;
}
MessageUtil.ShowTips("操作成功!");
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "orderId", strOrderId);
getOrderC(strOrderId, "");
}
if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
{
//验证合同头是否可以删改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
if (testOrderC() == false)
{
return;
}
UltraGridRow uRe = ultraGrid2.ActiveRow;
if (uRe == null)
{
MessageUtil.ShowTips("请选择合同行！");
return;
}
String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderLineSqe))
{
MessageUtil.ShowTips("该合同行编号为空！");
return;
}
OrderC odC = new OrderC();
//odC.OrderId = strOrderId;
odC.OrderLineSqe = strOrderLineSqe;
odC.ReceiveType = txt_ReceiveType.Value.ToString();
if (txt_StartDate2.Text != "")
{
odC.StartDate = Convert.ToDateTime(txt_StartDate2.Value);
}
odC.EndDate = Convert.ToDateTime(txt_EndDate2.Value);//交货结束时间
odC.UpdateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
odC.UpdateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
odC.UpdateTime = DateTime.Now;
odC.Remark = txt_Remark.Text.ToString().Trim();
odC.PackageType = txt_packType.SelectedIndex==-1?null:txt_packType.Value.ToString().Trim();//包装方式
odC.PaymentCode = txt_paymentType.SelectedIndex == -1? null : txt_paymentType.Value.ToString().Trim();//付款方式
odC.ItemStandardsId = txt_matStand.SelectedIndex == -1 ? "" : txt_matStand.Value.ToString().Trim();
odC.ItemStandardsCode = txt_matStand.SelectedIndex == -1 ? "" : txt_matStand.Text.ToString().Trim();
odC.ConvertCount = uRe.Cells["ConvertCount"].Text.ToString().Replace("_", "").Trim(); // 折算数量
odC.ConvertPrice = uRe.Cells["ConvertPrice"].Value.ToString().Trim(); // 含税折算单价
odC.ConvertPriceTax = uRe.Cells["ConvertPriceTax"].Value.ToString().Trim(); // 不含税折算单价
if (txt_BalanceClauseType.SelectedIndex == 0 || txt_BalanceClauseType.SelectedIndex == 1)
{
odC.BasePriceType = txt_BalanceClauseType.Value.ToString().Trim();
odC.BasePriceName = "";
odC.BasePriceNo = "";
}
else if (txt_BalanceClauseType.SelectedIndex == 2)
{
odC.BasePriceType = txt_BalanceClauseType.Value.ToString().Trim();
if (String.IsNullOrEmpty(txt_balanceClause.Text.Trim()) || String.IsNullOrEmpty(init_balance_Id))
{
MessageUtil.ShowTips("请选择价格政策");
return;
}
odC.BasePriceName = txt_balanceClause.Text;
odC.BasePriceNo = init_balance_Id;
}
else
{
MessageUtil.ShowTips("请选择价格政策类型");
return;
}
if (MessageBox.Show("确定修改合同行[" + odC.OrderLineSqe + "]？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
CoreResult rt2 = this.execute("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, uge.Cells["OrderId"].Value.ToString() });
if (rt2.Resultcode != 0)
{
MessageUtil.ShowTips("操作失败!" + rt2.Resultmsg);
return;
}
MessageUtil.ShowTips("修改成功!");
GetPUR_ORDER_M();
doActiveSelRow(ultraGrid1, "OrderId", strOrderId);
getOrderC(strOrderId, odC.OrderLineSqe);
}
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
{
UltraGridRow rowclause = ultraGrid3.ActiveRow;
if (rowclause == null)
{
MessageUtil.ShowTips("请选择合同条款行！");
return;
}
String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strClauseID))
{
MessageUtil.ShowTips("该合同条款编号为空！");
return;
}
//验证合同头是否可以增删改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
//验证填写数据的有效性
if (testOrderClause() == false)
{
return;
}
OrderCClause clause = new OrderCClause();
clause.ClauseDesc = txt_ClauseDesc.Text.Trim();
clause.ClauseName = txt_ClauseName.Text.Trim();
clause.ClauseIndx = txt_ClauseIndx1.Text.Trim();
clause.ClauseIndxIn = txt_ClauseIndx2.Value.ToString().Trim();
clause.ClauseType = txt_ClauseType.Value.ToString().Trim();
clause.BcmId = init_bcm_Id;
clause.BcmName = txt_Bcm_Name.Text.Trim();
clause.OrderId = strOrderId;
clause.UpdateTime = DateTime.Now;
clause.UpdateUserid = UserInfo.GetUserID();
clause.UpdateName = UserInfo.GetUserName();
clause.Id = strClauseID;
if (MessageUtil.ShowYesNoAndQuestion("确定修改合同条款：" + strClauseID + "?") != DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderCClauseService", "doUpdate_Clause", new object[] { clause });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("修改失败！" + crt.Resultmsg);
return;
}
MessageUtil.ShowTips("修改成功!");
getOrderClause(strOrderId, strClauseID);
}
}
catch (Exception e)
{
MessageUtil.ShowTips("修改失败! " + e);
return;
}
finally
{
}
}
///
/// 查询
///
private void GetPUR_ORDER_M()// 查询
{
try
{
this.Cursor = Cursors.WaitCursor;
ClearTab1();//清空合同头编辑区
ClearTab2();//清楚合同行编辑区
ClearTab4();//清除纪要
change.Clear();
dataSet1.Clear();
dataSet2.Clear();
dataSet3.Clear();
dataSet4.Clear();
dataSet5.Clear();
message.Clear();
OrderM Odm = new OrderM();
Odm.Status = COPStatus.Value == null ? null : COPStatus.Value.ToString().Trim();
Odm.OrderType = COP_OrderType.Value == null ? null : COP_OrderType.Value.ToString().Trim();
if(CK_Ctime.Checked==true)
{
if (txt_createTimeStart.Text != "")
{
Odm.CreateTime = Convert.ToDateTime(txt_createTimeStart.Value);
}
if (txt_createTimeEnd.Text != "")
{
Odm.UpdateTime = Convert.ToDateTime(txt_createTimeEnd.Value);
}
}
Odm.OrderId = COP_OrderId.Text;
Odm.SuppName = COP_SuppName.Text;
Odm.Validflag = "1";
Odm.ValidDataPurviewIds = this.ValidDataPurviewIds;
Odm.BpmUserId = UserInfo.GetUserID();
string strDataFlag = this.execute("com.hnshituo.pur.utils.service.UtilsService", "getRoleDataFlag", new object[] { UserInfo.GetUserID(), "Pur.order.FrmOrderMNew" });
//if (strDataFlag == "0")
//{
// Odm.CreateUserid = this.UserInfo.GetUserID();
//}
DataTable dt = this.execute("com.hnshituo.pur.order.service.OrderMService", "find_OrderM", new object[] { Odm, 0, 0 });
GridHelper.CopyDataToDatatable(dt, dataTable1, true);
GridHelper.RefreshAndAutoSize(ultraGrid1);
}
catch (Exception ex)
{
MessageUtil.ShowTips("查询合同头数据失败：" + ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
///
/// 新增
///
private void AddPUR_ORDER_M()// 新增
{
try
{
if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString();
if (strOrderId == "")
{
MessageUtil.ShowTips("合同头编号不能为空！");
return;
}
//验证合同头是否可以增删改
if (testOrderMStatus(strOrderId, 1) == false)
{
return;
}
//验证填写数据的有效性
if (testOrderClause() == false)
{
return;
}
OrderCClause clause = new OrderCClause();
clause.ClauseDesc = txt_ClauseDesc.Text.Trim();
clause.ClauseName = txt_ClauseName.Text.Trim();
clause.ClauseIndx = txt_ClauseIndx1.Text.Trim();
clause.ClauseIndxIn = txt_ClauseIndx2.Value.ToString().Trim();
clause.ClauseType = txt_ClauseType.Value.ToString().Trim();
clause.BcmId = init_bcm_Id;
clause.BcmName = txt_Bcm_Name.Text.Trim();
clause.OrderId = strOrderId;
clause.CreateTime = DateTime.Now;
clause.CreateUserid = UserInfo.GetUserID();
clause.CreateName = UserInfo.GetUserName();
clause.Validflag = "1";
CoreResult crt = this.execute("com.hnshituo.pur.order.service.OrderCClauseService", "insert_Clause", new object[] { clause });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("新增失败！" + crt.Resultmsg);
return;
}
MessageUtil.ShowTips("新增成功!");
getOrderClause(strOrderId, crt.Resultmsg);
}
else
{
MessageUtil.ShowTips("暂无权限");
return;
}
}
catch (Exception e)
{
MessageUtil.ShowWarning("新增失败" + e);
return;
}
}
///
/// 打印预览
///
private void getReportHT()//打印合同
{
try
{
this.Cursor = Cursors.WaitCursor;
UltraGridRow ugr = ultraGrid1.ActiveRow;
if (ugr == null)
{
MessageUtil.ShowWarning("请选择您要查看的合同！");
return;
}
//string ordLnPk = ugr.Cells["ORD_LN_PK"].Value.ToString();
//string saleOrg = ugr.Cells["SALE_ORG"].Value.ToString();
//string ordPk = ugr.Cells["ORD_PK"].Value.ToString();
string orderNo = ugr.Cells["OrderId"].Value.ToString();
if (String.IsNullOrEmpty(orderNo))
{
MessageUtil.ShowWarning("请选择合同的合同编号为空！");
return;
}
OrderM Omg = this.execute("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { orderNo });
if (Omg==null)
{
MessageUtil.ShowWarning("未发现合同：" + orderNo+"信息记录");
return;
}
if (String.IsNullOrEmpty(Omg.ModeId))
{
MessageUtil.ShowWarning("合同：" + orderNo + "未绑定合同模板导致无法按照模板输出");
return;
}
OrderModeM omm = this.execute("com.hnshituo.pur.order.service.OrderModeMService", "findById", new object[] { Omg.ModeId });
OrderM om=new OrderM();
om.OrderId=orderNo;
om.Validflag="1";
int count = this.execute("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { om });
string strurl = "";
DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
DataRow[] drArr = dt.Select("validflag='1'");
if (drArr.Length != 1)
{
MessageUtil.ShowTips("基础数据维护错误：报表系统需维护有效的Ip且只能维护一个有效ip！");
return;
}
String TipsEnv = drArr[0]["baseName"].ToString();
//String TipsNum=drArr[0]["memo1"].ToString();
//double.TryParse(txt_printMs.Value,out );
//if(!StringUtil.IsInt(TipsNum))
//{
// MessageUtil.ShowTips("基础数据维护错误：报表系统需维护有效物料显示数量！");
// return;
//}
int.TryParse(txt_printMs.Value.ToString(),out intNum);
String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
//String strUrlPort = "http://localhost:8075";//报表系统IP
String[] str = strUrlPort.Split(':');
String strUrl = str[0] + ":" + str[1];
String orgName = "1";
if (ugr.Cells["BuyerDeptCode"].Text.Trim().Contains("002001029"))
orgName = "1";
else
orgName = "2";
if (ob.MainUrl.StartsWith(strUrl))//
{
//测试环境
if (TipsEnv == "2")
{
if (Omg.OrderType == "120024")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
}
else
{
if (omm.OrderClass == "122002")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
}
else
{
if (count <= intNum)
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
}
}
}
}
else
{
if (ultraGrid8.Rows.Count == 0)
{
if (count <= intNum)
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMulti.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName +"&ACOUNT=" + utAccount.Text.Trim();
}
}
else
{
if (count <= intNum)
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderChange.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiChange.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
}
}
}
}
else
{
if (Omg.OrderType == "120024")
{
//strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + orderNo;
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder_GT.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" +utAccount.Text.Trim()+")";
}
else
{
if (omm.OrderClass == "122002")
{
//strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + orderNo;
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMM.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" + utAccount.Text.Trim() + ")";
}
else
{
if (count <= intNum)
{
//strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo;
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" + utAccount.Text.Trim() + ")";
}
else
{
//strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiDev.cpt&op=view" + "&cmbOrder=" + orderNo;
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMulti.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" +utAccount.Text.Trim()+")";
}
}
}
}
//if (ob.MainUrl.StartsWith("http://127.0.0.1"))
//{
// strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo;
//}
//else
//{
// strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo;
//}
FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
fBug.AutoSize = true;
fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
fBug.WindowState = FormWindowState.Maximized;
fBug.Text = "TPCO合同查询";
fBug.Show();
}
finally
{
this.Cursor = Cursors.Default;
}
}
///
/// 打印预览
///
private void getReportJY()//打印纪要
{
try
{
this.Cursor = Cursors.WaitCursor;
UltraGridRow ugr = ultraGrid1.ActiveRow;
if (ugr == null)
{
MessageUtil.ShowWarning("请选择您要查看采购纪要的合同头！");
return;
}
string strRecordId = ugr.Cells["TaskRecordId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strRecordId))
{
MessageUtil.ShowTips("采购纪要号为空，可能未生成采购纪要！");
txt_TaskRecordId.Focus();
return;
}
PurTaskRecordEntity taskRecord = this.execute("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strRecordId });
if (taskRecord == null)
{
MessageUtil.ShowTips("未发现纪要：" + strRecordId + "信息记录，可能已被作废！或请刷新界面重新操作！");
return;
}
if (taskRecord.Validflag == "0")
{
MessageUtil.ShowTips("纪要：" + strRecordId + "信息记录可能已被作废！或请刷新界面重新操作！");
return;
}
String RecordType = taskRecord.Type;
string strurl = "";
DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
DataRow[] drArr = dt.Select("validflag='1'");
if (drArr.Length != 1)
{
MessageUtil.ShowTips("基础数据维护错误：报表系统需维护有效的Ip且只能维护一个有效ip！");
return;
}
String TipsEnv = drArr[0]["baseName"].ToString();
String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
String[] str = strUrlPort.Split(':');
String strUrl = str[0] + ":" + str[1];
if (ob.MainUrl.StartsWith(strUrl))
{
if (RecordType == "1")//价格
{
//测试环境
if (TipsEnv == "2")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
}
else
{
//测试环境
if (TipsEnv == "2")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
}
}
else
{
if (RecordType == "1")//价格
{
//测试环境
if (TipsEnv == "2")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
}
else
{
//测试环境
if (TipsEnv == "2")
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
else
{
strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
}
}
}
//if (ob.MainUrl.StartsWith("http://127.0.0.1"))
//{
// strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
//}
//else
//{
// strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
//}
FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
fBug.AutoSize = true;
fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
fBug.WindowState = FormWindowState.Maximized;
fBug.Text = "TPCO采购纪要查询";
fBug.Show();
}
finally
{
this.Cursor = Cursors.Default;
}
}
#endregion
#region 界面事件
///
/// 点击表格 tab1页跳转事件
///
///
///
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
try
{
ClearTab1();
ClearTab2();
ClearTab3();
ClearTab4();
dataTable2.Clear();
dataTable3.Clear();
dataTable5.Clear();
dataTable4.Clear();
dataSet5.Clear();
message.Clear();
UltraGridRow uge = ultraGrid1.ActiveRow;
currencylabel1.Text = uge.GetCellValue("Currency").ToString().ToString();
currencylabel4.Text = uge.GetCellValue("Currency").ToString().ToString();
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
//加载编辑区数据
OrderM Omg = this.execute("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
txt_OrderType.Value = Omg.OrderType == null ? null : Omg.OrderType.ToString();//合同类别
txt_OrderClass.Value = Omg.OrderClass == null ? null : Omg.OrderClass.ToString().Trim();//合同分类
txt_Currency.Value = Omg.Currency == null ? null : Omg.Currency.ToString();//合同货币代码
txt_deliveryCondition.Value = Omg.DeliveryCondition == null ? "" : Omg.DeliveryCondition.ToString().Trim();//运输条件
txt_deliveryType.Value = Omg.DeliveryType == null ? "" : Omg.DeliveryType.ToString().Trim();//运输条件
txt_OrderMoneyType.Value = Omg.OrderMoneyType == null ? null : Omg.OrderMoneyType.ToString().Trim();//合同金额类别
txt_SignAddress.Text = Omg.SignAddress == null ? null : Omg.SignAddress.ToString();//签订地点
if (!String.IsNullOrEmpty(Omg.OrderTitleCode))
{
Title title = this.execute("com.hnshituo.pur.configure.service.TitleService", "findById", new object[] { Omg.OrderTitleCode });
if (title != null)
{
txt_TitleName.Text = title.TitleName;//合同抬头名称
}
}
txt_CreateTime.Value = Omg.CreateTime;//创建时间
txt_SignDate.Value = Omg.SignDate == null ? null : Omg.SignDate;//签订日期
txt_ModeName.Text = Omg.ModeName == null ? null : Omg.ModeName.ToString();//模板名称
txt_OrderId.Text = Omg.OrderId == null ? null : Omg.OrderId.ToString();//合同号
txt_TaskRecordId.Text = Omg.TaskRecordId;
txt_AftPaymentAmt1.Value = Omg.AftPaymentAmt1;//尾款1
txt_buy_name.Text = Omg.BuyerName;
//加载从表数据
getOrderC(strOrderId, "");
//加载条款数据
getOrderClause(strOrderId,"");
//加载采购纪要数据
string strTaskRecordId = Omg.TaskRecordId;
if (!String.IsNullOrEmpty(strTaskRecordId))
{
getTaskRecord(strTaskRecordId);
}
getOrderAppend(strOrderId, "");
//加载评审意见
getOrderReview(strOrderId);
//加载变更记录
getOrderChangeRecord(strOrderId);
UltraGridRow urg = ultraGrid1.ActiveRow;
if(urg!=null)
{
suppName = urg.Cells["SuppName"].Text.ToString();
}
}
catch (Exception ex)
{
MessageUtil.ShowTips("加载合同行和条款数据失败：" + ex);
}
}
private void ultraGrid1_Click(object sender, EventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
}
/// <summary>
/// 点击表格 tab2页跳转事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
dataSet5.Clear();
ClearTab2();
UltraGridRow uge1 = ultraGrid1.ActiveRow;
currencyLabel66.Text = uge1.GetCellValue("Currency").ToString().ToString();
UltraGridRow uge = ultraGrid2.ActiveRow;
String strOrderLineSqe = uge.Cells["OrderLineSqe"].Value.ToString();
if (String.IsNullOrEmpty(strOrderLineSqe))
{
MessageUtil.ShowTips("合同行号为空");
return;
}
//加载物料信息
OrderC Odc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
PurMatStandardsEntity stand = new PurMatStandardsEntity();
stand.ItemCode = Odc.ItemCode;
stand.Validflag = "1";
DataTable dt3 = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatStandardsService", "find", new object[] { stand,0,0});
PublicTools.publicPms.FilComboboxAdd(txt_matStand, dt3, "itemStandardsId", "standardsCode", "", true, "/", "");
txt_matStand.Value = Odc.ItemStandardsId;
txt_ReceiveType.Value = Odc.ReceiveType == null ? null : Odc.ReceiveType.ToString().Trim();//入库类型
txt_packType.Value = Odc.PackageType == null ? "" : Odc.PackageType.ToString().Trim();//包装方式
txt_paymentType.Value = Odc.PaymentCode == null ? null : Odc.PaymentCode.ToString().Trim();//付款方式
txt_ChemPriceNo.Text = Odc.ChemPriceNo == null ? null : Odc.ChemPriceNo.ToString();//成分计价标准编号
txt_EndDate2.Value = Odc.EndDate;//结束交期
txt_StartDate2.Value = Odc.StartDate;//开始交期
txt_Remark.Text = Odc.Remark;
txt_BalanceClauseType.Value = Odc.BasePriceType;
txt_balanceClause.Value = Odc.BasePriceName;
init_balance_Id = Odc.BasePriceNo;
//加载检验项目从表
if (!String.IsNullOrEmpty(Odc.ItemCode) && !String.IsNullOrEmpty(Odc.ItemStandardsId))
{
//加载可选的标准信息
MatStdBaseinfo basei = new MatStdBaseinfo();
basei.ItemCode = Odc.ItemCode;
basei.Validflag = "1";
DataTable dtStad = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatStdBaseinfo_jhyService", "find", new object[] { basei, 0, 0 });
comm.FilComboboxAdd(cb_standardsCode, dtStad, "mic", "standardsCode", "validflag NOT in ('0')", true, "全部", "");
//加载合同默认检验标准信息
getStdDetail(strOrderLineSqe);
}
GridHelper.RefreshAndAutoSize(ultraGrid5);
}
/// <summary>
/// 加载检验项目
/// </summary>
/// <param name="strOrderLineSqe"></param>
private void getStdDetail(String strOrderLineSqe)
{
OrderCStdDetail detailstd = new OrderCStdDetail();
detailstd.OrderLineSqe = strOrderLineSqe;
detailstd.Validflag = "1";
DataTable list_detail = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCStdDetailService", "find", new object[] { detailstd, 0, 0 });
GridHelper.CopyDataToDatatable(list_detail, dataTable11, true);
OrderCStdBaseinfo baseInfo = new OrderCStdBaseinfo();
baseInfo.OrderLineSqe = strOrderLineSqe;
baseInfo.Validflag = "1";
List<OrderCStdBaseinfo> list_baseInfo = this.execute<List<OrderCStdBaseinfo>>("com.hnshituo.pur.order.service.OrderCStdBaseinfoService", "find", new object[] { baseInfo, 0, 0 });
if (list_baseInfo != null && list_baseInfo.Count > 0)
{
cb_standardsCode.Text = list_baseInfo[0].StandardsCode;
}
}
private void ultraGrid2_Click(object sender, EventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
}
private void ultraGrid3_ClickCell(object sender, ClickCellEventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
ClearTab3();
UltraGridRow row =e.Cell.Row;
String strId = row.GetCellValue("ID").ToString().Trim();
OrderCClause clauseC = this.execute<OrderCClause>("com.hnshituo.pur.order.service.OrderCClauseService", "findById", new object[] { strId });
txt_Clauseid.Text = strId;
txt_ClauseIndx1.Text = clauseC.ClauseIndx;//打印顺序1
txt_ClauseIndx2.Value =clauseC.ClauseIndxIn;//打印顺序2
txt_ClauseName.Text = clauseC.ClauseName;
txt_ClauseOldId.Text =clauseC.ClauseIdOld;
txt_ClauseType.Value =clauseC.ClauseType;
txt_ClauseDesc.Text =clauseC.ClauseDesc;
txt_Bcm_Name.Text = clauseC.BcmName==null?"":clauseC.BcmName;
init_bcm_Id = clauseC.BcmId==null?"": clauseC.BcmId;
}
private void ultraGrid3_Click(object sender, EventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
}
private void ultraGrid4_Click(object sender, EventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[3];
}
private void ultraGrid4_ClickCell(object sender, ClickCellEventArgs e)
{
this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[3];
}
/// <summary>
/// 合同模板弹窗
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_ModeName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
String strOrderType = txt_OrderType.SelectedIndex == -1 ? "" : txt_OrderType.Value.ToString().Trim();
FrmPop_upOrderMode Pop = new FrmPop_upOrderMode(this.ob, strOrderType);
Pop.ShowDialog();
if (Pop.ModeId == null)
return;
txt_ModeName.Text = Pop.ModeName.ToString();
}
/// <summary>
/// 抬头弹窗
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_TitleName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
FrmPop_upTitle Pot = new FrmPop_upTitle(this.ob);
Pot.ShowDialog();
if (Pot.Id == null)
return;
txt_TitleName.Text = Pot.TitleName;
}
/// <summary>
/// 合同货币类型选择-界面上货币名称变化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_Currency_ValueChanged(object sender, EventArgs e)
{
currencylabel1.Text = txt_Currency.Text;
currencylabel4.Text = txt_Currency.Text;
currencyLabel66.Text = txt_Currency.Text;
}
/// <summary>
/// 创建时间查询控制
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CK_Ctime_CheckedChanged(object sender, EventArgs e)// 创建时间查询控制
{
if (CK_Ctime.Checked == false)
{
txt_createTimeEnd.Enabled = false;
txt_createTimeStart.Enabled = false;
}
else
{
txt_createTimeEnd.Enabled = true;
txt_createTimeStart.Enabled = true;
}
}
/// <summary>
/// 条款选择
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_ClauseOldId_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
String strtype = txt_OrderType.SelectedIndex == -1 ? "" : txt_OrderType.Value.ToString().Trim();
FrmClauseInMode Fcinm = new FrmClauseInMode(this.ob, strtype);
Fcinm.ShowDialog();
if (Fcinm.getClauseId() == null)
return;
ClearTab3();
txt_ClauseDesc.Text = Fcinm.getClauseDesc().ToString();
txt_ClauseOldId.Text = Fcinm.getClauseId().ToString();
txt_ClauseName.Text = Fcinm.getClauseName().ToString();
txt_ClauseIndx1.Text = Fcinm.getClauseOrderBy().ToString();
txt_ClauseType.Value = Fcinm.getClauseType().ToString();
}
/// <summary>
/// 价格政策选择
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_balanceClause_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
FrmFGPriceMainTain frm = new FrmFGPriceMainTain(this.ob);
frm.ShowDialog();
if (frm.tips == "1")
{
txt_balanceClause.Text = frm.strPriceName;
this.init_balance_Id = frm.strPriceId;
}
}
/// <summary>
/// 新增按钮控制
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)// 新增按钮控制
{
if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[2])
{
this.ToolBarItemEnable(this, "Add", true);
}
else
{
this.ToolBarItemEnable(this, "Add", false);
}
}
private void FrmOrderMNew_Shown(object sender, EventArgs e)
{
this.ToolBarItemEnable(this, "Add", false);
}
private void ultraGrid8_AfterRowActivate(object sender, EventArgs e)
{
dataTable9.Clear();
txt_change_record.Clear();
String strChangeId = ultraGrid8.ActiveRow.GetCellValue("changeId").ToString();
txt_change_record.Text = ultraGrid8.ActiveRow.GetCellValue("CHANGERECORD").ToString().Replace("\n", "\r\n");
if (String.IsNullOrEmpty(strChangeId))
{
return;
}
OrderChangeD change = new OrderChangeD();
change.ChangeId = strChangeId;
change.Validflag = "1";
DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderChangeDService", "find", new object[] { change, 0, 0 });
GridHelper.CopyDataToDatatable(dt, dataTable9, true);
GridHelper.RefreshAndAutoSize(ultraGrid9);
}
/// <summary>
/// 条款类型变化---打印顺序1
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_ClauseType_ValueChanged(object sender, EventArgs e)
{
try
{
if (txt_ClauseType.SelectedIndex != -1)
{
string strBaseCode = txt_ClauseType.Value.ToString().Trim();
BaseInfo baseInfo = this.execute<BaseInfo>("com.hnshituo.pur.configure.service.BaseInfoService", "findById", new object[] { strBaseCode });
if (baseInfo != null)
{
if (String.IsNullOrEmpty(baseInfo.Memo.Trim()))
{
MessageUtil.ShowTips("未维护条款分类默认打印排序！请在基础数据表里维护！");
return;
}
txt_ClauseIndx1.Text = baseInfo.Memo;
}
}
}
catch (Exception ex)
{
MessageUtil.ShowTips(ex.Message);
txt_ClauseIndx1.Text = "";
}
}
/// <summary>
/// 选择结算条款
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_Bcm_Name_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
FrmFGPriceMainTain frm = new FrmFGPriceMainTain(this.ob);
frm.ShowDialog();
if (frm.tips == "1")
{
txt_Bcm_Name.Text = frm.strPriceName;
this.init_bcm_Id = frm.strPriceId;
}
}
/// <summary>
/// 价格政策
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txt_BalanceClauseType_SelectionChanged(object sender, EventArgs e)
{
if (txt_BalanceClauseType.SelectedIndex == 2)
{
txt_balanceClause.Enabled = true;
}
else
{
txt_balanceClause.Enabled = false;
}
}
#endregion
#region 初始化函数
/// <summary>
/// 选择和合同结算
/// </summary>
private void Init()
{
switch (this.CustomInfo.ToString().Trim())
{
case "@Confirma":
#region
ultraGrid1.DisplayLayout.Bands[0].Columns["Check"].Hidden = false;
ultraExpandableGroupBox2.Visible = false;
COPStatus.SelectedIndex = 3;
#endregion
break;
}
initDropDownList();
//合同状态默认全部
COPStatus.SelectedIndex = 0;
//头初始化
txt_SignDate.Value = DateTime.Now;//签订日期
txt_CreateTime.Value = DateTime.Now;//录入日期
txt_SignAddress.Text = "天津市";
//行初始化
txt_EndDate2.Value = DateTime.Now ;//送货结束日期
CK_Ctime.Checked = true;
txt_createTimeStart.Value = DateTime.Now.AddMonths(-2);
txt_createTimeEnd.Value = DateTime.Now.AddDays(7);
//加载数据
//GetPUR_ORDER_M();
//默认收起编辑区
ultraExpandableGroupBox2.Expanded = false;
//设置Grid不可编辑
SetColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { });
SetColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { "convertCount" });
SetColumnsActive(ultraGrid3.DisplayLayout.Bands[0], new string[] { });
SetColumnsActive(ultraGrid6.DisplayLayout.Bands[0], new string[] { });
SetColumnsActive(ultraGrid4.DisplayLayout.Bands[0], new string[] { "CERTPATH"});
GridHelper.SetExcludeColumnsActive(ultraGrid5.DisplayLayout.Bands[0], new string[] { "MATNAME","CHK", "STDMIN", "STDMINSIGN", "STDMAX", "STDMAXSIGN", "REMARK","JUDGETYPE" });
SetColumnsActive(ultraGrid8.DisplayLayout.Bands[0], new string[] { });
SetColumnsActive(ultraGrid9.DisplayLayout.Bands[0], new string[] { });
//加载附件查询控件
ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
ultraGrid5.DisplayLayout.Bands[0].Columns["STDMINSIGN"].EditorComponent = ultraComSignMin;//下限符号
ultraGrid5.DisplayLayout.Bands[0].Columns["STDMAXSIGN"].EditorComponent = ultraComSignMax;//上限符号
ultraGrid5.DisplayLayout.Bands[0].Columns["JUDGETYPE"].EditorComponent = ultraJUDGE_TYPE;//上限符号
ultraGrid5.DisplayLayout.Bands[0].Columns["MATNAME"].EditorComponent = ultraMAT_NAME;//上限符号
}
/// <summary>
/// 初始化DropDownList控件
/// </summary>
private void initDropDownList()// 初始化DropDownList控件
{
//价格政策
txt_BalanceClauseType.SelectedIndex = 0;
txt_balanceClause.Enabled = false;
//加载结算条款
//BalanceClauseM bm = new BalanceClauseM();
//bm.Validflag = "1";
//DataTable dt = this.execute<DataTable>("com.hnshituo.pur.balance.service.BalanceClauseMService", "doQueryClauseM", new object[] { bm });
//comm.FilComboboxAdd(txt_Pur_Clause, dt, "bcmId", "bcmName", null, true, "/", "");
//合同类别
DataTable dt1 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1200" }, this.ob);
comm.FilComboboxAdd(COP_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", true, "全部", "");
COP_OrderType.SelectedIndex = 0;
comm.FilComboboxAdd(txt_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
//合同分类
DataTable dt3 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1220" }, this.ob);
comm.FilComboboxAdd(txt_OrderClass, dt3, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
//货币代码
//throw new NotImplementedException();
DataTable dt4 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1001" }, this.ob);
comm.FilComboboxAdd(txt_Currency, dt4, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
txt_Currency.SelectedIndex = 1;
//接收方式
DataTable dt5 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1101" }, this.ob);
comm.FilComboboxAdd(txt_ReceiveType, dt5, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
//加载运输条件
DataTable dt6 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1105" }, this.ob);
comm.FilComboboxAdd(txt_deliveryCondition, dt6, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
//加载运输方式
DataTable dt7 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1102" }, this.ob);
comm.FilComboboxAdd(txt_deliveryType, dt7, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
//加载包装方式
DataTable dt8 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1107" }, this.ob);
comm.FilComboboxAdd(txt_packType, dt8, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
//加载付款方式
DataTable dt9 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1104" }, this.ob);
comm.FilComboboxAdd(txt_paymentType, dt9, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
//加载合同金额分类
DataTable dt10 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1222" }, this.ob);
comm.FilComboboxAdd(txt_OrderMoneyType, dt10, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
//加载条款类型下拉框
DataTable dt20 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1218" }, this.ob);
foreach (DataRow row in dt20.Rows)
{
row["baseName"] = "[" + row["memo"] + "]" + row["baseName"];
}
comm.FilComboboxAdd(txt_ClauseType, dt20, "baseCode", "baseName", "validflag NOT in ('0')", false, "全部", "");
MatCheckitem item = new MatCheckitem();
item.Validflag = "1";
DataTable dt1212 = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatCheckitem_jhyService", "find", new object[] { item, 0, 0 });
if (dt1212 == null || dt1212.Rows.Count == 0)
{
return;
}
//检验项目
ultraMAT_NAME.DataSource = dt1212;
ultraMAT_NAME.ValueMember = "matCode";
ultraMAT_NAME.DisplayMember = "matName";
DataRow dr = dt1212.NewRow();
dr[0] = "";
dr[1] = "";
dt1212.Rows.Add(dr);
string basecode = "1235";// 合同类型
DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { basecode }, this.ob);
dt = dt.AsEnumerable().Where(p => p["VALIDFLAG"].ToString().Equals("1")).CopyToDataTable();
combo_order_type.DataSource = dt;
combo_order_type.DisplayMember = "BASENAME";
combo_order_type.ValueMember = "BASECODE";
}
/// <summary>
/// 清除合同头编辑区
/// </summary>
private void ClearTab1()//清除合同头编辑区
{
txt_AftPaymentAmt1.Value = 0;//尾款1
txt_OrderId.Text = "";//合同号
txt_OrderId.Text = "";//合同编号
txt_TaskRecordId.Text = "";//采购纪要
txt_ModeName.Text = "";//合同模板名称
txt_TitleName.Text = "";//合同头名称
currencylabel1.Text = "-";
currencylabel4.Text = "-";
txt_SignAddress.Value= "天津市";//签订地点
txt_CreateTime.Value = DateTime.Now;//创建时间
txt_SignDate.Value = DateTime.Now;//签订日期
txt_ModeName.Text = "";//模板名称
txt_TaskRecordId.Text = "";//采购纪要号
txt_OrderType.SelectedIndex = -1;//合同类别
txt_Currency.SelectedIndex = -1;//合同货币代码
txt_OrderClass.SelectedIndex = -1;//合同分类置空
txt_OrderMoneyType.SelectedIndex = -1;//合同金额类别
txt_deliveryType.SelectedIndex = -1;//运输方式
txt_deliveryCondition.SelectedIndex = -1;//运输条件
txt_buy_name.Clear();
}
/// <summary>
/// 清空合同行编辑区
/// </summary>
private void ClearTab2()// 清空合同行编辑区
{
//合同行部分
txt_EndDate2.Value = null;//要求到货时间
txt_ReceiveType.SelectedIndex = -1;//接收方式
//txt_Pur_Clause.SelectedIndex = -1;//结算条款
txt_paymentType.SelectedIndex = -1;//付款方式
txt_packType.SelectedIndex = -1;//包装方式
currencyLabel66.Text = "-";
txt_Remark.Clear();
txt_balanceClause.Clear();
txt_BalanceClauseType.SelectedIndex = -1;
txt_balanceClause.Clear();
init_balance_Id = "";
}
/// <summary>
/// 清空合同条款编辑区
/// </summary>
private void ClearTab3()// 清空合同条款编辑区
{
txt_Clauseid.Clear();
txt_ClauseIndx1.Clear();
txt_ClauseIndx2.Value = "1";
txt_ClauseName.Clear();
txt_ClauseOldId.Clear();
txt_ClauseType.SelectedIndex = -1;
txt_ClauseDesc.Clear();
init_bcm_Id = "";
txt_Bcm_Name.Text = "";
}
private void ClearTab4()
{
ConfigureClassCommon.clearOldData(panel1);
jy_procRecord.Clear();
}
/// <summary>
/// 清空文件上传编辑区
/// </summary>
private void ClearTab5()
{
txt_certPath.Clear();
txt_certpath_local.Clear();
txt_CERTDESC.Clear();
fileName = "";
}
#endregion
#region 公共函数
/// <summary>
///从表 查询
/// </summary>
private void getOrderC(string ab, String lineId)
{
dataTable2.Clear();
OrderC odC = new OrderC();
odC.OrderId = ab;
odC.Validflag = "1";
DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCService", "doQueryOrderC", new object[] { odC, 0, 0 });
GridHelper.CopyDataToDatatable(dt, dataTable2, true);
GridHelper.RefreshAndAutoSize(ultraGrid2);
if (!String.IsNullOrEmpty(lineId))
{
ConfigureClassCommon.doActiveSelRow(ultraGrid2, "orderLineSqe", lineId);
}
}
/// <summary>
///条款从表 查询
/// </summary>
private void getOrderClause(string strOrderId, string clauseId)//条款从表 查询
{
dataTable3.Clear();
OrderCClause clause = new OrderCClause();
clause.OrderId = strOrderId;
DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCClauseService", "find_Clause", new object[] { clause });
GridHelper.CopyDataToDatatable(dt, dataTable3, true);
GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid3, new UltraGridColumn[] { ultraGrid3.DisplayLayout.Bands[0].Columns["ClauseDesc"] });
//GridHelper.RefreshAndAutoSize(ultraGrid3);
if (!String.IsNullOrEmpty(clauseId))
{
ConfigureClassCommon.doActiveSelRow(ultraGrid3, "ID", clauseId);
}
}
/// <summary>
/// 采购纪要查询
/// </summary>
/// <param name="strTaskRecordId"></param>
private void getTaskRecord(string strTaskRecordId)
{
dataTable5.Clear();
ClearTab4();
PurTaskRecordEntity taskRecord = this.execute<PurTaskRecordEntity>("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strTaskRecordId });
if (taskRecord != null)
{
jy_buyerUsername.Text = taskRecord.BuyerUsername;
jy_mngOrgName.Text = taskRecord.MngOrgName;
jy_negDate.Value = taskRecord.NegDate;
jy_procRecord.Text = taskRecord.ProcRecord.Replace("\n", "\r\n");
jy_taskId.Text = taskRecord.TaskId;
jy_taskName.Text = taskRecord.TaskName;
jy_type.Value = taskRecord.Type;
//加载采购纪要评单记录表
DataTable dt6 = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskEvaService", "doQueryEva", new object[] { taskRecord.TaskId });
GridHelper.CopyDataToDatatable(dt6, dataTable5, true);
GridHelper.RefreshAndAutoSize(ultraGrid6);
}
}
/// <summary>
/// 加载合同附件
/// </summary>
/// <param name="strOrderId"></param>
/// <param name="p"></param>
private void getOrderAppend(string strOrderId, string p)
{
dataTable4.Clear();
OrderAppend append = new OrderAppend();
append.OrderId = strOrderId;
append.Validflag = "1";
DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderAppendService", "find", new object[] { append,0,0});
GridHelper.CopyDataToDatatable(dt, dataTable4, true);
GridHelper.RefreshAndAutoSize(ultraGrid4);
if (!String.IsNullOrEmpty(p))
{
ConfigureClassCommon.doActiveSelRow(ultraGrid4, "CERTPATH", p);
}
}
/// <summary>
/// 获取合同评审意见
/// </summary>
/// <param name="strOrderId"></param>
private void getOrderReview(string strOrderId)
{
DataTable dt11 = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "getReviewMsg", new object[] { strOrderId });
GridHelper.CopyDataToDatatable(dt11, dataTable7, true);
GridHelper.RefreshAndAutoSize(ultraGrid7);
}
/// <summary>
/// 加载合同变更记录
/// </summary>
/// <param name="strOrderId"></param>
private void getOrderChangeRecord(string strOrderId)
{
change.Clear();
OrderChangeM change1 = new OrderChangeM();
if (strOrderId.EndsWith("BG"))
{
change1.OrderIdB = strOrderId;
}
else
{
change1.OrderId = strOrderId;
}
change1.Validflag = "1";
DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderChangeMService", "find", new object[] { change1, 0, 0 });
if (dt != null && dt.Rows.Count > 0)
{
ultraTabControl2.Tabs["change"].Visible = true;
GridHelper.CopyDataToDatatable(dt, dataTable8, true);
GridHelper.RefreshAndAutoSize(ultraGrid8);
}
else
{
ultraTabControl2.Tabs["change"].Visible = false;
}
}
/// <summary>
/// 设置包含在指定列中的列可编辑
/// </summary>
/// <param name="band"></param>
/// <param name="columnKeys"></param>
public static void SetColumnsActive(UltraGridBand band, params string[] columnKeys)
{
foreach (UltraGridColumn gridColumn in band.Columns)
{
if (columnKeys.Contains(gridColumn.Key) != true)
{
gridColumn.CellActivation = Activation.ActivateOnly;
}
}
}
/// <summary>
/// 字符串转是否能转换成非负数
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public static bool Is_Below_zero(string str)
{
try
{
if (str.Equals(""))
{
return false;
}
else
{
if (StringUtil.IsDouble(str) && double.Parse(str) > 0)
return true;
else
return false;
}
}
catch
{
return false;
}
}
/// <summary>
/// 激活输入当前值行数据
/// </summary>
/// <param name="ug">ultragrid</param>
/// <param name="strColumn">列名</param>
/// <param name="strKey">列值</param>
public static string doActiveSelRow(UltraGrid ug, string strColumn, string strKey)// 激活输入当前值行数据
{
try
{
if (strKey != "")
{
foreach (UltraGridRow row in ug.Rows)
{
if (row.Cells[strColumn].Text.ToString() == strKey)
{
row.Activated = true;
if (row.ChildBands != null)
row.Expanded = true;
}
}
}
return "";
}
catch (Exception ex)
{
return ex.ToString();
}
}
/// <summary>
/// 验证合同头输入数据有效性
/// </summary>
/// <returns></returns>
private bool testOrderM()// 验证合同头输入数据有效性
{
if (string.IsNullOrEmpty(txt_Currency.Text) || txt_Currency.Text.ToString().Trim() == "/")
{
MessageUtil.ShowTips("合同货币类型不能为空");
txt_Currency.Focus();
return false;
}
if (string.IsNullOrEmpty(txt_OrderType.Text) || txt_OrderType.Text.ToString().Trim() == "/")
{
MessageUtil.ShowTips("合同类别不能为空！");
txt_OrderType.Focus();
return false;
}
if (String.IsNullOrEmpty(txt_OrderType.Value.ToString().Trim()) || txt_OrderType.Value.ToString().Trim() == "/")
{
MessageUtil.ShowTips("未选择合同类别为空，请选择合同类别");
txt_OrderType.Focus();
return false;
}
if (String.IsNullOrEmpty(txt_SignDate.Text))
{
MessageUtil.ShowTips("请输入合同签订日期");
txt_SignDate.Focus();
return false;
}
return true;
}
/// <summary>
/// 验证合同行输入数据的有效性
/// </summary>
/// <returns></returns>
private bool testOrderC()// 验证合同行输入数据的有效性
{
if (String.IsNullOrEmpty(txt_ReceiveType.Text))
{
MessageUtil.ShowTips("请选择接收方式");
txt_ReceiveType.Focus();
return false;
}
//if (txt_paymentType.SelectedIndex==-1)
//{
// MessageUtil.ShowTips("请选择付款方式");
// txt_paymentType.Focus();
// return false;
//}
if (String.IsNullOrEmpty(txt_EndDate2.Text))
{
MessageUtil.ShowTips("请输入有效的合同行交货开始时间");
txt_EndDate2.Focus();
return false;
}
return true;
}
/// <summary>
/// 验证合同条款输入数据的有效性
/// </summary>
/// <returns></returns>
private bool testOrderClause()// 验证合同条款输入数据的有效性
{
if (String.IsNullOrEmpty(txt_ClauseDesc.Text.Trim()))
{
txt_ClauseDesc.Focus();
MessageUtil.ShowTips("合同条款内容不能为空！");
return false;
}
if (String.IsNullOrEmpty(txt_ClauseName.Text.Trim()))
{
txt_ClauseName.Focus();
MessageUtil.ShowTips("合同条款名称不能为空！");
return false;
}
if (txt_ClauseType.SelectedIndex == -1)
{
txt_ClauseType.Focus();
MessageUtil.ShowTips("合同条款分类不能为空！");
return false;
}
if (String.IsNullOrEmpty(txt_ClauseIndx1.Text))
{
txt_ClauseIndx1.Focus();
MessageUtil.ShowTips("合同条款分排序（打印顺序1）不能为空！");
return false;
}
if (txt_ClauseIndx2.Value==null)
{
txt_ClauseIndx2.Focus();
MessageUtil.ShowTips("合同条款排序（打印顺序2）不能为空！");
return false;
}
return true;
}
/// <summary>
/// 验证合同条款输入数据的有效性
/// </summary>
/// <returns></returns>
private bool testOrderAppendStatus(String strId,int p)// 验证合同附件
{
OrderAppend append = this.execute<OrderAppend>("com.hnshituo.pur.order.service.OrderAppendService", "findById", new object[] { strId });
if (append == null)
{
MessageUtil.ShowTips("未发现合同附件：" + strId+"信息记录，可能已作废");
return false;
}
if (append.Validflag != "1")
{
MessageUtil.ShowTips("合同附件：" + strId + "信息记录可能已作废");
return false;
}
if (append.CreateUserid != UserInfo.GetUserID())
{
MessageUtil.ShowTips("非本人上传合同附件无权限进行增删改");
return false;
}
if (p == 1)
{
}
else
{
MessageUtil.ShowTips("未知参数：" + p + "");
return false;
}
return true;
}
/// <summary>
/// 验证合同行的状态有效性
/// </summary>
/// <param name="strOrderLineSqe"></param>
/// <param name="p"></param>
/// <returns></returns>
private bool testOrderCStatus(string strOrderLineSqe, int p)// 验证合同行的状态有效性
{
OrderC oc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
if (oc == null)
{
MessageUtil.ShowTips("无合同行【" + strOrderLineSqe + "】的信息记录，可能已被作废,或请刷新界面重新操作！");
return false;
}
if (oc.Validflag=="0")
{
MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】的信息记录可能已被作废,或请刷新界面重新操作！");
return false;
}
String strOrderId = oc.OrderId;
//是否允许删除
if (p == 1)
{
if (testOrderMStatus(strOrderId, 1) == false)
{
return false;
}
//验证是否生成通知单
if (oc.CreatedNoticeQty != null)
{
if (oc.CreatedNoticeQty > 0)
{
MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】已编制发货通知单！");
return false;
}
}
}
else
{
MessageUtil.ShowTips("未知参数，无法验证合同行数据的有效性！");
return false;
}
return true;
}
/// <summary>
/// 验证合同头的状态有效性
/// </summary>
/// <param name="strOrderId"></param>
/// <param name="p"></param>
/// <returns></returns>
private bool testOrderMStatus(string strOrderId, int p)// 验证合同头的状态有效性
{
OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
if (Omg == null)
{
MessageUtil.ShowTips("未发现合同【" + strOrderId + "】的信息记录，可能已作废,或请刷新界面重新操作！");
return false;
}
if (p != 8&&p!=41)
{
if (Omg.CreateUserid != UserInfo.GetUserID())
{
MessageUtil.ShowWarning("非提报该合同本人，无权限进行增删改操作，或请刷新后再操作！");
return false;
}
}
if (Omg.Validflag != "1")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】可能已作废,或请刷新界面重新操作！");
return false;
}
String tempStatus = Omg.Status.ToString().Trim();
//验证合同头是否可以增改
if (p == 1)
{
if (strOrderId.EndsWith("BG"))
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】为临是变更合同，无法进行增改，请刷新后再操作！");
return false;
}
if (tempStatus == "0" && tempStatus== "3" && tempStatus == "4")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“草稿”或“待提报”或“审批不通过”状态，无法进行增改操作，请刷新后再操作！");
return false;
}
//if (tempStatus == "2")
//{
// CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "canSubmitOrderM", new object[] { strOrderId });
// if (crt.Resultcode != 1)
// {
// MessageUtil.ShowWarning("合同【" + strOrderId + "】上一节点已审批，无法进行增改，请刷新后再操作！");
// return false;
// }
//}
}
//验证合同是否可以删除
else if (p == 2)
{
if (tempStatus != "1" && tempStatus != "0" && tempStatus != "5")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“草稿”、“待提报”、“审批不通过”状态，无权限进行删除操作，请刷新后再操作！");
return false;
}
}
//验证是否可以提报
else if(p==3)
{
if (tempStatus != "1"&& tempStatus != "5")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“待提报”或者“审批不通过”状态，请刷新后再操作！");
return false;
}
OrderC orderc = new OrderC();
orderc.OrderId = strOrderId;
orderc.Validflag = "1";
List<OrderC> dt = this.execute<List<OrderC>>("com.hnshituo.pur.order.service.OrderCService", "find", new object[] { orderc ,0,0});
if (dt == null || dt.Count < 1)
{
MessageUtil.ShowTips("合同【" + strOrderId + "】无有效的行信息,或请刷新界面重新操作！");
return false;
}
//验证数据的有效性--头有效性
if (string.IsNullOrEmpty(Omg.Currency))
{
MessageUtil.ShowTips("需要完善合同货币类型，该项不能为空！");
return false;
}
if (string.IsNullOrEmpty(Omg.OrderType))
{
MessageUtil.ShowTips("需要完善合同类别，该项不能为空！");
return false;
}
if (String.IsNullOrEmpty(Omg.SuppCode))
{
MessageUtil.ShowTips("需要完善供方信息，供应商编号不能为空！");
return false;
}
//if (String.IsNullOrEmpty(Omg.TaxRateName))
//{
// MessageUtil.ShowTips("需要完善合同税率信息，合同税率不允许为空！");
// return false;
//}
if (String.IsNullOrEmpty(Omg.ModeId))
{
MessageUtil.ShowTips("需要选择合同模板，合同模板不允许为空！");
return false;
}
if (Omg.SignDate==null)
{
MessageUtil.ShowTips("需完善合同签订日期，合同签订日期不允许为空");
txt_SignDate.Focus();
return false;
}
for(int i=0;i<dt.Count;i++)
{
OrderC oc=dt[i];
//if (!isRightDoubleWithoutZero(oc.Qty) || string.IsNullOrEmpty(oc.ItemCode))
if (string.IsNullOrEmpty(oc.ItemCode))
{
MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的合同数量数，物料未维护，上述项不允许为空！");
return false;
}
if (!isRightDoubleWithZero(oc.PriceWithoutTax) || !isRightDoubleWithZero(oc.PriceWithTax))
{
MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的含税单价和不含税单价未维护，上述项不允许为空！");
return false;
}
if (String.IsNullOrEmpty(oc.ReceiveType))
{
MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的接收方式未维护，上述项不允许为空！");
return false;
}
//if (String.IsNullOrEmpty(oc.DeliveryLocation) || String.IsNullOrEmpty(oc.DeliveryLocationCode))
//{
// MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交付地点和地点编码未维护，上述项不能为空！");
// return false;
//}
if (!isRightDoubleWithoutZero(oc.ItemUomConefficient))
{
MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的单位转化系数为空，数据异常！");
return false;
}
if (string.IsNullOrEmpty(oc.ItemUom)||string.IsNullOrEmpty(oc.WeightUnit))
{
MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的库存单位和采购单位为空，数据异常！");
return false;
}
//if (oc.StartDate==null)
//{
// MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间未维护，上述项不能为空！");
// return false;
//}
if (oc.EndDate==null)
{
MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货结束时间未维护，上述项不能为空！");
return false;
}
//if (Convert.ToDateTime(oc.StartDate) > Convert.ToDateTime(oc.EndDate))
//{
// MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间不能需早于接收时间，请维护有效的交货时间！");
// return false;
//}
}
}
//合同是否可以撤回
else if (p == 4)
{
if (tempStatus != "2" && tempStatus != "5")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】未在“审批中”或者“审批不通过”状态，无权限撤回，请刷新后再操作！");
return false;
}
if (tempStatus != "5")
{
CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "iscanRevOrderM", new object[] { strOrderId });
if (crt.Resultcode != 1)
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】已被下游节点审批，无权限撤回，请刷新后再操作！");
return false;
}
}
}
//合同是否可以撤回(审批或者审批中)
else if (p == 41)
{
if (tempStatus != "2" && tempStatus != "3" && tempStatus != "4" && tempStatus != "5")
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】未提报或者已经变更，请刷新后再操作！");
return false;
}
ExcDeliveryNoticeC nc = new ExcDeliveryNoticeC();
nc.OrderId = strOrderId;
nc.Validflag = "1";
int count = this.execute<int>("com.hnshituo.pur.ck.service.ExcDeliveryNoticeCService", "count", new object[] { nc });
if (count > 0)
{
MessageUtil.ShowWarning("合同【" + strOrderId + "】已经编制发货通知，请刷新后再操作！");
return false;
}
}
else if (p == 6)
{
if (tempStatus == "0" || tempStatus == "1")
{
MessageUtil.ShowWarning("合同未申请流程，请先提报！");
return false;
}
}
//归档
else if (p == 8)
{
if (tempStatus != "3")
{
MessageUtil.ShowWarning("合同未审批通过，无法归档！");
return false;
}
if (tempStatus == "4")
{
MessageUtil.ShowWarning("重复操作，合同已归档！");
return false;
}
OrderAppend sat = new OrderAppend();
sat.OrderId = strOrderId;
sat.Validflag = "1";
int count = this.execute<int>("com.hnshituo.pur.order.service.OrderAppendService", "count", new object[] { sat });
if (count <= 0)
{
MessageUtil.ShowTips("无法归档，合同：" + strOrderId + "未上传任何附件，请以附件形式上传已生效的合同电子文档！");
return false;
}
}
else
{
MessageUtil.ShowTips("未知参数，无法验证合同头数据的有效性！");
return false;
}
return true;
}
/// <summary>
/// 验证是否为非负小数
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
private bool isRightDoubleWithZero(double? db)// 验证是否为非负小数
{
if (db == null)
{
return false;
}
if (db < 0)
{
return false;
}
return true;
}
/// <summary>
/// 验证是否为大于0的正数
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
private bool isRightDoubleWithoutZero(double? db)// 验证是否为大于0的正数
{
if (db == null)
{
return false;
}
if (db <= 0)
{
return false;
}
return true;
}
/// <summary>
/// 查看流程详情
/// </summary>
private void Process()//查看流程详情
{
UltraGridRow uge = ultraGrid1.ActiveRow;
if (uge == null)
{
MessageUtil.ShowTips("请选择合同头！");
return;
}
String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
ProcInstDetail detail = new ProcInstDetail(BpmFlowConstants.PROCDEF_PUR_ORDER_AUDIT, strOrderId);
detail.ShowDialog();
}
#endregion
#region 附件上传
private void craftImg_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
try
{
UltraGridRow row = ultraGrid4.ActiveRow;
string filePathOld = row.GetValue("certPathOld");
if (e.Button.Key.ToLower().Equals("select"))
{
FrmPopFileShow down = new FrmPopFileShow(this.ob, filePathOld);
down.DeleteButton.Visible = false;
down.ShowDialog();
}
}
catch (Exception ex)
{
MessageUtil.ShowTips("操作失败：" + ex);
}
}
private void txt_certPath_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
try
{
if (e.Button.Key.ToLower().Equals("insert"))
{
OpenFileDialog file = new OpenFileDialog();
file.Multiselect = false;
DialogResult drStat;
drStat = file.ShowDialog();
if (drStat == DialogResult.OK)
{
fileName = file.FileName;
String filePathlocal = System.IO.Path.GetFullPath(fileName);
string filena = System.IO.Path.GetFileName(fileName);
txt_certPath.Text = filena;
txt_certpath_local.Text = filePathlocal;
}
}
}
catch (Exception ex)
{
MessageUtil.ShowTips("操作失败：" + ex);
}
}
//上传按钮
private void btn_submitAppend_Click(object sender, EventArgs e)
{
if (ultraGrid1.ActiveRow == null)
{
MessageUtil.ShowTips("未选择合同头");
return;
}
String filena = txt_certPath.Text.ToString().Trim();
if (String.IsNullOrEmpty(filena) || String.IsNullOrEmpty(fileName))
{
MessageUtil.ShowTips("请选择待上传文件");
return;
}
string strOrderId = ultraGrid1.ActiveRow.GetValue("orderId");
OrderAppend sat = new OrderAppend();
sat.OrderId = strOrderId;
String filePathNew = "Pms/CERT/" + strOrderId + "/";
sat.CertPath = filena;
sat.CertPathOld = filePathNew + filena;
sat.CreateUserid = UserInfo.GetUserID();
sat.CreateName = UserInfo.GetUserName();
sat.CreateTime=DateTime.Now;
sat.Validflag = "1";
sat.CertDesc = txt_CERTDESC.Text.Trim();
if (GetCraftFileCraftNoCnt(filena, strOrderId) > 0)
{
MessageUtil.ShowTips("合同已存在该附件文件:" + filena);
return;
}
List<FileBean> list = new List<FileBean>();
FileBean bean = new FileBean();
bean = new FileBean();
bean.setFileName(filena);
bean.setPathName(filePathNew);
bean.setFile(FileHelper.FileToArray(fileName));
list.Add(bean);
bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
if (isSuccess)
{
//开始写数据库
CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderAppendService", "insert_append", new object[] { sat });
if (crt.Resultcode != 0)
{
MessageUtil.ShowTips("上传失败：" + crt.Resultmsg);
}
else
{
MessageUtil.ShowTips("上传成功");
ClearTab5();
}
}
else
{
MessageBox.Show("上传失败");
}
//刷新界面并激活当前行
Relocate(sat);
}
private void Relocate(OrderAppend sat)
{
getOrderAppend(sat.OrderId,sat.CertPath);
}
/// <summary>
/// 判断是否之前已提交相同的文件
/// </summary>
/// <param name="craftNo"></param>
/// <returns></returns>
private int GetCraftFileCraftNoCnt(string CERT_PATH, string orderId)
{
OrderAppend sat = new OrderAppend();
sat.CertPath = CERT_PATH;
sat.OrderId = orderId;
sat.Validflag = "1";
int dt = this.execute<int>("com.hnshituo.pur.order.service.OrderAppendService", "count", new object[] { sat });
return dt;
}
#endregion
#region @检验项
private void btn_saveItem_Click(object sender, EventArgs e)
{
if (ultraGrid2.ActiveRow == null)
{
MessageUtil.ShowTips("请选择合同行");
return;
}
String strOrderLineSqe = ultraGrid2.ActiveRow.Cells["OrderLineSqe"].Value.ToString();
if (String.IsNullOrEmpty(strOrderLineSqe))
{
MessageUtil.ShowTips("请选择合同行行号为空");
return;
}
if (cb_standardsCode.SelectedIndex == -1)
{
MessageUtil.ShowTips("请选择合同行检验标准");
cb_standardsCode.Focus();
return;
}
String strMic = cb_standardsCode.Value.ToString().Trim();
if (String.IsNullOrEmpty(strMic))
{
MessageUtil.ShowTips("请选择合同行检验标准,检验标准编号为空");
cb_standardsCode.Focus();
return;
}
ArrayList alDetail = new ArrayList();
foreach (UltraGridRow ur in ultraGrid5.Rows)
{
if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MATNAME"].Text.Trim() != "")
{
OrderCStdDetail DET = new OrderCStdDetail();
DET.MatCode=ur.Cells["MATNAME"].Value.ToString();
DET.MatName = ur.Cells["MATNAME"].Text.Trim();
if (DET.MatCode == DET.MatName)
{
DET.MatCode = ur.Cells["MATCODE"].Text.Trim();
}
DET.AddCondition = "";
DET.StdminSign = ur.Cells["STDMINSIGN"].Value.ToString();
DET.Stdmin = ur.Cells["STDMIN"].Text.Trim();
DET.Stdmax = ur.Cells["STDMAX"].Text.Trim();
DET.StdmaxSign = ur.Cells["STDMAXSIGN"].Text.Trim();
DET.StdminSign = ur.Cells["STDMINSIGN"].Text.Trim();
//DET.CheckCycle = ur.Cells["CHECKCYCLE"].Text.Trim();
DET.JudgeTypeCode = ur.Cells["JUDGETYPE"].Value.ToString();
DET.JudgeType = ur.Cells["JUDGETYPE"].Text.Trim();
DET.Remark = ur.Cells["REMARK"].Text.Trim();
DET.OrderLineSqe = ur.Cells["orderLineSqe"].Text.Trim();
DET.Id = ur.Cells["id"].Value.ToString();
DET.CreateName = UserInfo.GetUserName();
DET.CreateTime = DateTime.Now;
if (String.IsNullOrEmpty(DET.OrderLineSqe))
{
DET.OrderLineSqe = strOrderLineSqe;
}
else
{
if (DET.OrderLineSqe != strOrderLineSqe)
{
MessageUtil.ShowTips("非合同行:" + strOrderLineSqe+"检验项目");
return;
}
}
if (String.IsNullOrEmpty(DET.MatCode))
{
MessageUtil.ShowTips("检验项目不能为空");
return;
}
if (String.IsNullOrEmpty(DET.StdminSign))
{
MessageUtil.ShowTips("检验项目上限符号不能为空，若文字描述请默认选等于");
return;
}
if (String.IsNullOrEmpty(DET.Id))
{
OrderCStdDetail detailstd = new OrderCStdDetail();
detailstd.MatCode = DET.MatCode;
detailstd.Validflag = "1";
detailstd.OrderLineSqe = DET.OrderLineSqe;
int Count = this.execute<int>("com.hnshituo.pur.order.service.OrderCStdDetailService", "count", new object[] { detailstd});
if (Count > 0)
{
MessageUtil.ShowTips("合同行：" + DET.OrderLineSqe+"已维护"+DET.MatName+"检验项目");
return;
}
}
alDetail.Add(DET);
}
}
if (alDetail.Count <= 0)
{
MessageUtil.ShowTips("请选择需保持的检验项目");
return;
}
CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCStdDetailService", "doUpdate_batch", new object[] { alDetail,strOrderLineSqe, strMic,UserInfo.GetUserName()});
if (re.Resultcode != 0)
{
MessageUtil.ShowTips("操作失败:"+re.Resultmsg);
}
else
{
MessageUtil.ShowTips("操作成功");
getStdDetail(strOrderLineSqe);
}
}
#endregion
private void btn_editJy_Click(object sender, EventArgs e)
{
try{
UltraGridRow ugr = ultraGrid1.ActiveRow;
if (ugr == null)
{
MessageUtil.ShowWarning("请选择您要查看采购纪要的合同头！");
return;
}
string strRecordId = ugr.Cells["TaskRecordId"].Value.ToString().Trim();
String strOrderId = ugr.Cells["OrderId"].Value.ToString().Trim();
if (String.IsNullOrEmpty(strOrderId))
{
MessageUtil.ShowTips("该合同头编号为空！");
return;
}
if (String.IsNullOrEmpty(strRecordId))
{
MessageUtil.ShowTips("采购纪要号为空，可能未生成采购纪要！");
return;
}
PurTaskRecordEntity record = new PurTaskRecordEntity();
record.Id = strRecordId;
record.ProcRecord = jy_procRecord.Text.ToString().Trim();
if (MessageUtil.ShowYesNoAndQuestion("确定修改纪要：" + record.Id + "?") != DialogResult.Yes)
{
return;
}
CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.purplan.service.TaskRecordService", "doUpdate", new object[] { record });
if (crt.Resultcode == 0)
{
MessageUtil.ShowTips("操作成功！");
getTaskRecord(strRecordId);
}
else
{
MessageUtil.ShowTips("操作失败！" + crt.Resultmsg);
}
}
catch (Exception ex)
{
MessageUtil.ShowTips("操作失败！" + ex.Message);
}
}
private void cb_standardsCode_ValueChanged(object sender, EventArgs e)
{
if (cb_standardsCode.SelectedIndex != -1)
{
String mic = cb_standardsCode.Value.ToString().Trim();
if (String.IsNullOrEmpty(mic))
{
dataTable11.Clear();
MatStdDetail detailstd = new MatStdDetail();
detailstd.Mic = mic;
detailstd.Validflag = "1";
DataTable list_detail = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatStdDetail_jhyService", "find", new object[] { detailstd, 0, 0 });
GridHelper.CopyDataToDatatable(list_detail, dataTable11, true);
}
}
}
private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
{
if (e.Row.Cells["status"].Value.ToString().StartsWith("审批不通过") || e.Row.Cells["status"].Value.ToString().StartsWith("草稿"))
{
e.Row.Appearance.ForeColor = Color.Red;
}
else if (e.Row.Cells["status"].Value.ToString().StartsWith("合同变更中"))
{
e.Row.Appearance.ForeColor = Color.Gray;
}
else
{
e.Row.Appearance.ForeColor = Color.Black;
}
if (e.Row.Cells["orderId"].Value.ToString().EndsWith("BG"))
{
e.Row.Appearance.ForeColor = Color.Blue;
}
}
private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
}
private void ultraTabPageControl1_Paint(object sender, PaintEventArgs e)
{
}
private void ultraGrid2_CellChange(object sender, CellEventArgs e)
{
if (e.Cell.Column.Header.Caption == "折算数量")
{
UltraGridRow ugr2 = ultraGrid2.ActiveRow;
ugr2.Cells["convertPrice"].Value = (Double.Parse(ugr2.Cells["WithAmtTax"].Text.ToString()) / Double.Parse(ugr2.Cells["convertCount"].Text.ToString().Replace("_", ""))).ToString("f2");
ugr2.Cells["convertPriceTax"].Value = (Double.Parse(ugr2.Cells["WithoutTaxAmt"].Text.ToString()) / Double.Parse(ugr2.Cells["convertCount"].Text.ToString().Replace("_", ""))).ToString("f2");
}
}
}
}