/// <summary>
///获得一条HIS产品记录
/// </summary>
/// <param name="productcode"></param>
/// <returns></returns>
public Gpo_Product_MapModel GetGpoMapModelById(string strId)
{
StringBuilder strsql = new StringBuilder("SELECT *");
strsql.Append(" from GPO_PRODUCT_MAP where ID = '" + strId + "'");
DataTable dt = null;
Gpo_Product_MapModel product_MapModel = null;
try
{
dt = DbFacade.SQLExecuteDataTable(strsql.ToString());
if (dt != null && dt.Rows.Count > 0)
{
product_MapModel = GetModelByRow(dt.Rows[0]);
}
}
catch (Exception e)
{
throw e;
return(null);
}
return(product_MapModel);
}
/// <summary>
/// 匹配
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnMap_Click(object sender, EventArgs e)
{
if (dgvEmedProduct.CurrentRow != null && dgvERPdprolist.CurrentRow != null && dgvERPdprolist.CurrentRow.Cells["IsMap"].Value.ToString() == "未匹配")
{
Gpo_Product_MapModel model = new Gpo_Product_MapModel();
model.ProductID = dgvEmedProduct.CurrentRow.Cells["product_id"].Value.ToString().Trim();
model.Map_Orgid = ClientSession.GetInstance().CurrentUser.UserOrg.Reg_org_id;
model.Factory_Id = dgvEmedProduct.CurrentRow.Cells["factory_id"].Value.ToString().Trim();
model.Sender_Id = dgvEmedProduct.CurrentRow.Cells["sender_id"].Value.ToString().Trim();
model.ProductCode = dgvERPdprolist.CurrentRow.Cells["product_code"].Value.ToString().Trim();
model.CommonName = dgvERPdprolist.CurrentRow.Cells["product_name"].Value.ToString().Trim();
model.Mode_Name = dgvERPdprolist.CurrentRow.Cells["medical_mode"].Value.ToString().Trim();
model.Stand_Rate = dgvERPdprolist.CurrentRow.Cells["stand_rate"].Value.ToString().Trim();
model.Spec_Unit = dgvERPdprolist.CurrentRow.Cells["spec_unit"].Value.ToString().Trim(); //包装单位
model.Medical_Spec = dgvERPdprolist.CurrentRow.Cells["medical_spec"].Value.ToString().Trim(); //规格名称
model.Factory_Code = dgvERPdprolist.CurrentRow.Cells["factory_code"].Value.ToString().Trim();
model.Factory_Name = dgvERPdprolist.CurrentRow.Cells["factory_name"].Value.ToString().Trim();
model.ProcessFlag = "1";
model.IsMap = "1";
if (!hashMap.Contains(model.ProductCode))
{
hashMap.Add(model.ProductCode, model);
dtNotMap.Select("product_code ='" + dgvERPdprolist.CurrentRow.Cells["product_code"].Value + "'")[0]["IsMap"] = "已匹配";
bSave = false;
}
}
}
protected Gpo_Product_MapModel GetModelByRow(DataRow row)
{
//定义采购申请主表实体类
Gpo_Product_MapModel Model = new Gpo_Product_MapModel();
if (row == null)
{
return(null);
}
Model.ProductCode = ComUtil.getStringValue(row, "PRODUCT_CODE", "");
Model.Mode_ID = ComUtil.getStringValue(row, "MODE_ID", "");
Model.Mode_Name = ComUtil.getStringValue(row, "MODE_NAME", "");
Model.Product_Name = ComUtil.getStringValue(row, "PRODUCT_NAME", "");
Model.CommonName = ComUtil.getStringValue(row, "COMMON_NAME", "");
Model.Package_Rate = ComUtil.getStringValue(row, "PACKAGE_RATE", "");
Model.Factory_Name = ComUtil.getStringValue(row, "FACTORY_NAME", "");
Model.Remark = ComUtil.getStringValue(row, "REMARK", "");
Model.Medical_Spec_Id = ComUtil.getStringValue(row, "MEDICAL_SPEC_ID", "");
Model.Medical_Spec = ComUtil.getStringValue(row, "MEDICAL_SPEC", "");
Model.Spec_Unit = ComUtil.getStringValue(row, "SPEC_UNIT", "");
Model.Spec_Unit_Id = ComUtil.getStringValue(row, "SPEC_UNIT_ID", "");
Model.Stand_Rate = ComUtil.getStringValue(row, "STAND_RATE", "");
Model.Use_Unit = ComUtil.getStringValue(row, "USE_UNIT", "");
Model.Factory_Code = ComUtil.getStringValue(row, "FACTORY_CODE", "");
Model.UseUnitCode = ComUtil.getStringValue(row, "USE_UNIT", "");
Model.ProcessFlag = ComUtil.getStringValue(row, "PROCESS_FLAG", "");
return(Model);
}
private void ShowHISItemInfo(Gpo_Product_MapModel promapintance)
{
this.txtCode.Text = promapintance.ProductCode;
this.txtName.Text = promapintance.Product_Name; //产品名称
this.txtCommonName.Text = promapintance.CommonName; //通用名称
this.txtModeCode.Text = promapintance.Mode_ID;
this.txtModeName.Text = promapintance.Mode_Name;
this.txtSpecCode.Text = promapintance.Medical_Spec_Id;
this.txtSpecName.Text = promapintance.Medical_Spec;
this.txtStandRate.Text = promapintance.Stand_Rate;
this.txtPackageRate.Text = promapintance.Package_Rate;
this.txtUseUnitCode.Text = promapintance.UseUnitCode;
this.txtUseUnit.Text = promapintance.Use_Unit;
this.txtSpecUnitCode.Text = promapintance.Spec_Unit_Id;
this.txtSpecUnit.Text = promapintance.Spec_Unit;
this.txtProducerCode.Text = promapintance.Factory_Code;
this.txtProducer.Text = promapintance.Factory_Name;
this.txtRemark.Text = promapintance.Remark;
if (promapintance.ProcessFlag == "1")
{
this.cbxRead.Checked = true;
}
else
{
this.cbxRead.Checked = false;
}
}
private void ShowHISItemInfo(Gpo_Product_MapModel promapintance)
{
//this.txtCode.Text = promapintance.ProductCode;
//this.txtName.Text = promapintance.Product_Name; //产品名称
//this.txtCommonName.Text = promapintance.CommonName; //通用名称
//this.txtBrand.Text = promapintance.Mode_ID;
//this.txtModeName.Text = promapintance.Mode_Name;
//this.txtSpecCode.Text = promapintance.Medical_Spec_Id;
//this.txtSpecName.Text = promapintance.Medical_Spec;
//this.txtStandRate.Text = promapintance.Stand_Rate;
//this.txtPackageRate.Text = promapintance.Package_Rate;
//this.txtUseUnitCode.Text = promapintance.UseUnitCode;
//this.txtUseUnit.Text = promapintance.Use_Unit;
//this.txtSpecUnitCode.Text = promapintance.Spec_Unit_Id;
//this.txtSpecUnit.Text = promapintance.Spec_Unit;
//this.txtProducerCode.Text = promapintance.Factory_Code;
//this.txtProducer.Text = promapintance.Factory_Name;
this.txtCode.Text = promapintance.ProductCode;
this.txtCommonName.Text = promapintance.CommonName;
this.txtName.Text = promapintance.Product_Name;
this.teCName.Text = promapintance.CommerceName;
this.txtBrand.Text = promapintance.Brand;
this.teMODELID.Text = promapintance.Mode_ID;
this.txtModeName.Text = promapintance.Mode_Name;
this.teSPEC_ID.Text = promapintance.Spec_Unit_Id;
this.txtSpecName.Text = promapintance.Spec_Unit;
this.teBASEMEASURE.Text = promapintance.Base_measure;
this.teBASEMEASURESPEC.Text = promapintance.Base_measure_spec;
this.teBASEMEASUREMATE.Text = promapintance.Base_measure_mate;
this.teSTANDRATE.Text = promapintance.Stand_Rate;
this.teFACTORYCODE.Text = promapintance.Factory_Code;
this.teFACTORYName.Text = promapintance.Factory_Name;
this.teSALERNAME.Text = promapintance.Saler_Name;
this.teSALERCODE.Text = promapintance.Saler_Code;
this.teSENDERCODE.Text = promapintance.Sender_Code;
this.teSENDERNAME.Text = promapintance.Sender_Name;
this.teSTOCKID.Text = promapintance.Stock_Id;
this.teSTOCKNAME.Text = promapintance.Stock_Name;
//productmapitemOper.User = CurrentUser;
this.txtRemark.Text = promapintance.Remark;
if (promapintance.ProcessFlag == "1")
{
this.cbxRead.Checked = true;
}
else
{
this.cbxRead.Checked = false;
}
}
//修改操作
private void SaveUpdate(Gpo_Product_MapModel productmapitem)
{
issaved = true;
ProductCodeCompareBLL.GetInstance("ClientDB").Edit_Gpo_Product_Map(productmapitem);
InitCommListDT();
Filter();
ComUtil.MsgBox("保存成功！");
}
//修改操作
private void SaveUpdate(Gpo_Product_MapModel productmapitem)
{
issaved = true;
ProductCodeCompareBLL.GetInstance().Edit_Gpo_Product_Map(productmapitem);
InitCommListDT();
Filter();
XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 获取对接产品对照表SQL
/// </summary>
/// <returns></returns>
private string GetGpo_Produce_MapListSql(Gpo_Product_MapModel input)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append(" SELECT Id, map_orgtype, map_orgid, hit_comm_id,");
sqlstr.Append("product_id, data_product_id, saler_id, sender_id,");
sqlstr.Append("enter_id, medical_code, product_code, common_name,");
sqlstr.Append("product_name,");
sqlstr.Append("COMMON_NAME + '(' + product_name + ')' As HisProduct_Name, ");
sqlstr.Append("mode_id, mode_name, medical_spec_id, medical_spec, stand_rate, use_unit_id, use_unit,");
sqlstr.Append("spec_unit_id, spec_unit, permit_no, factory_code, factory_name, saler_code, saler_name,");
sqlstr.Append("sender_code, sender_name, category_id, category_name, stock_id, stock_name, package_rate,");
sqlstr.Append("modify_userid, modify_date, process_flag, sync_state, remark, factory_id,");
sqlstr.Append("case when IsMap = '1' then '已匹配' else '未匹配' end As Is_Map,");
sqlstr.Append("case when process_flag = '1' then '已处理'else '未处理' end As Is_Process_flag");
sqlstr.Append(" From GPO_PRODUCT_MAP_VIEW");
sqlstr.Append(" Where 1=1");
if (!string.IsNullOrEmpty(input.IsMap))
{
if (input.IsMap == "0")
{
sqlstr.Append(" And (IsMap=:IsMap Or IsMap is null)");
}
else
{
sqlstr.Append(" And IsMap=:IsMap");
}
}
if (!string.IsNullOrEmpty(input.ProcessFlag))
{
if (input.ProcessFlag == "0")
{
sqlstr.Append(" And (PROCESS_FLAG=:PROCESS_FLAG Or PROCESS_FLAG Is null)");
}
else
{
sqlstr.Append(" And PROCESS_FLAG=:PROCESS_FLAG");
}
}
if (!string.IsNullOrEmpty(input.MedicaName))
{
sqlstr.Append(" AND (COMMON_NAME & PRODUCT_NAME) LIKE :MedicaName");
}
if (!string.IsNullOrEmpty(input.FactoryName))
{
sqlstr.Append(" And FACTORY_NAME Like :FACTORY_NAME");
}
if (!string.IsNullOrEmpty(input.ProductCode))
{
sqlstr.Append(" And PRODUCT_CODE Like :PRODUCT_CODE");
}
sqlstr.Append(" Order By id");
return(sqlstr.ToString());
}
//获取新增产品对照表语句
private string InsertProductComprisonSql(Gpo_Product_MapModel model, string orgid)
{
//HIS单位转换比
string standRate;
if (string.IsNullOrEmpty(model.Stand_Rate))
{
standRate = "1";
}
else
{
standRate = model.Stand_Rate;
}
StringBuilder strsql = new StringBuilder();
strsql.Append("Insert Into Gpo_Product_Map");
strsql.Append("(ID,MAP_ORGID,PRODUCT_CODE,MEDICAL_CODE,COMMON_NAME,PRODUCT_NAME,MODE_ID,MODE_NAME,MEDICAL_SPEC_ID,MEDICAL_SPEC,USE_UNIT_ID,USE_UNIT,SPEC_UNIT_ID,SPEC_UNIT,STAND_RATE,FACTORY_CODE,FACTORY_NAME,product_id,data_product_id,MAP_ORGTYPE,PERMIT_NO,SALER_CODE,SALER_NAME,SENDER_CODE,SENDER_NAME,CATEGORY_ID,CATEGORY_NAME,STOCK_ID,STOCK_NAME,PACKAGE_RATE,SYNC_STATE)");
strsql.Append(" Values");
strsql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}','{16}','{17}','{18}','1','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}',{28},'0')",
base.GetGlobalId(),
orgid,
model.ProductCode,
model.MedicalCode,
model.CommonName,
model.Product_Name,
model.Mode_ID,
model.Mode_Name,
model.Medical_Spec_Id,
model.Medical_Spec,
model.UseUnitCode,
model.Use_Unit,
model.Spec_Unit_Id,
model.Spec_Unit,
standRate,
model.Factory_Code,
model.Factory_Name,
model.ProductID,
model.DataProductID,
model.Permit_No,
model.Saler_Code,
model.Saler_Name,
model.Sender_Code,
model.Sender_Name,
model.Category_Id,
model.Category_Name,
model.Stock_Id,
model.Stock_Name,
model.Package_Rate
);
return(strsql.ToString());
}
//获取修改产品对照表语句
private string UpdateProductComprisonSql(Gpo_Product_MapModel model, string orgid)
{
StringBuilder sqlstr = new StringBuilder("Update GPO_PRODUCT_MAP Set ");
sqlstr.AppendFormat("MEDICAL_CODE='{0}'", model.MedicalCode);
sqlstr.AppendFormat(",COMMON_NAME='{0}'", model.CommonName);
sqlstr.AppendFormat(",PRODUCT_NAME='{0}'", model.Product_Name);
sqlstr.AppendFormat(",MODE_ID='{0}'", model.Mode_ID);
sqlstr.AppendFormat(",MODE_NAME='{0}'", model.Mode_Name);
sqlstr.AppendFormat(",MEDICAL_SPEC_ID='{0}'", model.Medical_Spec_Id);
sqlstr.AppendFormat(",MEDICAL_SPEC='{0}'", model.Medical_Spec);
sqlstr.AppendFormat(",USE_UNIT_ID='{0}'", model.UseUnitCode);
sqlstr.AppendFormat(",USE_UNIT='{0}'", model.Use_Unit);
sqlstr.AppendFormat(",SPEC_UNIT_ID='{0}'", model.Spec_Unit_Id);
sqlstr.AppendFormat(",SPEC_UNIT='{0}'", model.Spec_Unit);
//HIS单位转换比
string standRate;
if (string.IsNullOrEmpty(model.Stand_Rate))
{
standRate = "1";
}
else
{
standRate = model.Stand_Rate;
}
sqlstr.AppendFormat(",STAND_RATE={0}", standRate);
sqlstr.AppendFormat(",FACTORY_CODE='{0}'", model.Factory_Code);
sqlstr.AppendFormat(",FACTORY_NAME='{0}'", model.Factory_Name);
sqlstr.AppendFormat(",product_id='{0}'", model.ProductID);
sqlstr.AppendFormat(",data_product_id='{0}'", model.DataProductID);
sqlstr.AppendFormat(",PERMIT_NO='{0}'", model.Permit_No);
sqlstr.AppendFormat(",SALER_CODE='{0}'", model.Saler_Code);
sqlstr.AppendFormat(",SALER_NAME='{0}'", model.Saler_Name);
sqlstr.AppendFormat(",SENDER_CODE='{0}'", model.Sender_Code);
sqlstr.AppendFormat(",SENDER_NAME='{0}'", model.Sender_Name);
sqlstr.AppendFormat(",CATEGORY_ID='{0}'", model.Category_Id);
sqlstr.AppendFormat(",CATEGORY_NAME='{0}'", model.Category_Name);
sqlstr.AppendFormat(",STOCK_ID='{0}'", model.Stock_Id);
sqlstr.AppendFormat(",STOCK_NAME='{0}'", model.Stock_Name);
sqlstr.AppendFormat(",PACKAGE_RATE={0}", model.Package_Rate);
sqlstr.Append(",SYNC_STATE='0'");
sqlstr.AppendFormat(" Where MAP_ORGID='{0}'", orgid);
sqlstr.AppendFormat(" And PRODUCT_CODE='{0}'", model.ProductCode);
return(sqlstr.ToString());
}
//获取新增SQL语句
public string CreateProductComprison(Gpo_Product_MapModel input, out string strID)
{
string id = base.GetGlobalId();
strID = id.ToString();
string buyerid = input.Map_Orgid;
string productid = input.ProductID;
string salerid = input.Saler_Id;
string senderid = input.Sender_Id;
string factoryid = input.Factory_Id;
string code = input.ProductCode;
string modecode = input.Mode_ID;
string modename = input.Mode_Name;
string name = input.Product_Name;
string Commonname = input.CommonName;
int packagerate = 1;
if (!string.IsNullOrEmpty(input.Package_Rate))
{
packagerate = int.Parse(input.Package_Rate);
}
string producer = input.Factory_Name;
string factory_Code = input.Factory_Code;
string remark = input.Remark;
string speccode = input.Medical_Spec_Id;
string specname = input.Medical_Spec;
string specunit = input.Spec_Unit;
string specunitcode = input.Spec_Unit_Id;
int standrate = 1;
if (!string.IsNullOrEmpty(input.Stand_Rate))
{
standrate = int.Parse(input.Stand_Rate);
}
string useunit = input.Use_Unit;
string useunitcode = input.UseUnitCode;
string read = input.ProcessFlag;
string ismap = input.IsMap;
StringBuilder sqlstr = new StringBuilder();
sqlstr.AppendFormat("insert into GPO_PRODUCT_MAP (ID,PRODUCT_ID,MAP_ORGID,MAP_ORGTYPE,FACTORY_ID,SALER_ID,SENDER_ID,SPEC_UNIT,PACKAGE_RATE,MODE_NAME,REMARK,SPEC_UNIT_ID,STAND_RATE,MODE_ID,FACTORY_NAME,FACTORY_CODE,USE_UNIT,USE_UNIT_ID,MEDICAL_SPEC,MEDICAL_SPEC_ID,PRODUCT_NAME,PRODUCT_CODE,SYNC_STATE,PROCESS_FLAG,IsMap,COMMON_NAME) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}', '{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}')", id, productid, buyerid, '2', factoryid, salerid, senderid, specunit, packagerate, modename, remark, specunitcode, standrate, modecode, producer, factory_Code, useunit, useunitcode, specname, speccode, name, code, '0', read, ismap, Commonname);
return(sqlstr.ToString());
}
/// <summary>
/// 获取对接产品对照表对象
/// </summary>
private Gpo_Product_MapModel GpoProductMapModel()
{
Gpo_Product_MapModel product_MapModel = new Gpo_Product_MapModel();
product_MapModel.FactoryName = this.tbxproducter.Text.Trim(); //生产企业
product_MapModel.MedicaName = this.tbxmedicalname.Text.Trim(); //药品名称
product_MapModel.IsMap = this.CmbIsMap.SelectedValue.ToString(); //匹配状态
product_MapModel.ProcessFlag = this.CmbProcessFlag.SelectedValue.ToString(); //处理状态
product_MapModel.ProductCode = this.txtHisCode.Text.Trim(); //HIS产品编码
return(product_MapModel);
}
/// <summary>
/// 查询 产品编码对照列表信息
/// </summary>
/// <param name="input">产品编码对照实体类</param>
/// <returns></returns>
public DataTable ProductCodeCompareList(Gpo_Product_MapModel input)
{
DataTable dt = null;
try
{
dt = dao.ProductCodeCompareList(input);
}
catch
{
throw;
}
return(dt);
}
/// <summary>
///获得一条HIS产品记录
/// </summary>
/// <param name="productcode"></param>
/// <returns></returns>
public Gpo_Product_MapModel GetGpoMapModelById(string strId)
{
Gpo_Product_MapModel product_MapModel = null;
try
{
product_MapModel = dao.GetGpoMapModelById(strId);
}
catch (Exception e)
{
throw e;
return(null);
}
return(product_MapModel);
}
//对接产品对照表 新增记录
public bool Add_Gpo_Product_Map(Gpo_Product_MapModel input, out string strID)
{
bool flag = false;
try
{
flag = dao.Add_Gpo_Product_Map(input, out strID);
}
catch (Exception ex)
{
throw ex;
return(false);
}
return(flag);
}
//对接产品对照表 修改记录
public bool Edit_Gpo_Product_Map(Gpo_Product_MapModel input)
{
bool flag = false;
try
{
flag = dao.Edit_Gpo_Product_Map(input);
}
catch (Exception ex)
{
throw ex;
return(false);
}
return(flag);
}
//对接产品对照表 修改记录
public bool Edit_Gpo_Product_Map(Gpo_Product_MapModel input)
{
bool flag = false;
try
{
DbFacade.SQLExecuteNonQuery(UpdateComparison(input));
}
catch (Exception ex)
{
throw ex;
flag = false;
}
return(flag);
}
//对接产品对照表 新增记录
public bool Add_Gpo_Product_Map(Gpo_Product_MapModel input, out string strID)
{
bool flag = false;
try
{
DbFacade.SQLExecuteNonQuery(CreateProductComprison(input, out strID));
}
catch (Exception ex)
{
throw ex;
flag = false;
}
return(flag);
}
//插入操作
private void SaveAdd(Gpo_Product_MapModel productmapitem)
{
bool flag = ProductCodeCompareBLL.GetInstance("ClientDB").JudgeHisProductCode(productmapitem.ProductCode);
if (flag == false)
{ //产品编码没有重复
ProductCodeCompareBLL.GetInstance("ClientDB").Add_Gpo_Product_Map(productmapitem, out strID);
InitCommListDT();
Filter();
issaved = true;
ComUtil.MsgBox("保存成功！");
}
else
{
ComUtil.MsgBox("该产品编码已存在！");
}
}
//插入操作
private void SaveAdd(Gpo_Product_MapModel productmapitem)
{
bool flag = ProductCodeCompareBLL.GetInstance().JudgeHisProductCode(productmapitem.ProductCode);
if (flag == false)
{ //产品编码没有重复
ProductCodeCompareBLL.GetInstance().Add_Gpo_Product_Map(productmapitem, out strID);
InitCommListDT();
Filter();
issaved = true;
XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("该产品编码已存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void ModifyLoadPage()
{
if (!string.IsNullOrEmpty(this.productid))
{
foreach (DataGridViewRow row in this.dgvComm.Rows)
{
if (row.Cells["PRODUCT_ID"].Value.ToString() == this.productid)
{
this.dgvComm.CurrentCell = this.dgvComm["MEDICAL_NAME", row.Index];
this.bindingSource2.DataSource = CompareDt.DefaultView;
CompareDt.DefaultView.RowFilter = "PRODUCT_ID ='" + row.Cells["PRODUCT_ID"].Value.ToString() + "'";
break;
}
}
}
Gpo_Product_MapModel productmapitem = ProductCodeCompareBLL.GetInstance("ClientDB").GetGpoMapModelById(this.strID);
ShowHISItemInfo(productmapitem);
}
//对接产品对照表 新增记录
public bool Add_Gpo_Product_Map(Gpo_Product_MapModel input, out string strID)
{
bool flag = false;
using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection()))
{
try
{
DbFacade.SQLExecuteNonQuery(CreateProductComprison(input, out strID));
flag = true;
DbFacade.CommitTransaction(dbTran);
}
catch (Exception ex)
{
DbFacade.RollbackTransaction(dbTran);
throw ex;
}
}
return(flag);
}
/// <summary>
///获得一条HIS产品记录
/// </summary>
/// <param name="productcode"></param>
/// <returns></returns>
public Gpo_Product_MapModel GetGpoMapModel(string productcode)
{
DataTable dt = null;
Gpo_Product_MapModel product_MapModel = null;
try
{
dt = DbFacade.SQLExecuteDataTable(GetHISItemByProductCode(productcode));
if (dt != null && dt.Rows.Count > 0)
{
product_MapModel = GetModelByRow(dt.Rows[0]);
}
}
catch (Exception e)
{
throw e;
return(null);
}
return(product_MapModel);
}
private void ModifyLoadPage()
{
if (!string.IsNullOrEmpty(this.productid))
{
for (int i = 0; i < this.gridView5.RowCount; i++)
{
DataRow drrow = gridView5.GetDataRow(i);
if (drrow["PROJECT_PROD_ID"].ToString() == this.productid && drrow["MODEL_ID"].ToString() == this.mODEL_ID && drrow["SPEC_ID"].ToString() == this.sPEC_ID)
{
this.gridView5.FocusedRowHandle = i;
this.bindingSource2.DataSource = CompareDt.DefaultView;
CompareDt.DefaultView.RowFilter = " PROJECT_PROD_ID ='" + drrow["PROJECT_PROD_ID"].ToString() + "' AND MODEL_ID = '" + drrow["MODEL_ID"].ToString() + " ' AND SPEC_ID = '" + drrow["SPEC_ID"].ToString() + "'";
break;
}
}
}
Gpo_Product_MapModel productmapitem = ProductCodeCompareBLL.GetInstance().GetGpoMapModelById(this.strID);
ShowHISItemInfo(productmapitem);
}
private void Save()
{
if (string.IsNullOrEmpty(txtCode.Text.Trim()) || string.IsNullOrEmpty(txtCommonName.Text.Trim()) || string.IsNullOrEmpty(txtModeName.Text.Trim()) || string.IsNullOrEmpty(txtSpecName.Text.Trim()) || string.IsNullOrEmpty(txtSpecUnit.Text.Trim()))
{
ComUtil.MsgBox("带 * 为必填项！");
}
else //if (issaved == false)
{
//定义对接产品对照表实体类
productmapitemOper = new Gpo_Product_MapModel();
LogedInUser CurrentUser = ClientSession.GetInstance().CurrentUser;
productmapitemOper.IsMap = "0";//未匹配
if (dgvProIDCompare.CurrentRow != null)
{
productmapitemOper.ProductID = this.dgvProIDCompare.CurrentRow.Cells["PRO_ID"].Value.ToString(); //产品ID
productmapitemOper.Map_Orgid = CurrentUser.UserOrg.Reg_org_id;
productmapitemOper.Sender_Id = this.dgvProIDCompare.CurrentRow.Cells["SenderId"].Value.ToString(); //配送企业ID
productmapitemOper.Factory_Id = this.dgvProIDCompare.CurrentRow.Cells["FactoryId"].Value.ToString(); //生产企业ID
productmapitemOper.IsMap = "1"; //已匹配
}
//转换字符
CharConvert();
productmapitemOper.ID = this.strID;
productmapitemOper.ProductCode = this.txtCode.Text;
productmapitemOper.CommonName = this.txtCommonName.Text;
productmapitemOper.Product_Name = this.txtName.Text;
productmapitemOper.Mode_ID = this.txtModeCode.Text;
productmapitemOper.Mode_Name = this.txtModeName.Text;
productmapitemOper.Medical_Spec_Id = this.txtSpecCode.Text;
productmapitemOper.Medical_Spec = this.txtSpecName.Text;
productmapitemOper.Stand_Rate = this.txtStandRate.Text;
productmapitemOper.Package_Rate = this.txtPackageRate.Text;
productmapitemOper.UseUnitCode = this.txtUseUnitCode.Text;
productmapitemOper.Use_Unit = this.txtUseUnit.Text;
productmapitemOper.Spec_Unit_Id = this.txtSpecUnitCode.Text;
productmapitemOper.Spec_Unit = this.txtSpecUnit.Text;
productmapitemOper.Factory_Code = this.txtProducerCode.Text;
productmapitemOper.Factory_Name = this.txtProducer.Text;
productmapitemOper.Remark = this.txtRemark.Text;
//是否阅读
if (this.cbxRead.Checked == true)
{
productmapitemOper.ProcessFlag = "1";
}
else
{
productmapitemOper.ProcessFlag = "0";
}
//判断是否作插入操作还是修改操作
if (IsAdd == true)
{
SaveAdd(productmapitemOper);
}
else if (IsAdd == false)
{
SaveUpdate(productmapitemOper);
}
}
}
private void UpdateDtCompare(Gpo_Product_MapModel productmapitemOper)
{
if (CommListDt != null)
{
DataColumn[] keys = new DataColumn[1];
DataColumn myColumn = new DataColumn();
keys[0] = this.dtCompare.Columns["ID"];
this.dtCompare.PrimaryKey = keys;
DataRow dr = dtCompare.Rows.Find(productmapitemOper.ID);
if (dr == null)
{
DataRow drnew = this.dtCompare.NewRow();
drnew["ID"] = productmapitemOper.ID;
drnew["PRODUCT_CODE"] = productmapitemOper.ProductCode;
drnew["COMMON_NAME"] = productmapitemOper.CommonName;
drnew["PRODUCT_NAME"] = productmapitemOper.Product_Name;
drnew["HISPRODUCT_NAME"] = productmapitemOper.CommonName + "(" + productmapitemOper.Product_Name + ")";
drnew["MODE_ID"] = productmapitemOper.Mode_ID;
drnew["MODE_NAME"] = productmapitemOper.Mode_Name;
drnew["MEDICAL_SPEC_ID"] = productmapitemOper.Medical_Spec_Id;
drnew["MEDICAL_SPEC"] = productmapitemOper.Medical_Spec;
if (!string.IsNullOrEmpty(productmapitemOper.Stand_Rate))
{
drnew["STAND_RATE"] = productmapitemOper.Stand_Rate;
}
if (!string.IsNullOrEmpty(productmapitemOper.Package_Rate))
{
drnew["PACKAGE_RATE"] = productmapitemOper.Package_Rate;
}
drnew["USE_UNIT_ID"] = productmapitemOper.UseUnitCode;
drnew["USE_UNIT"] = productmapitemOper.Use_Unit;
drnew["SPEC_UNIT_ID"] = productmapitemOper.Spec_Unit_Id;
drnew["SPEC_UNIT"] = productmapitemOper.Spec_Unit;
drnew["FACTORY_CODE"] = productmapitemOper.Factory_Code;
drnew["FACTORY_NAME"] = productmapitemOper.Factory_Name;
drnew["REMARK"] = productmapitemOper.Remark;
drnew["IsMap"] = productmapitemOper.IsMap;
if (productmapitemOper.IsMap.Equals("1"))
{
drnew["Is_Map"] = "已匹配";
drnew["PRODUCT_ID"] = productmapitemOper.ProductID;
}
else
{
drnew["Is_Map"] = "未匹配";
drnew["PRODUCT_ID"] = "";
}
drnew["PROCESS_FLAG"] = productmapitemOper.ProcessFlag;
if (productmapitemOper.ProcessFlag.Equals("1"))
{
drnew["Is_Process_flag"] = "已处理";
}
else
{
drnew["Is_Process_flag"] = "未处理";
}
dtCompare.Rows.Add(drnew);
}
else
{
dr["PRODUCT_CODE"] = productmapitemOper.ProductCode;
dr["COMMON_NAME"] = productmapitemOper.CommonName;
dr["PRODUCT_NAME"] = productmapitemOper.Product_Name;
dr["HISPRODUCT_NAME"] = productmapitemOper.CommonName + "(" + productmapitemOper.Product_Name + ")";
dr["MODE_ID"] = productmapitemOper.Mode_ID;
dr["MODE_NAME"] = productmapitemOper.Mode_Name;
dr["MEDICAL_SPEC_ID"] = productmapitemOper.Medical_Spec_Id;
dr["MEDICAL_SPEC"] = productmapitemOper.Medical_Spec;
if (!string.IsNullOrEmpty(productmapitemOper.Stand_Rate))
{
dr["STAND_RATE"] = productmapitemOper.Stand_Rate;
}
if (!string.IsNullOrEmpty(productmapitemOper.Package_Rate))
{
dr["PACKAGE_RATE"] = productmapitemOper.Package_Rate;
}
dr["USE_UNIT_ID"] = productmapitemOper.UseUnitCode;
dr["USE_UNIT"] = productmapitemOper.Use_Unit;
dr["SPEC_UNIT_ID"] = productmapitemOper.Spec_Unit_Id;
dr["SPEC_UNIT"] = productmapitemOper.Spec_Unit;
dr["FACTORY_CODE"] = productmapitemOper.Factory_Code;
dr["FACTORY_NAME"] = productmapitemOper.Factory_Name;
dr["REMARK"] = productmapitemOper.Remark;
dr["IsMap"] = productmapitemOper.IsMap;
if (productmapitemOper.IsMap.Equals("1"))
{
dr["Is_Map"] = "已匹配";
dr["PRODUCT_ID"] = productmapitemOper.ProductID;
}
else
{
dr["Is_Map"] = "未匹配";
dr["PRODUCT_ID"] = "";
}
dr["PROCESS_FLAG"] = productmapitemOper.ProcessFlag;
if (productmapitemOper.ProcessFlag.Equals("1"))
{
dr["Is_Process_flag"] = "已处理";
}
else
{
dr["Is_Process_flag"] = "未处理";
}
}
}
}
private void btnImport_Click(object sender, EventArgs e)
{
if (dataGridView.Rows.Count == 0)
{
return;
}
bool flag = true;
IList <Gpo_Product_MapModel> productModelList = new List <Gpo_Product_MapModel>();
try
{
foreach (DataGridViewRow row in this.dataGridView.Rows)
{
if (row.Cells[0].Value != null && row.Cells[0].Value.ToString().ToLower() == "true")
{
Gpo_Product_MapModel model = new Gpo_Product_MapModel();
model.ProductCode = row.Cells["PRODUCT_CODE"].Value.ToString();
model.MedicalCode = row.Cells["MEDICAL_CODE"].Value.ToString();
model.CommonName = row.Cells["COMMON_NAME"].Value.ToString();
model.Product_Name = row.Cells["PRODUCT_NAME"].Value.ToString();
model.Mode_ID = row.Cells["MODE_ID"].Value.ToString();
model.Mode_Name = row.Cells["MODE_NAME"].Value.ToString();
model.Medical_Spec_Id = row.Cells["MEDICAL_SPEC_ID"].Value.ToString();
model.Medical_Spec = row.Cells["MEDICAL_SPEC"].Value.ToString();
model.UseUnitCode = row.Cells["USE_UNIT_ID"].Value.ToString();
model.Use_Unit = row.Cells["USE_UNIT"].Value.ToString();
model.Spec_Unit_Id = row.Cells["SPEC_UNIT_ID"].Value.ToString();
model.Spec_Unit = row.Cells["SPEC_UNIT"].Value.ToString();
model.Stand_Rate = row.Cells["STAND_RATE"].Value.ToString();
model.Factory_Code = row.Cells["FACTORY_CODE"].Value.ToString();
model.Factory_Name = row.Cells["FACTORY_NAME"].Value.ToString();
model.ProductID = row.Cells["product_id"].Value.ToString();
model.DataProductID = row.Cells["data_product_id"].Value.ToString();
model.Permit_No = row.Cells["PERMIT_NO"].Value.ToString();
model.Saler_Code = row.Cells["SALER_CODE"].Value.ToString();
model.Saler_Name = row.Cells["SALER_NAME"].Value.ToString();
model.Sender_Code = row.Cells["SENDER_CODE"].Value.ToString();
model.Sender_Name = row.Cells["SENDER_NAME"].Value.ToString();
model.Category_Id = row.Cells["CATEGORY_ID"].Value.ToString();
model.Category_Name = row.Cells["CATEGORY_NAME"].Value.ToString();
model.Stock_Id = row.Cells["STOCK_ID"].Value.ToString();
model.Stock_Name = row.Cells["STOCK_NAME"].Value.ToString();
model.Package_Rate = string.IsNullOrEmpty(row.Cells["PACKAGE_RATE"].Value.ToString()) ? "1" : row.Cells["PACKAGE_RATE"].Value.ToString();
productModelList.Add(model);
}
}
if (productModelList.Count == 0)
{
ComUtil.MsgBox("请选择所要的导入产品信息！");
return;
}
//获取当前用户ORGID
string orgid = ClientSession.GetInstance().CurrentUser.UserOrg.Reg_org_id.ToString();
flag = ProductCodeCompareBLL.GetInstance("ClientDB").Import_Gpo_Product(orgid, productModelList);
if (flag == true)
{
ComUtil.MsgBox("导入产品信息成功！");
}
else
{
ComUtil.MsgBox("导入产品信息失败！");
}
}catch (Exception ex)
{
ComUtil.MsgBox("导入产品信息失败！");
//throw ex;
}
}
//获取修改SQL语句
private string UpdateComparison(Gpo_Product_MapModel input)
{
string buyerid = input.Map_Orgid;
string productid = input.ProductID;
string salerid = input.Saler_Id;
string senderid = input.Sender_Id;
string factoryid = input.Factory_Id;
string code = input.ProductCode;
string modecode = input.Mode_ID;
string modename = input.Mode_Name;
string name = input.Product_Name;
string Commonname = input.CommonName;
//int packagerate = 0;
//if (!string.IsNullOrEmpty(input.Package_Rate))
// packagerate = int.Parse(input.Package_Rate);
//string producer = input.Product_Name;
string producer = input.Factory_Name;
string factory_Code = input.Factory_Code;
string remark = input.Remark;
string speccode = input.Medical_Spec_Id;
string specname = input.Medical_Spec;
string specunit = input.Spec_Unit;
string specunitcode = input.Spec_Unit_Id;
//int standrate = 0;
//if (!string.IsNullOrEmpty(input.Stand_Rate))
// standrate = int.Parse(input.Stand_Rate);
string useunit = input.Use_Unit;
string useunitcode = input.UseUnitCode;
string read = input.ProcessFlag;
string ismap = input.IsMap;
StringBuilder sqlstr = new StringBuilder("Update GPO_PRODUCT_MAP");
sqlstr.AppendFormat(" Set PRODUCT_ID='{0}'", productid);
sqlstr.AppendFormat(",MAP_ORGID='{0}'", buyerid);
sqlstr.AppendFormat(",FACTORY_ID='{0}'", factoryid);
sqlstr.AppendFormat(",SALER_ID='{0}'", salerid);
sqlstr.AppendFormat(",SENDER_ID='{0}'", senderid);
sqlstr.AppendFormat(",MODE_ID='{0}'", modecode);
sqlstr.AppendFormat(",MODE_NAME='{0}'", modename);
sqlstr.AppendFormat(",PRODUCT_NAME='{0}'", name);
sqlstr.AppendFormat(",COMMON_NAME='{0}'", Commonname);
if (!string.IsNullOrEmpty(input.Package_Rate))
{
sqlstr.AppendFormat(",PACKAGE_RATE='{0}'", input.Package_Rate);
}
sqlstr.AppendFormat(",FACTORY_NAME='{0}'", producer);
sqlstr.AppendFormat(",REMARK='{0}'", remark);
sqlstr.AppendFormat(",MEDICAL_SPEC='{0}'", specname);
sqlstr.AppendFormat(",SPEC_UNIT='{0}'", specunit);
if (!string.IsNullOrEmpty(input.Stand_Rate))
{
sqlstr.AppendFormat(",STAND_RATE='{0}'", input.Stand_Rate);
}
sqlstr.AppendFormat(",USE_UNIT='{0}'", useunit);
sqlstr.Append(",SYNC_STATE= 0");
sqlstr.AppendFormat(",IsMap='{0}'", ismap);
sqlstr.AppendFormat(",PROCESS_FLAG='{0}'", read);
sqlstr.AppendFormat(" where ID='{0}'", input.ID);
return(sqlstr.ToString());
}
/// <summary>
/// 查询 产品编码对照列表信息
/// </summary>
/// <param name="input">产品编码对照表实体类</param>
/// <returns></returns>
public DataTable ProductCodeCompareList(Gpo_Product_MapModel input)
{
DataTable dt = new DataTable();
List <DbParameter> parameters = new List <DbParameter>();
DbParameter param;
if (!string.IsNullOrEmpty(input.IsMap))
{
//匹配状态
param = base.DbFacade.CreateParameter();
param.ParameterName = "IsMap";
param.DbType = DbType.String;
param.Value = input.IsMap;
parameters.Add(param);
}
if (!string.IsNullOrEmpty(input.ProcessFlag))
{
//处理状态
param = base.DbFacade.CreateParameter();
param.ParameterName = "PROCESS_FLAG";
param.DbType = DbType.String;
param.Value = input.ProcessFlag;
parameters.Add(param);
}
if (!string.IsNullOrEmpty(input.MedicaName))
{
//药品名称
param = base.DbFacade.CreateParameter();
param.ParameterName = "MedicaName";
param.DbType = DbType.String;
param.Value = '%' + input.MedicaName + '%';
parameters.Add(param);
}
if (!string.IsNullOrEmpty(input.FactoryName))
{
//生产企业
param = base.DbFacade.CreateParameter();
param.ParameterName = "FACTORY_NAME";
param.DbType = DbType.String;
param.Value = '%' + input.FactoryName + '%';
parameters.Add(param);
}
if (!string.IsNullOrEmpty(input.ProductCode))
{
//产品名称
param = base.DbFacade.CreateParameter();
param.ParameterName = "PRODUCT_CODE";
param.DbType = DbType.String;
param.Value = '%' + input.ProductCode + '%';
parameters.Add(param);
}
try
{
dt = DbFacade.SQLExecuteDataTable(GetGpo_Produce_MapListSql(input), parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
return(null);
}
return(dt);
}
private void Save()
{
if (string.IsNullOrEmpty(txtCode.Text.Trim()) || string.IsNullOrEmpty(txtCommonName.Text.Trim()) || string.IsNullOrEmpty(txtModeName.Text.Trim()) || string.IsNullOrEmpty(txtSpecName.Text.Trim()) || string.IsNullOrEmpty(teBASEMEASURE.Text.Trim()) || string.IsNullOrEmpty(teBASEMEASURESPEC.Text.Trim()))
{
XtraMessageBox.Show("带 * 为必填项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (issaved == false)
{
//定义对接产品对照表实体类
productmapitemOper = new Gpo_Product_MapModel();
LogedInUser CurrentUser = ClientSession.GetInstance().CurrentUser;
productmapitemOper.IsMap = "0";//未匹配
DataRow crow = gridView3.GetDataRow(gridView3.FocusedRowHandle);
if (crow != null)
{
productmapitemOper.ProductID = crow["PROJECT_PROD_ID"].ToString(); //产品ID
productmapitemOper.Map_Orgid = CurrentUser.UserOrg.Id;
productmapitemOper.Sender_Id = crow["Sender_Id"].ToString(); //配送企业ID
productmapitemOper.Factory_Id = crow["Factory_Id"].ToString(); //生产企业ID
productmapitemOper.HH_Mode_ID = crow["MODEL_ID"].ToString(); //客户端型号ID
productmapitemOper.HH_Spec_ID = crow["SPEC_ID"].ToString(); //客户端规格ID
productmapitemOper.IsMap = "1"; //已匹配
}
else
{
productmapitemOper.ProductID = "0"; //产品ID
productmapitemOper.Map_Orgid = CurrentUser.UserOrg.Id;
productmapitemOper.Sender_Id = "0"; //配送企业ID
productmapitemOper.Factory_Id = "0"; //生产企业ID
productmapitemOper.HH_Mode_ID = "0"; //客户端型号ID
productmapitemOper.HH_Spec_ID = "0"; //客户端规格ID
productmapitemOper.IsMap = "0"; //未匹配
}
productmapitemOper.ID = this.strID;
productmapitemOper.ProductCode = this.txtCode.Text;
productmapitemOper.CommonName = this.txtCommonName.Text;
productmapitemOper.Product_Name = this.txtName.Text;
productmapitemOper.CommerceName = this.teCName.Text;
productmapitemOper.Brand = this.txtBrand.Text;
productmapitemOper.Mode_ID = this.teMODELID.Text;
productmapitemOper.Mode_Name = this.txtModeName.Text;
productmapitemOper.Spec_Unit_Id = this.teSPEC_ID.Text;
productmapitemOper.Spec_Unit = this.txtSpecName.Text;
productmapitemOper.Base_measure = this.teBASEMEASURE.Text;
productmapitemOper.Base_measure_spec = this.teBASEMEASURESPEC.Text;
productmapitemOper.Base_measure_mate = this.teBASEMEASUREMATE.Text;
productmapitemOper.Stand_Rate = this.teSTANDRATE.Text;
productmapitemOper.Factory_Code = this.teFACTORYCODE.Text;
productmapitemOper.Factory_Name = this.teFACTORYName.Text;
productmapitemOper.Saler_Name = this.teSALERNAME.Text;
productmapitemOper.Saler_Code = this.teSALERCODE.Text;
productmapitemOper.Sender_Code = this.teSENDERCODE.Text;
productmapitemOper.Sender_Name = this.teSENDERNAME.Text;
productmapitemOper.Stock_Id = this.teSTOCKID.Text;
productmapitemOper.Stock_Name = this.teSTOCKNAME.Text;
productmapitemOper.User = CurrentUser;
productmapitemOper.Remark = this.txtRemark.Text;
//是否阅读
if (this.cbxRead.Checked == true)
{
productmapitemOper.ProcessFlag = "1";
}
else
{
productmapitemOper.ProcessFlag = "0";
}
//判断是否作插入操作还是修改操作
if (IsAdd == true)
{
SaveAdd(productmapitemOper);
}
else if (IsAdd == false)
{
SaveUpdate(productmapitemOper);
}
}
}
