//根据产品ID获取工艺标准信息并更新。
protected static void getTechstdd_SQL(string id, string prodcode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
try
{
techStddInfoVO tech = service.getTechStdById(id);
if (tech != null)
{
tQaTechStdd info = tech.techStddInfo;
string[] seg = { "ID", "TECH_CODE", "TECH_NAME", "STANDARD_VOL", "REMARK", "PROD_CODE", "MODIFY_ID", "MODIFY_TIME", "IS_VALID", "IS_DEL", "E_DATE", "CREATE_ID", "CREATE_DEPT_ID", "CREATE_DATE", "CONTROL_STATUS", "B_DATE" };
string[] value = { id, info.standardCode, info.techStddName, info.standardVol, info.remark, prodcode, info.modifyId, info.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), info.isValid, info.isDel, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.createId, info.createDept, info.createDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.BDate.ToString("yyyy-MM-dd HH:mm:ss") };
string temp = opt.getMergeStr(seg, value, 2, "HT_TECH_STDD_CODE");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (tech.techStdDetails != null && tech.techStdDetails.Length > 0)
{
string[] subseg = { "ID", "TECH_CODE", "PARA_CODE", "PARA_TYPE", "REMARK", "VALUE", "UPPER_LIMIT", "LOWER_LIMIT", "UNIT" };
foreach (techStddDetail detail in tech.techStdDetails)
{
if (detail.baseDown != "" && detail.baseUp != "")
{
string stdvalue = detail.centerVal == "" ? ((Convert.ToDouble(detail.baseDown) + Convert.ToDouble(detail.baseUp)) / 2).ToString() : detail.centerVal;
string[] subvalue = { detail.id, id, detail.projCode, detail.techParmType, detail.remark, stdvalue, detail.baseUp, detail.baseDown, detail.bzUnit };
temp = opt.getMergeStr(subseg, subvalue, 1, "HT_TECH_STDD_CODE_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
/* "TECH_STDD_ID" IS '工艺技术标准主表id';
* "TECH_PRAM_TYPE" IS '技术参数类型';
* "PROJ_CODE" IS '工序项目编码';
* "PARM_STDD" IS '工艺参数或质量标准';
* "CENTER_VAL" IS '中心值';
* "BIAS_UP" IS '上偏值';
* "BIAS_DOWN" IS '下偏值';
* "STDD_VALUE" IS '工艺标准值';
* "PASS_PERCENT" IS '合格率';
* "BZ_UNIT" IS '计量单位';
* "SORT" IS '排序';
* "REMARK" IS '备注';*/
}
}
catch (Exception ee)
{
}
}
protected static void getMaterFormalu_SQL(string id, string prodCode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
materFormulaVO info = service.getMatFormulaById(id);
string temp;
if (info != null)
{
string[] seg = { "ID", "FORMULA_CODE", "FORMULA_NAME", "ADJUST", "B_DATE", "CABO_SUM", "CONTROL_STATUS", "CREATE_DATE", "CREATE_DEPT_ID", "CREATE_ID", "E_DATE", "EXECUTEBATCH", "FLOW_STATUS", "IS_DEL", "IS_VALID", "MODIFY_ID", "MODIFY_TIME", "PIECE_NUM", "PIECES_SUM", "PROD_CODE", "REMARK", "SMALLS_NUM", "STANDARD_VOL", "STEM_NUM", "STICKS_NUM" };
string[] value = { id, "703" + info.formulaCode, info.formulaName, info.adjust, info.BDate.ToString("yyyy-MM-dd HH:mm:ss"), info.caboSum.ToString(), info.controlStatus, info.createDate, info.createDept, info.createId, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.executeBatch.ToString(), info.flowStatus, info.isDel, info.isValid,
info.modifyId, info.modifyTime, info.pieceNum.ToString(), info.piecesSum.ToString(), prodCode, info.remark, info.smallsNum.ToString(), info.standardVol, info.stemNum.ToString(), info.sticksNum.ToString() };
temp = opt.getMergeStr(seg, value, 2, "HT_QA_MATER_FORMULA");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (info.ygSubList != null && info.ygSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "BATCH_SIZE", "FRONT_GROUP", "IS_DEL", "MATER_FLAG", "FORMULA_CODE", "MATER_SORT", "REMARK" };
foreach (tQaMaterFormulaDetail detail in info.ygSubList)
{
string[] subvalue = { detail.id.ToString(), detail.materCode, detail.batchSize.ToString(), detail.frontGroup, detail.isDel, detail.materFlag, id, detail.materSort.ToString(), detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 2, "HT_QA_MATER_FORMULA_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
if (info.spSubList != null && info.spSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "BATCH_SIZE", "FRONT_GROUP", "IS_DEL", "MATER_FLAG", "FORMULA_CODE", "MATER_SORT", "REMARK" };
foreach (tQaMaterFormulaDetail detail in info.spSubList)
{
string[] subvalue = { detail.id.ToString(), detail.materCode, detail.batchSize.ToString(), detail.frontGroup, detail.isDel, detail.materFlag, id, detail.materSort.ToString(), detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 2, "HT_QA_MATER_FORMULA_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
}
public override string InsertLocalFromMaster()
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
tPubMateriel[] mat = service.getAllMaterialtList();
commandlist.Clear();
string[] matseg = { "ID", "MATERIAL_CODE", "MATERIAL_NAME", "TYPE_CODE", "SPEC_VAL", "MODEL_VAL", "IS_VALID", "IS_DEL",
"TYPE_FLAG", "UNIT_CODE", "DATA_ORIGIN_FLAG", "PK_MATERIAL", "FACTORY", "MAT_YEAR", "MAT_CATEGORY", "MAT_TYPE",
"MAT_LEVEL", "MAT_VARIETY", "MAT_PACK", "MAT_PLACE", "REMARK", "MAT_TYPE2", "MAT_PLACE_NAME", "MAT_PROVINCE",
"MAT_CITY", "PK_MARBASCLASS", "LAST_UPDATE_TIME", "COSTPRICE", "XY_MATERIAL_CODE", "PK_MATTAXES", "PIECE_WEIGHT" };
foreach (tPubMateriel materia in mat)
{
string[] value = { materia.id.ToString(), materia.materialCode, materia.materialName, materia.typeCode, materia.specVal, materia.modelVal, materia.isValid, materia.isDel, materia.typeFlag, materia.unitCode, materia.dataOriginFlag, materia.pkMaterial, materia.factory, materia.matYear, materia.matCategory, materia.matType, materia.matLevel, materia.matVariety, materia.matPack, materia.matPlace, materia.remark, materia.matType2, materia.matPlaceName, materia.matProvince, materia.matCity, materia.pkMarbasclass, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), materia.costprice.ToString(), materia.xyMaterialCode, materia.pkMattaxes, materia.pieceWeight };
string temp = opt.getMergeStr(matseg, value, 3, "HT_PUB_MATERIEL");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
return(opt.TransactionCommand(commandlist));
}
public override string InsertLocalFromMaster()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
MisMasterDataServiceInterfaceService service = new MisMasterDataServiceInterfaceService();
string Xmlstr = service.getUserInfo(buffer.ToString());
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
string temp;
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
segvalue[0] = childList[2].InnerText;
segvalue[1] = childList[0].InnerText;
segvalue[2] = childList[1].InnerText;
segvalue[3] = childList[3].InnerText;
string dpno = opt.GetSegValue("select F_CODE from Ht_Svr_Org_Group where F_KEY = '" + segvalue[3] + "'", "F_CODE");
if (dpno != "NoRecord")
{
segvalue[3] = dpno;
}
string psd = opt.GetSegValue("select Password from HT_SVR_USER where ID = '" + segvalue[0] + "'", "PassWord");
if (psd == "NoRecord" || psd == "")
{
segvalue[4] = "e10adc3949ba59abbe56e057f20f883e";
}
else
{
segvalue[4] = psd;
}
temp = opt.getMergeStr(seg, segvalue, 1, tablename);
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
else
{
return("字段与值个数不匹配");
}
}
return(opt.TransactionCommand(commandlist));
}
private static void service_Completed(object sender, getAllProductListCompletedEventArgs e)
{
productEntity[] prods = e.Result;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
string[] matseg = { "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "TECH_STDD_CODE", "MATER_FORMULA_CODE", "AUX_FORMULA_CODE", "COAT_FORMULA_CODE", "REMARK", "CREATEOR_ID", "CREATE_TIME", "MODIFY_ID", "MODIFY_TIME", "STANDARD_VALUE", "XY_PROD_CODE", "IS_VALID", "IS_DEL" };
int SucCount = 0;
foreach (productEntity prod in prods)
{
// commandlist.Clear();
string[] value = { prod.prodCode, prod.prodName, prod.packName, prod.handMode, prod.techStddId, prod.materFormulaId, prod.auxFormulaId, prod.coatFormulaId, prod.remark, prod.createorId, prod.createTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.modifyId, prod.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.standardValue, prod.xyProdCode, prod.isValid, prod.isDel };
string temp = opt.getMergeStr(matseg, value, 1, "HT_PUB_PROD_DESIGN");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
//getTechstdd_SQL(prod.techStddId, prod.prodCode);
getMaterFormalu_SQL(prod.materFormulaId, prod.prodCode);
getAuxFormalu_SQL(prod.auxFormulaId, prod.prodCode);
getCoatFormalu_SQL(prod.coatFormulaId, prod.prodCode);
opt.UpDateOra("update ht_pub_prod_design t set tech_stdd_code = (select r.tech_code from ht_tech_stdd_code r where substr(t.tech_stdd_code,0,3)<>'TCH' and r.id = to_number( t.tech_stdd_code)),mater_formula_code = (select s.formula_code from ht_qa_mater_formula s where t.mater_formula_code is not null and s.id = to_number( t.mater_formula_code)),aux_formula_code = (select q.formula_code from ht_qa_aux_formula q where t.aux_formula_code is not null and q.id = to_number( t.aux_formula_code)),coat_formula_code = (select p.formula_code from ht_qa_coat_formula p where t.coat_formula_code is not null and p.id = to_number( t.coat_formula_code)) where t.prod_code = '" + prod.prodCode + "'");
opt.UpDateOra("update ht_qa_mater_formula_detail r set formula_code = (select t.formula_code from ht_qa_mater_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.materFormulaId + "'");
opt.UpDateOra("update ht_qa_aux_formula_detail r set formula_code = (select t.formula_code from ht_qa_aux_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.auxFormulaId + "'");
opt.UpDateOra("update ht_qa_coat_formula_detail r set formula_code = (select t.formula_code from ht_qa_coat_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'");
opt.UpDateOra("update ht_tech_stdd_code_detail r set tech_code = (select t.tech_code from ht_tech_stdd_code t where t.id = r.tech_code) where r.tech_code = '" + prod.techStddId + "'");
opt.UpDateOra("update ht_qa_mater_formula_detail t set t.mater_flag = (select r.mat_type from ht_pub_materiel r where r.material_code = t.mater_code)");
}
}
private static void service_Completed(object sender, materialTreeCompletedEventArgs e)
{
treeVO[] mattree = e.Result;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
string[] seg = { "ID", "MATTREE_CODE", "MATTREE_NAME", "IS_DEL", "PK_CLASS", "PK_PARENT_CLASS" };
foreach (treeVO leaf in mattree)
{
string[] value = { leaf.id, leaf.classCode, leaf.name, "0", leaf.classCode, leaf.pId };
string temp = opt.getMergeStr(seg, value, 1, "HT_PUB_MATTREE");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
opt.UpDateOra("update ht_pub_mattree t set t.parent_code = (select mattree_code from ht_pub_mattree r where r.id = t.pk_parent_class)");
// return opt.TransactionCommand(commandlist);
}
private static void service_Completed(object sender, getDeptInfoCompletedEventArgs e)
{
string Xmlstr = e.Result;
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
for (int i = 0; i < count - 1; i++)
{
segvalue[i] = childList[i].InnerText;
}
segvalue[2] = "";
if (segvalue[1] == "江苏鑫源烟草薄片有限公司")
{
segvalue[count - 1] = "00700000";
}
else
{
segvalue[3] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[3] + "'", "F_CODE");
segvalue[4] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[0] + "'", "F_CODE");
if (segvalue[4] == "NoRecord")
{
string code;
if (segvalue[3] == "00700000")
{
code = "007" + opt.GetSegValue("select nvl(Max(substr(F_CODE,4,3))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '00700000'", "CODE").PadLeft(3, '0') + "00";
}
else
{
code = segvalue[3].Substring(0, 6) + opt.GetSegValue("select nvl( Max(substr(F_CODE,7,2))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '" + segvalue[3] + "'", "CODE").PadLeft(2, '0');
}
segvalue[4] = code;
}
}
string temp = opt.getMergeStr(seg, segvalue, 1, tablename);
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
// opt.TransactionCommand(commandlist);
}
protected static void getAuxFormalu_SQL(string id, string prodCode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
try
{
auxFormulaVO info = service.getAuxFormulaById(id);
string temp;
if (info != null)
{
string[] seg = { "ID", "FORMULA_CODE", "FORMULA_NAME", "B_DATE", "CONTROL_STATUS", "CREATE_DATE", "CREATE_DEPT_ID", "CREATE_ID", "E_DATE", "IS_DEL", "IS_VALID", "MODIFY_ID", "MODIFY_TIME", "PROD_CODE", "REMARK", "STANDARD_VOL" };
string[] value = { id, "703" + info.formulaCode, info.formulaName, info.BDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.createDate, info.createDept, info.createId, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.isDel, info.isValid, info.modifyId, info.modifyTime, prodCode, info.remark, info.standardVol };
temp = opt.getMergeStr(seg, value, 2, "HT_QA_AUX_FORMULA");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (info.auxSubList != null && info.auxSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "FORMULA_CODE", "AUX_PERCENT", "AUX_SCALE", "AUX_SORT", "IS_DEL", "MATER_TYPE", "mattreeName", "REMARK" };
foreach (tQaAuxFormulaDetail detail in info.auxSubList)
{
string[] subvalue = { detail.id.ToString(), detail.materCode, id, detail.auxPercent.ToString(), detail.auxScale.ToString(), detail.auxSort.ToString(), detail.isDel, detail.materType, detail.mattreeName, detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 2, "HT_QA_AUX_FORMULA_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
// return commandlist;
}
catch (Exception ee)
{
}
}
private static void service_Completed(object sender, getUserInfoCompletedEventArgs e)
{
string Xmlstr = e.Result;
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
string temp;
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
segvalue[0] = childList[2].InnerText;
segvalue[1] = childList[0].InnerText;
segvalue[2] = childList[1].InnerText;
segvalue[3] = childList[3].InnerText;
string dpno = opt.GetSegValue("select F_CODE from Ht_Svr_Org_Group where F_KEY = '" + segvalue[3] + "'", "F_CODE");
if (dpno != "NoRecord")
{
segvalue[3] = dpno;
}
string psd = opt.GetSegValue("select Password from HT_SVR_USER where ID = '" + segvalue[0] + "'", "PassWord");
if (psd == "NoRecord" || psd == "")
{
segvalue[4] = "e10adc3949ba59abbe56e057f20f883e";
}
else
{
segvalue[4] = psd;
}
temp = opt.getMergeStr(seg, segvalue, 1, tablename);
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
// return opt.TransactionCommand(commandlist);
}
public override string InsertLocalFromMaster()
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
productEntity[] prods = service.getAllProductList(new productEntity());
string[] matseg = { "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "TECH_STDD_CODE", "MATER_FORMULA_CODE", "AUX_FORMULA_CODE", "COAT_FORMULA_CODE", "REMARK", "CREATEOR_ID", "CREATE_TIME", "MODIFY_ID", "MODIFY_TIME", "STANDARD_VALUE", "XY_PROD_CODE", "IS_VALID", "IS_DEL" };
int SucCount = 0;
foreach (productEntity prod in prods)
{
if (prod.prodCode.Substring(0, 3) == "703")
{
commandlist.Clear();
string[] value = { prod.prodCode, prod.prodName, prod.packName, prod.handMode, prod.techStddId, prod.materFormulaId, prod.auxFormulaId, prod.coatFormulaId, prod.remark, prod.createorId, prod.createTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.modifyId, prod.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.standardValue, prod.prodCode, prod.isValid, prod.isDel };
string temp = opt.getMergeStr(matseg, value, 1, "HT_PUB_PROD_DESIGN");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
// getTechstdd_SQL(prod.techStddId, prod.prodCode); // java.math.BigInteger cannot be cast to java.lang.String
getMaterFormalu_SQL(prod.materFormulaId, prod.prodCode);
// getAuxFormalu_SQL(prod.auxFormulaId, prod.prodCode); //java.math.BigDecimal cannot be cast to java.lang.Double
getCoatFormalu_SQL(prod.coatFormulaId, prod.prodCode);
if (opt.TransactionCommand(commandlist) == "Success")
{
commandlist.Clear();
commandlist.Add("update ht_pub_prod_design t set tech_stdd_code = (select r.tech_code from ht_tech_stdd_code r where substr(t.tech_stdd_code,0,3)<>'TCH' and r.id = to_number( t.tech_stdd_code)),mater_formula_code = (select s.formula_code from ht_qa_mater_formula s where t.mater_formula_code is not null and s.id = to_number( t.mater_formula_code)),aux_formula_code = (select q.formula_code from ht_qa_aux_formula q where t.aux_formula_code is not null and q.id = to_number( t.aux_formula_code)),coat_formula_code = (select p.formula_code from ht_qa_coat_formula p where t.coat_formula_code is not null and p.id = to_number( t.coat_formula_code)) where t.prod_code = '" + prod.prodCode + "'");
commandlist.Add("update ht_qa_mater_formula_detail r set formula_code = (select t.formula_code from ht_qa_mater_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.materFormulaId + "'");
commandlist.Add("update ht_qa_aux_formula_detail r set formula_code = (select t.formula_code from ht_qa_aux_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.auxFormulaId + "'");
commandlist.Add("update ht_qa_coat_formula_detail r set formula_code = (select t.formula_code from ht_qa_coat_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'");
commandlist.Add("update ht_qa_Fla_formula_detail r set formula_code = (select t.formula_code from ht_qa_Fla_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'");
commandlist.Add("update ht_tech_stdd_code_detail r set tech_code = (select t.tech_code from ht_tech_stdd_code t where t.id = r.tech_code) where r.tech_code = '" + prod.techStddId + "'");
commandlist.Add("update ht_qa_mater_formula_detail t set t.mater_flag = (select r.mat_type from ht_pub_materiel r where r.material_code = t.mater_code)");
opt.TransactionCommand(commandlist);
System.Diagnostics.Debug.Write("产品更新成功" + prod.prodCode + prod.prodName);
SucCount++;
}
}
}
return(SucCount.ToString() + "项产品更新成功,总记录条数：" + prods.Length);
}
private static void service_Completed(object sender, getUnitListCompletedEventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
tPubUnit[] units = e.Result;
//List<string> commandlist = new List<string>();
string[] seg = { "id", "unitCode", "unitName", "originCode", "unitGroupCode", "unitGroupName",
"unitGroupType", "xyUnitCode", "isDel", "isValid" };
foreach (tPubUnit unit in units)
{
string[] value = { unit.id.ToString(), unit.unitCode, unit.unitName, unit.originCode, unit.unitGroupCode, unit.unitGroupName, unit.unitGroupType, unit.xyUnitCode, unit.isDel, unit.isValid };
string temp = opt.getMergeStr(seg, value, 1, "HT_INNER_UNIT");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
// return opt.TransactionCommand(commandlist);
}
public override string InsertLocalFromMaster()
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
treeVO[] mattree = service.materialTree();
List <string> commandlist = new List <string>();
string[] seg = { "ID", "MATTREE_CODE", "MATTREE_NAME", "IS_DEL", "PK_CLASS", "PK_PARENT_CLASS" };
foreach (treeVO leaf in mattree)
{
string[] value = { leaf.id, leaf.classCode, leaf.name, "0", leaf.classCode, leaf.pId };
string temp = opt.getMergeStr(seg, value, 1, "HT_PUB_MATTREE");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
commandlist.Add("update ht_pub_mattree t set t.parent_code = (select mattree_code from ht_pub_mattree r where r.id = t.pk_parent_class)");
return(opt.TransactionCommand(commandlist));
}
public override string InsertLocalFromMaster()
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
tPubUnit[] units = service.getUnitList();
List <string> commandlist = new List <string>();
string[] seg = { "id", "unitCode", "unitName", "originCode", "unitGroupCode", "unitGroupName",
"unitGroupType", "xyUnitCode", "isDel", "isValid" };
foreach (tPubUnit unit in units)
{
string[] value = { unit.id.ToString(), unit.unitCode, unit.unitName, unit.originCode, unit.unitGroupCode, unit.unitGroupName, unit.unitGroupType, unit.xyUnitCode, unit.isDel, unit.isValid };
string temp = opt.getMergeStr(seg, value, 1, "HT_INNER_UNIT");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
return(opt.TransactionCommand(commandlist));
}
protected static void getCoatFormalu_SQL(string id, string prodCode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
try
{
coatFormulaVO info = service.getCoatFormulaById(id);
string temp;
if (info != null)
{
//插入回填液
string[] seg = { "ID", "FORMULA_CODE", "FORMULA_NAME", "B_DATE", "CONTROL_STATUS", "CREATE_DATE", "CREATE_DEPT_ID", "CREATE_ID", "E_DATE", "IS_DEL", "IS_VALID", "MODIFY_ID", "MODIFY_TIME", "PROD_CODE", "REMARK", "STANDARD_VOL", "FORMULA_TPY", "FORMULA_XJ", "W_TOTAL" };
string[] value = { id, "703" + info.formulaCode, info.formulaName, info.BDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.createDate, info.createDept, info.createId, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.isDel, info.isValid, info.modifyId, info.modifyTime, prodCode, info.remark, info.standardVol, info.formulaTpy.ToString(), info.formulaXj.ToString(), info.WTotal.ToString() };
temp = opt.getMergeStr(seg, value, 2, "HT_QA_COAT_FORMULA");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (info.coatTBYSubList != null && info.coatTBYSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "CLASS_NAME", "COAT_FLAG", "FORMULA_CODE", "COAT_SCALE", "COAT_SORT", "IS_DEL", "IS_VALID", "NEED_SIZE", "REMARK" };
foreach (tQaCoatFormulaDetail detail in info.coatTBYSubList)
{
string[] subvalue = { detail.id.ToString(), detail.classCode, detail.className, detail.coatFlag, id, detail.coatScale, detail.coatSort.ToString(), detail.isDel, detail.isValid, detail.needSize.ToString(), detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 2, "HT_QA_COAT_FORMULA_DETAIL");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
//插入香精香料
string[] segX = { "ID", "FORMULA_CODE", "FORMULA_NAME", "B_DATE", "CONTROL_STATUS", "CREATE_DATE", "CREATE_DEPT_ID", "CREATE_ID", "E_DATE", "IS_DEL", "IS_VALID", "MODIFY_ID", "MODIFY_TIME", "PROD_CODE", "REMARK", "STANDARD_VOL", "FORMULA_TPY", "FORMULA_XJ", "W_TOTAL" };
string[] valueX = { id, "703" + info.formulaCode, info.formulaName, info.BDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.createDate, info.createDept, info.createId, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.isDel, info.isValid, info.modifyId, info.modifyTime, prodCode, info.remark, info.standardVol, info.formulaTpy.ToString(), info.formulaXj.ToString(), info.WTotal.ToString() };
temp = opt.getMergeStr(seg, value, 2, "HT_QA_Fla_FORMULA");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (info.coatXJSubList != null && info.coatXJSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "CLASS_NAME", "COAT_FLAG", "FORMULA_CODE", "COAT_SCALE", "COAT_SORT", "IS_DEL", "IS_VALID", "NEED_SIZE", "REMARK" };
foreach (tQaCoatFormulaDetail detail in info.coatXJSubList)
{
string[] subvalue = { detail.id.ToString(), detail.classCode, detail.className, detail.coatFlag, id, detail.coatScale, detail.coatSort.ToString(), detail.isDel, detail.isValid, detail.needSize.ToString(), detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 2, "HT_QA_Fla_FORMULA_DETAIL");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
}
catch (Exception ee)
{
}
}
public override string InsertLocalFromMaster()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
MisMasterDataServiceInterfaceService service = new MisMasterDataServiceInterfaceService();
string Xmlstr = service.getDeptInfo(buffer.ToString());
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
for (int i = 0; i < count - 1; i++)
{
segvalue[i] = childList[i].InnerText;
}
segvalue[2] = "";
if (segvalue[1] == "江苏鑫源烟草薄片有限公司")
{
segvalue[count - 1] = "00700000";
}
else
{
segvalue[3] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[3] + "'", "F_CODE");
segvalue[4] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[0] + "'", "F_CODE");
if (segvalue[4] == "NoRecord")
{
string code;
if (segvalue[3] == "00700000")
{
code = "007" + opt.GetSegValue("select nvl(Max(substr(F_CODE,4,3))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '00700000'", "CODE").PadLeft(3, '0') + "00";
}
else
{
code = segvalue[3].Substring(0, 6) + opt.GetSegValue("select nvl( Max(substr(F_CODE,7,2))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '" + segvalue[3] + "'", "CODE").PadLeft(2, '0');
}
segvalue[4] = code;
}
}
string temp = opt.getMergeStr(seg, segvalue, 1, tablename);
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
return(opt.TransactionCommand(commandlist));
}
