/// <summary>
/// 刷新DataGridView
/// </summary>
void RefreshDataGridView()
{
DataTable dt = m_findSellIn.GetAllBill(CE_MarketingType.入库.ToString(),
dateTimePicker1.Value.ToShortDateString(),
dateTimePicker2.Value.ToShortDateString(),
cmbDJ_ZT.Text,
out m_err);
if (dt == null)
{
MessageDialog.ShowErrorMessage(m_err);
return;
}
dgv_Show.DataSource = dt;
string error = null;
Hashtable hsTable = new Hashtable();
hsTable.Add("@BillNo", DBNull.Value);
DataTable tempTable = GlobalObject.DatabaseServer.QueryInfoPro("S_Marketing_GreenLightInfo", hsTable, out error);
_List_BillNo = DataSetHelper.ColumnsToList_Distinct(tempTable, "单据号");
}
bool frm_CommonProcessSubmit(CustomFlowForm form, string advise)
{
FM_InstitutionProcess lnqProcess = (FM_InstitutionProcess)form.ResultInfo;
if (!CheckData(lnqProcess))
{
return(false);
}
MessageDialog.ShowPromptMessage("请选择相关部门");
FormDataTableCheck frmCheck = new FormDataTableCheck(UniversalFunction.GetAllDeptInfo());
if (frmCheck.ShowDialog() == DialogResult.OK)
{
List <string> list = DataSetHelper.ColumnsToList_Distinct(frmCheck._DtResult, "部门代码");
if (!m_serverInstitution.AddInfo(lnqProcess, list, out m_strErr))
{
MessageDialog.ShowPromptMessage(m_strErr);
return(false);
}
}
else
{
MessageDialog.ShowPromptMessage("请选择相关部门");
return(false);
}
return(true);
}
private void btnCollect_Click(object sender, EventArgs e)
{
try
{
if (cmbYear.Text.Trim().Length == 0)
{
throw new Exception("请选择【计划年份】");
}
FormDataTableCheck frm = new FormDataTableCheck(_ServiceSurvey.GetBillInfo_Year(Convert.ToInt32(cmbYear.Text)));
frm._BlDateTimeControlShow = false;
frm._BlIsCheckBox = true;
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm._DtResult != null && frm._DtResult.Rows.Count > 0)
{
List <string> lstBillNo = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");
_ServiceCollect.GenerateCollectPlan_Year(lstBillNo, Convert.ToInt32(cmbYear.Text));
RefreshViewCourse(CE_HR_Train_PlanType.年度培训计划, Convert.ToInt32(cmbYear.Text), null);
}
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
public List <string> GetCourse_User(int courseID)
{
string error = null;
Hashtable hsTable = new Hashtable();
hsTable.Add("@CourseID", courseID);
DataTable dtTemp = GlobalObject.DatabaseServer.QueryInfoPro("HR_Train_GetCourseUser", hsTable, out error);
return(DataSetHelper.ColumnsToList_Distinct(dtTemp, "WorkID"));
}
private void btnBenchCreate_Click(object sender, EventArgs e)
{
try
{
if (cmbBillType.Text.Trim().Length > 0)
{
DataTable dataSource = m_serviceOutPut.GetReferenceInfo(cmbBillType.Text,
txtApplyingDepartment.Tag == null ? null : txtApplyingDepartment.Tag.ToString(), chbIsRepeat.Checked);
FormDataTableCheck frm = new FormDataTableCheck(dataSource);
frm._BlDateTimeControlShow = false;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> listTemp = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");
string deptCode = "";
m_listViewDetail = m_serviceOutPut.GetReferenceListViewDetail(txtBillNo.Text, listTemp, chbIsRepeat.Checked, out deptCode);
if (m_listViewDetail != null)
{
txtApplyingDepartment.Text = UniversalFunction.GetDeptName(deptCode);
txtApplyingDepartment.Tag = deptCode;
List <Business_WarehouseOutPut_Requisition> listRequisition =
m_serviceRequistion.GetListBillInfo(m_listViewDetail.Select(k => k.关联业务).Distinct().ToList());
cmbTypeDetail.DataSource = listRequisition.Select(k => k.BillTypeDetail).Distinct().ToList();
m_serverProductCode.InsertChangeProductCodesBillNo(listRequisition.Select(k => k.BillNo).ToList(), txtBillNo.Text);
customDataGridView1.Rows.Clear();
RefreshDataGridView(m_listViewDetail);
}
}
cmbBillType.Enabled = customDataGridView1.Rows.Count > 0 ? false : true;
}
else
{
MessageDialog.ShowPromptMessage("请选择【业务类型】");
return;
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
private void btnSetUser_Click(object sender, EventArgs e)
{
if (txtCourse.Text.Trim().Length == 0)
{
MessageDialog.ShowPromptMessage("请选择【课程】");
return;
}
FormDataTableCheck frm = new FormDataTableCheck(_ServiceCollect.GetUserInfo(btnCourse.Tag.ToString()));
frm._BlDateTimeControlShow = false;
frm._BlIsCheckBox = true;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> lstWork = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "工号");
btnSetUser.Tag = lstWork;
}
}
private void btnBenchCreate_Click(object sender, EventArgs e)
{
try
{
if (cmbBillType.Text.Trim().Length > 0)
{
switch (GlobalObject.GeneralFunction.StringConvertToEnum <CE_InPutBusinessType>(cmbBillType.Text))
{
case CE_InPutBusinessType.生产采购:
case CE_InPutBusinessType.普通采购:
case CE_InPutBusinessType.委外采购:
case CE_InPutBusinessType.样品采购:
IQueryable <View_B_OrderFormInfo> findOrderFormInfo;
IOrderFormInfoServer orderFormServer = ServerModule.ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
if (!orderFormServer.GetAllOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, out findOrderFormInfo, out m_strError))
{
MessageDialog.ShowErrorMessage(m_strError);
return;
}
DataTable dataSource = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormInfo>(findOrderFormInfo);
FormDataTableCheck frm = new FormDataTableCheck(dataSource);
frm._BlDateTimeControlShow = false;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> listTemp = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "订单号");
m_listViewDetail = m_serviceRequistion.GetListViewDetail_OrderForm(txtBillNo.Text, listTemp);
RefreshDataGridView(m_listViewDetail);
}
foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
{
((DataGridViewTextBoxShowCell)dgvr.Cells["图号型号"]).m_EndSql =
" and 序号 in ( select GoodsID from B_OrderFormGoods where OrderFormNumber = '"
+ dgvr.Cells["关联业务"].Value.ToString() + "')";
((DataGridViewTextBoxShowCell)dgvr.Cells["批次号"]).ReadOnly = true;
((DataGridViewTextBoxShowCell)dgvr.Cells["供应商"]).ReadOnly = true;
}
break;
default:
break;
}
cmbBillType.Enabled = customDataGridView1.Rows.Count > 0 ? false : true;
}
else
{
MessageDialog.ShowPromptMessage("请选择【业务类型】");
return;
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
public static DataTable BillInfoShowFilter(DataTable billInfo, string billColumnsName)
{
if (billInfo == null)
{
return(null);
}
billInfo.AcceptChanges();
string error = null;
string strBillNo = "";
DataTable resultTable = new DataTable();
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
var varData = from a in ctx.Business_Base_BillNoFilterTemp
select a;
ctx.Business_Base_BillNoFilterTemp.DeleteAllOnSubmit(varData);
List <string> colList = DataSetHelper.ColumnsToList_Distinct(billInfo, billColumnsName);
for (int i = 0; i < colList.Count; i++)
{
Business_Base_BillNoFilterTemp tempLnq = new Business_Base_BillNoFilterTemp();
tempLnq.ID = Guid.NewGuid();
tempLnq.BillNo = colList[i].ToString();
ctx.Business_Base_BillNoFilterTemp.InsertOnSubmit(tempLnq);
}
ctx.SubmitChanges();
Hashtable hsTable = new Hashtable();
hsTable.Add("@WorkID", BasicInfo.LoginID);
DataTable tempTable = GlobalObject.DatabaseServer.QueryInfoPro("Business_Base_BillInfoShowFilter", hsTable, out error);
var varTemp = from a in ctx.Business_Base_BillNoFilterTemp
select a;
if (varTemp.Count() == 0)
{
billInfo.Clear();
resultTable = billInfo;
}
else
{
foreach (var item in varTemp)
{
strBillNo += "'" + item.BillNo + "',";
}
strBillNo = strBillNo.Substring(0, strBillNo.Length - 1);
resultTable = DataSetHelper.SiftDataTable(billInfo, billColumnsName + " in (" + strBillNo + ")", out error);
}
return(resultTable);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void InsertInfoExcel(string billNo, DataTable infoTable)
{
IMaterialRequisitionServer billServer = ServerModuleFactory.GetServerModule <IMaterialRequisitionServer>();
BillNumberControl billNoControl = new BillNumberControl("领料单", billServer);
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
IStoreServer storeService = ServerModuleFactory.GetServerModule <IStoreServer>();
try
{
List <string> lstStorage = new List <string>();
if (infoTable.Columns.Contains("库房"))
{
lstStorage = DataSetHelper.ColumnsToList_Distinct(infoTable, "库房");
foreach (string storage in lstStorage)
{
string temp = UniversalFunction.GetStorageID(storage);
if (temp.Trim().Length == 0)
{
throw new Exception("【库房名称】：" + storage + "有误， 无法匹配到库房ID");
}
}
}
if (!infoTable.Columns.Contains("物品ID"))
{
infoTable.Columns.Add("物品ID");
foreach (DataRow dr in infoTable.Rows)
{
int goodsID = UniversalFunction.GetGoodsID(dr["图号型号"] == null ? "" : dr["图号型号"].ToString(),
dr["物品名称"] == null ? "" : dr["物品名称"].ToString(),
dr["规格"] == null ? "" : dr["规格"].ToString());
if (goodsID == 0)
{
throw new Exception(string.Format("【图号型号】：{0} 【物品名称】：{1} 【规格】：{2}有误，" +
" 无法匹配到物品ID", dr["图号型号"], dr["物品名称"], dr["规格"]));
}
dr["物品ID"] = goodsID;
}
}
var varData = from a in ctx.S_MaterialRequisition
where a.Bill_ID == billNo
select a;
if (varData.Count() != 1)
{
throw new Exception("无法获取【单据号】： " + billNo + " 的基本信息");
}
S_MaterialRequisition requisition = varData.Single();
if (BillIsFinish(ctx, requisition.Bill_ID))
{
throw new Exception("单据已完成，无法进行操作");
}
if (lstStorage.Count == 0)
{
lstStorage.Add(UniversalFunction.GetStorageName(requisition.StorageID));
}
foreach (string storage in lstStorage)
{
DataTable tempTable = infoTable;
if (lstStorage.Count > 1)
{
tempTable = DataSetHelper.SiftDataTable(infoTable, "库房 = '" + storage + "'");
}
string tempBillNo = "";
string storageID = UniversalFunction.GetStorageID(storage);
if (requisition.StorageID != storageID)
{
S_MaterialRequisition tempRequisition = new S_MaterialRequisition();
tempBillNo = billNoControl.GetNewBillNo(ctx);
tempRequisition.Bill_ID = tempBillNo;
tempRequisition.AssociatedBillNo = requisition.AssociatedBillNo;
tempRequisition.AssociatedBillType = requisition.AssociatedBillType;
tempRequisition.AuthorizeDate = requisition.AuthorizeDate;
tempRequisition.AuthorizePersonnel = requisition.AuthorizePersonnel;
tempRequisition.Bill_Time = requisition.Bill_Time;
tempRequisition.BillStatus = requisition.BillStatus;
tempRequisition.Department = requisition.Department;
tempRequisition.DepartmentDirector = requisition.DepartmentDirector;
tempRequisition.DepotManager = requisition.DepotManager;
tempRequisition.FetchCount = requisition.FetchCount;
tempRequisition.FetchType = requisition.FetchType;
tempRequisition.FillInPersonnel = requisition.FillInPersonnel;
tempRequisition.FillInPersonnelCode = requisition.FillInPersonnelCode;
tempRequisition.OutDepotDate = requisition.OutDepotDate;
tempRequisition.ProductType = requisition.ProductType;
tempRequisition.PurposeCode = requisition.PurposeCode;
tempRequisition.Remark = requisition.Remark;
tempRequisition.StorageID = storageID;
tempRequisition.TechnologistDate = requisition.TechnologistDate;
tempRequisition.TechnologistPersonnel = requisition.TechnologistPersonnel;
ctx.S_MaterialRequisition.InsertOnSubmit(tempRequisition);
ctx.SubmitChanges();
}
else
{
tempBillNo = billNo;
}
foreach (DataRow dr in tempTable.Rows)
{
S_MaterialRequisitionGoods goodsInfo = new S_MaterialRequisitionGoods();
goodsInfo.RequestCount = dr["数量"] == null ? 0 : Convert.ToDecimal(dr["数量"]);
goodsInfo.BatchNo = dr["批次号"] == null ? "" : dr["批次号"].ToString();
if (dr["物品ID"] == null || Convert.ToInt32(dr["物品ID"]) == 0)
{
throw new Exception("【物品ID】无效");
}
goodsInfo.GoodsID = Convert.ToInt32(dr["物品ID"]);
goodsInfo.Bill_ID = tempBillNo;
StoreQueryCondition condition = new StoreQueryCondition();
condition.BatchNo = goodsInfo.BatchNo;
condition.GoodsID = goodsInfo.GoodsID;
condition.StorageID = storageID;
S_Stock stockInfo = storeService.GetStockInfo(condition);
if (stockInfo == null)
{
throw new Exception(string.Format("【物品ID】：{0} 【批次号】：{1} 【库房】：{2} 未找到匹配的库存记录",
goodsInfo.GoodsID, goodsInfo.BatchNo, storage));
}
goodsInfo.ProviderCode = stockInfo.Provider;
goodsInfo.BasicCount = 0;
goodsInfo.Remark = "由Excel导入";
goodsInfo.RepairStatus = null;
goodsInfo.RealCount = goodsInfo.RequestCount;
goodsInfo.ShowPosition = 1;
ctx.S_MaterialRequisitionGoods.InsertOnSubmit(goodsInfo);
ctx.SubmitChanges();
}
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
throw new Exception(ex.Message);
}
}
private void btnMaterialsTransfer_Click(object sender, EventArgs e)
{
if (m_lnqWSCode == null)
{
return;
}
FormDataTableCheck frm =
new FormDataTableCheck(m_serverMaterials.GetMaterialsTransferInfo(m_lnqWSCode.WSCode));
frm.OnFormDataTableCheckFind += new GlobalObject.DelegateCollection.FormDataTableCheckFindDelegate(frm_OnFormDataTableCheckFind);
frm._BlDateTimeControlShow = true;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> listRequisition = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");
DataTable tempTable =
m_serverMaterials.SumMaterialsTransferGoods(listRequisition,
(int)CE_SubsidiaryOperationType.物料转换后, (int)CE_SubsidiaryOperationType.领料退库,
m_lnqWSCode.WSCode);
foreach (DataRow dr in tempTable.Rows)
{
S_MaterialListReturnedInTheDepot goods = new S_MaterialListReturnedInTheDepot();
goods.Bill_ID = m_billNo;
goods.GoodsID = Convert.ToInt32(dr["物品ID"]);
StoreQueryCondition condition = new StoreQueryCondition();
condition.GoodsID = Convert.ToInt32(txtCode.Tag);
condition.BatchNo = dr["批次号"].ToString();
condition.StorageID = m_strStorage;
S_Stock tempStock = m_serverStock.GetStockInfo(condition);
if (tempStock != null)
{
goods.Provider = tempStock.Provider;
goods.ProviderBatchNo = tempStock.ProviderBatchNo;
}
else
{
goods.Provider = "";
goods.ProviderBatchNo = "";
}
goods.BatchNo = dr["批次号"].ToString();
goods.ReturnedAmount = Convert.ToDecimal(dr["数量"]);
goods.Remark = txtRemark.Text;
goods.ShelfArea = "";
goods.ColumnNumber = "";
goods.LayerNumber = "";
//产品状态 设置 2012.3.30 by cjb
if (cmbProductStatus.Text.Trim() != "")
{
if (cmbProductStatus.Text.Trim() == "已返修")
{
goods.RepairStatus = true;
}
else
{
goods.RepairStatus = false;
}
}
if (!m_goodsServer.AddGoods(goods, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
return;
}
}
m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
RefreshDataGridView(m_queryGoodsInfo);
}
}
public void InputQuestionsBank(int courseID, DataTable questionsTable)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
try
{
questionsTable = DataSetHelper.OrderBy(questionsTable, "考题ID,选项");
List <string> lstQuestions = DataSetHelper.ColumnsToList_Distinct(questionsTable, "考题ID");
foreach (string questionsID in lstQuestions)
{
DataTable tempQuestions = DataSetHelper.SiftDataTable(questionsTable, "考题ID = '" + questionsID + "'");
if (tempQuestions.Rows.Count > 0)
{
CE_HR_Train_QuesitonsType quesType =
GeneralFunction.StringConvertToEnum <CE_HR_Train_QuesitonsType>(tempQuestions.Rows[0]["考题类型"].ToString());
HR_Train_QuestionBank bank = new HR_Train_QuestionBank();
switch (quesType)
{
case CE_HR_Train_QuesitonsType.判断题:
bank.Answer = tempQuestions.Rows[0]["答案"].ToString().ToUpper();
bank.CourseID = courseID;
bank.ID = Guid.NewGuid();
bank.Questions = tempQuestions.Rows[0]["考题内容"].ToString();
bank.Type = tempQuestions.Rows[0]["考题类型"].ToString();
ctx.HR_Train_QuestionBank.InsertOnSubmit(bank);
break;
case CE_HR_Train_QuesitonsType.单选题:
case CE_HR_Train_QuesitonsType.多选题:
Guid guid = Guid.NewGuid();
bank.Answer = tempQuestions.Rows[0]["答案"].ToString().ToUpper();
bank.CourseID = courseID;
bank.ID = guid;
bank.Questions = tempQuestions.Rows[0]["考题内容"].ToString();
bank.Type = tempQuestions.Rows[0]["考题类型"].ToString();
ctx.HR_Train_QuestionBank.InsertOnSubmit(bank);
ctx.SubmitChanges();
foreach (DataRow dr in tempQuestions.Rows)
{
HR_Train_QuestionBank_Option option = new HR_Train_QuestionBank_Option();
option.OptionContent = dr["选项内容"].ToString();
option.OptionTag = dr["选项"].ToString().ToUpper();
option.QuestionID = guid;
ctx.HR_Train_QuestionBank_Option.InsertOnSubmit(option);
}
ctx.SubmitChanges();
break;
default:
break;
}
}
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
throw new Exception(ex.Message);
}
}