private void CustomMainForm_Load(object sender, EventArgs e)
{
if (!DesignMode)
{
labelTitle.Text = _Enum_BillType.ToString();
cmbVersion.DataSource = _ServiceFlow.GetBusinessInfoVersion(_Enum_BillType);
cmbVersion.SelectedIndex = 0;
m_billMessageServer = BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
checkBillDateAndStatus1.cmbBillStatus.Items.Clear();
checkBillDateAndStatus1.InsertComBox(_ServiceFlow.GetBusinessStatus(_Enum_BillType, cmbVersion.Text));
checkBillDateAndStatus1.InitDateTime();
m_billNoControl = new BillNumberControl(_Enum_BillType.ToString(), _BusinessService as IBasicBillServer);
m_billMessageServer.BillType = _Enum_BillType.ToString();
foreach (TabPage tp in tabControl1.TabPages)
{
foreach (Control cl in tp.Controls)
{
if (cl is CustomDataGridView)
{
((CustomDataGridView)cl).DoubleClick += new EventHandler(dataGridView_DoubleClick);
((CustomDataGridView)cl).CellEnter += new DataGridViewCellEventHandler(CustomMainForm_CellEnter);
}
}
}
RefreshData(tabControl1.SelectedTab);
}
}
private void reportViewer1_Print(object sender, CancelEventArgs e)
{
if (VirtualPrint.IsVirtualPrint(out m_err))
{
e.Cancel = true;
MessageDialog.ShowPromptMessage(m_err);
}
else
{
IPrintManagement printManagement = BasicServerFactory.GetServerModule <IPrintManagement>();
S_PrintBillTable printInfo = new S_PrintBillTable();
printInfo.Bill_ID = m_billID;
printInfo.Bill_Name = m_billName;
printInfo.PrintDateTime = ServerModule.ServerTime.Time;
printInfo.PrintFlag = true;
printInfo.PrintPersonnelCode = BasicInfo.LoginID;
printInfo.PrintPersonnelName = BasicInfo.LoginName;
printInfo.PrintPersonnelDepartment = BasicInfo.DeptName;
if (printManagement.IsExist(printInfo, out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
}
else if (!printManagement.AddPrintInfo(printInfo, out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
}
reportViewer1.ShowPrintButton = false;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="pageWidth">打印页宽度, 以厘米为单位</param>
/// <param name="pageHeight">打印页高度, 以厘米为单位</param>
/// <param name="billReportInfo">单据类报表信息</param>
public PrintReportBill(double pageWidth, double pageHeight, IBillReportInfo billReportInfo)
{
m_pageWidth = pageWidth;
m_pageHeight = pageHeight;
m_billReportInfo = billReportInfo;
IPrintManagement printManagement = BasicServerFactory.GetServerModule <IPrintManagement>();
S_PrintBillTable printInfo = new S_PrintBillTable();
printInfo.Bill_ID = billReportInfo.BillNo;
printInfo.Bill_Name = billReportInfo.BillType;
printInfo.PrintDateTime = ServerModule.ServerTime.Time;
printInfo.PrintFlag = true;
printInfo.PrintPersonnelCode = BasicInfo.LoginID;
printInfo.PrintPersonnelName = BasicInfo.LoginName;
printInfo.PrintPersonnelDepartment = BasicInfo.DeptName;
if (billReportInfo.BillType != "")
{
if (!printManagement.AddPrintInfo(printInfo, out m_err))
{
m_allowPrint = false;
MessageDialog.ShowPromptMessage(m_err);
}
}
}
public void DirectAdd(string billNo)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.Flow_FlowBillData
where a.BillNo == billNo
select a;
if (varData.Count() != 1)
{
throw new Exception("数据不唯一");
}
Flow_FlowBillData tempLnq = varData.Single();
tempLnq.FlowID = 67;
ctx.SubmitChanges();
IBillMessagePromulgatorServer msgPromulgator = BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
msgPromulgator.BillType = CE_BillTypeEnum.创意提案.ToString();
msgPromulgator.EndFlowMessage(billNo, "直接录入", null, null);
}
/// <summary>
/// 获取员工合同信息
/// </summary>
/// <param name="returnInfo">员工合同信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作是否成功的标志</returns>
public bool GetAllPersonnelContarct(out IQueryResult returnInfo, out string error)
{
returnInfo = null;
error = null;
IAuthorization serverAuthorization = PlatformFactory.GetObject <IAuthorization>();
IQueryResult qr = null;
if (QueryResultFilter == null)
{
qr = serverAuthorization.Query("员工合同管理", null);
}
else
{
qr = serverAuthorization.Query("员工合同管理", null, QueryResultFilter);
}
if (!qr.Succeeded)
{
error = qr.Error;
return(false);
}
IBillTypeServer server = BasicServerFactory.GetServerModule <IBillTypeServer>();
BASE_BillType lnqBillType = server.GetBillTypeFromName("员工合同管理");
if (lnqBillType == null)
{
error = "获取不到单据类型信息";
return(false);
}
int m_billUniqueID = lnqBillType.UniqueID;
returnInfo = qr;
return(true);
}
/// <summary>
/// 回退单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="billStatus">回退后的单据状态</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <param name="rebackReason">回退原因</param>
/// <returns>回退成功返回True，回退失败返回False</returns>
public bool ReturnBill(string billNo, ConsumptionBillStatus billStatus, out string error, string rebackReason)
{
error = null;
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
try
{
var varData = from a in dataContext.WS_ConsumptionBill
where a.BillNo == billNo
select a;
string strMsg = "";
if (varData.Count() != 1)
{
throw new Exception("数据不唯一或者为空");
}
else
{
WS_ConsumptionBill lnqTemp = varData.Single();
IBillMessagePromulgatorServer billMessageServer =
BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
billMessageServer.BillType = CE_BillTypeEnum.车间耗用单.ToString();
switch (billStatus)
{
case ConsumptionBillStatus.新建单据:
strMsg = string.Format("{0}号车间物料转换单已回退，请您重新处理单据; 回退原因为"
+ rebackReason, billNo);
billMessageServer.PassFlowMessage(billNo, strMsg, BillFlowMessage_ReceivedUserType.用户,
UniversalFunction.GetPersonnelCode(lnqTemp.Proposer));
break;
case ConsumptionBillStatus.等待审核:
strMsg = string.Format("{0}号车间物料转换单已回退，请您重新处理单据; 回退原因为"
+ rebackReason, billNo);
billMessageServer.PassFlowMessage(billNo, strMsg, BillFlowMessage_ReceivedUserType.用户,
UniversalFunction.GetPersonnelCode(lnqTemp.Audit));
break;
default:
break;
}
lnqTemp.BillStatus = billStatus.ToString();
dataContext.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
private bool 纠正预防措施报告明细_PanelGetDataInfo(CE_FlowOperationType flowOperationType)
{
try
{
GetInfo();
Flow_FlowInfo info =
_Service_Flow.GetNowFlowInfo(_Service_Flow.GetBusinessTypeID(CE_BillTypeEnum.纠正预防措施报告, null),
_Lnq_BillInfo.BillNo);
if (flowOperationType == CE_FlowOperationType.提交)
{
NotifyPersonnelInfo personnelInfo = new NotifyPersonnelInfo();
List <PersonnelBasicInfo> lstInfo = new List <PersonnelBasicInfo>();
PersonnelBasicInfo infoTemp = new PersonnelBasicInfo();
switch (info.FlowID)
{
case 1109:
if (GeneralFunction.IsNullOrEmpty(_Lnq_BillInfo.D1_DutyDepartment))
{
throw new Exception("请选择【调查改善担当部门】");
}
break;
case 1110:
case 1112:
IBillMessagePromulgatorServer serviceBillMessage =
BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
List <string> lstRoleName = serviceBillMessage.GetSuperior(CE_RoleStyleType.负责人,
UniversalFunction.GetDeptCode(_Lnq_BillInfo.D1_DutyDepartment));
personnelInfo.UserType = BillFlowMessage_ReceivedUserType.角色.ToString();
foreach (string item in lstRoleName)
{
infoTemp = new PersonnelBasicInfo();
infoTemp.角色 = item;
lstInfo.Add(infoTemp);
}
personnelInfo.PersonnelBasicInfoList = lstInfo;
this.FlowInfo_NotifyInfo = personnelInfo;
break;
case 1111:
if (GeneralFunction.IsNullOrEmpty(_Lnq_BillInfo.D2_DutyPersonnel))
{
throw new Exception("请指定【改善小组组长】");
}
personnelInfo.UserType = BillFlowMessage_ReceivedUserType.用户.ToString();
infoTemp = new PersonnelBasicInfo();
infoTemp.工号 = _Lnq_BillInfo.D2_DutyPersonnel;
lstInfo.Add(infoTemp);
personnelInfo.PersonnelBasicInfoList = lstInfo;
this.FlowInfo_NotifyInfo = personnelInfo;
break;
default:
break;
}
}
this.FlowInfo_BillNo = txtBillNo.Text;
this.ResultInfo = _Lnq_BillInfo;
this.ResultList = new List <object>();
this.ResultList.Add(flowOperationType);
return(true);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return(false);
}
}
/// <summary>
/// 更新流程
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="advise">意见</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool UpdateInfo(string billNo, string advise, out string error)
{
error = null;
IBillMessagePromulgatorServer serverBill = BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
ISystemFileBasicInfo m_serverFileBasicInfo = Service_Quality_File.ServerModuleFactory.GetServerModule <ISystemFileBasicInfo>();
FileServiceSocket m_serverFTP = new FileServiceSocket(GlobalObject.GlobalParameter.FTPServerIP,
GlobalObject.GlobalParameter.FTPServerAdvancedUser,
GlobalObject.GlobalParameter.FTPServerAdvancedPassword);
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
var varData = from a in ctx.FM_InstitutionProcess
where a.BillNo == billNo
select a;
FM_InstitutionProcess lnqProcess = varData.Single();
serverBill.BillType = serverBill.GetBillTypeEnum(lnqProcess.TypeCode).ToString();
CE_BillTypeEnum billType = GlobalObject.GeneralFunction.StringConvertToEnum <CE_BillTypeEnum>(serverBill.BillType);
InstitutionBillStatus billStatus = GlobalObject.GeneralFunction.StringConvertToEnum <InstitutionBillStatus>(lnqProcess.BillStatus);
var varList = from a in ctx.FM_InstitutionProcessPointDept
where a.BillNo == billNo
select a;
FM_InstitutionProcessPointDept lnqPoint = new FM_InstitutionProcessPointDept();
List <FM_InstitutionProcessPointDept> list = varList.ToList();
List <string> listTemp = new List <string>();
switch (billStatus)
{
case InstitutionBillStatus.新建流程:
break;
case InstitutionBillStatus.等待科长审查:
lnqProcess.BillStatus = InstitutionBillStatus.等待负责人审查.ToString();
lnqProcess.Chief = BasicInfo.LoginName;
lnqProcess.ChiefAdvise = advise;
lnqProcess.ChiefTime = ServerTime.Time;
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.角色, serverBill.GetDeptPrincipalRoleName(UniversalFunction.GetPersonnelInfo(lnqProcess.Propoer).部门编码).ToList());
break;
case InstitutionBillStatus.等待负责人审查:
lnqProcess.BillStatus = InstitutionBillStatus.等待相关负责人审查.ToString();
lnqProcess.DepartmentHead = BasicInfo.LoginName;
lnqProcess.DepartmentHeadAdvise = advise;
lnqProcess.DepartmentHeadTime = ServerTime.Time;
if (billType == CE_BillTypeEnum.制度销毁申请流程)
{
lnqProcess.BillStatus = InstitutionBillStatus.等待分管领导审查.ToString();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.角色, serverBill.GetDeptLeaderRoleName(UniversalFunction.GetPersonnelInfo(lnqProcess.Propoer).部门编码).ToList());
}
else
{
listTemp = (from a in list
where a.PersonnelType == RoleStyle.负责人.ToString()
select a.Personnel).ToList();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.用户, listTemp);
}
break;
case InstitutionBillStatus.等待相关负责人审查:
lnqPoint = (from a in list
where a.Personnel == BasicInfo.LoginID &&
a.PersonnelType == RoleStyle.负责人.ToString()
select a).Single();
lnqPoint.PersonnelTime = ServerTime.Time;
lnqPoint.Advise = advise;
var varHead = from a in list
where a.PersonnelType == RoleStyle.负责人.ToString() &&
a.PersonnelTime == null
select a;
if (varHead.Count() == 0)
{
if (IsThreeTripFile(lnqProcess.SortID))
{
lnqProcess.BillStatus = InstitutionBillStatus.等待分管领导审查.ToString();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.角色, serverBill.GetDeptLeaderRoleName(UniversalFunction.GetPersonnelInfo(lnqProcess.Propoer).部门编码).ToList());
}
else
{
lnqProcess.BillStatus = InstitutionBillStatus.等待相关分管领导审查.ToString();
listTemp = (from a in list
where a.PersonnelType == RoleStyle.分管领导.ToString()
select a.Personnel).ToList();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.用户, listTemp);
}
}
else
{
listTemp = (from a in varHead
select a.Personnel).ToList();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.用户, listTemp);
}
break;
case InstitutionBillStatus.等待相关分管领导审查:
lnqPoint = (from a in list
where a.Personnel == BasicInfo.LoginID &&
a.PersonnelType == RoleStyle.分管领导.ToString()
select a).Single();
lnqPoint.PersonnelTime = ServerTime.Time;
lnqPoint.Advise = advise;
var varLead = from a in list
where a.PersonnelType == RoleStyle.分管领导.ToString() &&
a.PersonnelTime == null
select a;
if (varLead.Count() == 0)
{
lnqProcess.BillStatus = InstitutionBillStatus.等待总经理审查.ToString();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.角色, CE_RoleEnum.总经理.ToString());
}
else
{
listTemp = (from a in varLead
select a.Personnel).ToList();
serverBill.PassFlowMessage(lnqProcess.BillNo, string.Format("【文件编号】：{0} 【文件名】：{1} ※※※ 等待处理", lnqProcess.FileNo, lnqProcess.FileName),
BillFlowMessage_ReceivedUserType.用户, listTemp);
}
break;
case InstitutionBillStatus.等待分管领导审查:
case InstitutionBillStatus.等待总经理审查:
lnqProcess.BillStatus = InstitutionBillStatus.流程已结束.ToString();
lnqProcess.GeneralManager = BasicInfo.LoginName;
lnqProcess.GeneralManagerAdvise = advise;
lnqProcess.GeneralManagerTime = ServerTime.Time;
FM_FileList fileInfo = new FM_FileList();
if (lnqProcess.FileID != null)
{
var varFileInfo = from a in ctx.FM_FileList
where a.FileID == lnqProcess.FileID
select a;
if (varFileInfo.Count() == 1)
{
fileInfo = varFileInfo.Single();
}
}
if (billType == CE_BillTypeEnum.制度发布流程)
{
string strVersion = "1.0";
if (lnqProcess.ReplaceFileID == null)
{
DataTable dtTemp = m_serverFileBasicInfo.GetFilesInfo(lnqProcess.FileNo, null);
}
else
{
m_serverFileBasicInfo.OperatorFTPSystemFile(ctx, Convert.ToInt32(lnqProcess.ReplaceFileID), 29);
strVersion =
(Convert.ToDouble(m_serverFileBasicInfo.GetFile(Convert.ToInt32(lnqProcess.ReplaceFileID)).Version) + 0.1).ToString();
}
FM_FileList lnqFile = new FM_FileList();
lnqFile.Department = lnqProcess.Department;
lnqFile.FileName = lnqProcess.FileName;
lnqFile.FileNo = lnqProcess.FileNo;
lnqFile.FileUnique = lnqProcess.FileUnique;
lnqFile.SortID = lnqProcess.SortID;
lnqFile.Version = strVersion;
ctx.FM_FileList.InsertOnSubmit(lnqFile);
if (m_serverFTP.Errormessage.Length != 0)
{
throw new Exception(m_serverFTP.Errormessage);
}
}
else if (billType == CE_BillTypeEnum.制度修订废弃申请流程 && lnqProcess.OperationMode == "废弃")
{
if (fileInfo != null)
{
fileInfo.SortID = 29;
}
}
else if (billType == CE_BillTypeEnum.制度销毁申请流程)
{
ctx.FM_FileList.DeleteOnSubmit(fileInfo);
}
serverBill.EndFlowMessage(lnqProcess.BillNo,
string.Format("{0}号文件审查流程已结束", lnqProcess.BillNo), null,
(from a in varList select a.Personnel).ToList());
break;
case InstitutionBillStatus.流程已结束:
break;
default:
break;
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="institution">LINQ信息</param>
/// <param name="deptList">部门信息</param>
/// <param name="billEnum">单据类型</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True</returns>
public bool AddInfo(FM_InstitutionProcess institution, List <string> deptList, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
IBillMessagePromulgatorServer serverBill = BasicServerFactory.GetServerModule <IBillMessagePromulgatorServer>();
serverBill.BillType = serverBill.GetBillTypeEnum(institution.TypeCode).ToString();
try
{
institution.Propoer = BasicInfo.LoginName;
institution.PropoerTime = ServerTime.Time;
institution.BillStatus = InstitutionBillStatus.等待科长审查.ToString();
ctx.FM_InstitutionProcess.InsertOnSubmit(institution);
List <FM_InstitutionProcessPointDept> listPoint = new List <FM_InstitutionProcessPointDept>();
FM_InstitutionProcessPointDept tempLnq = new FM_InstitutionProcessPointDept();
if (deptList != null)
{
foreach (string item in deptList)
{
List <string> list = serverBill.GetUserCodes(serverBill.GetDeptPrincipalRoleName(item).ToList(), null);
foreach (string workID in list)
{
tempLnq = new FM_InstitutionProcessPointDept();
tempLnq.BillNo = institution.BillNo;
tempLnq.PersonnelType = RoleStyle.负责人.ToString();
tempLnq.Personnel = workID;
listPoint.Add(tempLnq);
}
if (!IsThreeTripFile(institution.SortID))
{
list = serverBill.GetUserCodes(serverBill.GetDeptLeaderRoleName(item).ToList(), null);
foreach (string workID in list)
{
tempLnq = new FM_InstitutionProcessPointDept();
tempLnq.BillNo = institution.BillNo;
tempLnq.PersonnelType = RoleStyle.分管领导.ToString();
tempLnq.Personnel = workID;
listPoint.Add(tempLnq);
}
}
}
var varData = (from a in listPoint
select new { a.BillNo, a.Personnel, a.PersonnelType }).Distinct();
listPoint = new List <FM_InstitutionProcessPointDept>();
foreach (var item in varData)
{
tempLnq = new FM_InstitutionProcessPointDept();
tempLnq.PersonnelType = item.PersonnelType;
tempLnq.Personnel = item.Personnel;
tempLnq.BillNo = item.BillNo;
listPoint.Add(tempLnq);
}
ctx.FM_InstitutionProcessPointDept.InsertAllOnSubmit(listPoint);
}
ctx.SubmitChanges();
serverBill.DestroyMessage(institution.BillNo);
serverBill.SendNewFlowMessage(institution.BillNo,
string.Format("{0}号文件审查流程已提交，请等待上级审核", institution.BillNo),
BillFlowMessage_ReceivedUserType.角色, serverBill.GetSuperior(CE_RoleStyleType.级领导, BasicInfo.LoginID));
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
