public void addWorkListHeads(List <TrackNoCustomRelation> TrackNoCustomRelationList, bool isGood, ref Dictionary <string, string> materialbomDic)
{
foreach (TrackNoCustomRelation trackTemp in TrackNoCustomRelationList)
{
WorkOrderHead init1 = new WorkOrderHead();
init1.wo_no = trackTemp.trackno;
init1.wo_date = Untils.getCustomDate(trackTemp.date);
init1.goods_nature = "E";
//if (isGood)
//{
string temp = trackTemp.custom_materialNo;
if (temp.Length == 10 && temp.StartsWith("000"))
{
temp = temp.Substring(3);
}
init1.cop_g_no = temp;//此处要区分对待， 如果良品入库要用正常料号，不良品入库用71料号,之前已经改过，这里直接使用
//}
//else
//{
// init1.cop_g_no = materialbomDic[trackTemp.custom_materialNo];
//}
init1.qty = "1";
init1.unit = Untils.getCustomCode(trackTemp.declare_unit);
init1.emo_no = ems_no;
workOrderHeadList.Add(init1);
}
}
public void addWorkListHeads(List <TrackNoCustomRelation> TrackNoCustomRelationList)
{
foreach (TrackNoCustomRelation trackTemp in TrackNoCustomRelationList)
{
WorkOrderHead init1 = new WorkOrderHead();
init1.wo_no = trackTemp.trackno;
init1.wo_date = Untils.getCustomDate(trackTemp.date);
init1.goods_nature = "E";
init1.cop_g_no = trackTemp.custom_materialNo;
init1.qty = "1";
init1.unit = Untils.getCustomCode(trackTemp.declare_unit);
init1.emo_no = ems_no;
workOrderHeadList.Add(init1);
}
}
private void exportxmlbutton_Click(object sender, EventArgs e)
{
WorkListHeadClass workListHead = new WorkListHeadClass();
List <WorkOrderHead> workOrderHeadList = new List <WorkOrderHead>();
string seq_no = DateTime.Now.ToString("yyyyMMdd") + "4002" + "1"; //日期+类型,后面需要加入序号信息
string boxtype = "4002"; //代码
string flowstateg = "";
string trade_code = "";
string ems_no = "";
string status = "A";
string today = DateTime.Now.ToString("yyyy/MM/dd");
try
{
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select indentifier, book_number from company_fixed_table";
SqlDataReader querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
trade_code = querySdr[0].ToString();
ems_no = querySdr[1].ToString();
}
querySdr.Close();
//报关出库的板子
cmd.CommandText = "select track_serial_no,return_date ,custom_serial_no,declare_unit from returnStore inner join receiveOrder on receiveOrder.orderno = returnStore.orderno where return_date='" + today + "'";
querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
WorkOrderHead init1 = new WorkOrderHead();
init1.wo_no = querySdr[0].ToString();
init1.wo_date = today;
init1.goods_nature = "E";
init1.cop_g_no = querySdr[2].ToString();
init1.qty = "1";
init1.unit = querySdr[4].ToString();
init1.emo_no = ems_no;
workOrderHeadList.Add(init1);
}
querySdr.Close();
mConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
workListHead.seq_no = seq_no;
workListHead.boxtype = boxtype;
workListHead.flowstateg = flowstateg;
workListHead.trade_code = trade_code;
workListHead.ems_no = ems_no;
workListHead.status = status;
workListHead.workOrderHeadList = workOrderHeadList;
Untils.createWorkListHeadXML(workListHead, "D:\\WO_HEAD" + seq_no + ".xml");
MessageBox.Show("finish");
}
