/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMB_INTERFACE_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMB_INTERFACE_LOG set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_PKID=:C_PKID,");
strSql.Append("N_SENDNUM=:N_SENDNUM,");
strSql.Append("C_EMPID=:C_EMPID,");
strSql.Append("D_SENDTIME=:D_SENDTIME,");
strSql.Append("C_RESULTCODE=:C_RESULTCODE,");
strSql.Append("C_RESULTDESC=:C_RESULTDESC,");
strSql.Append("C_CONTENT=:C_CONTENT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_FLAG=:C_FLAG");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SENDNUM", OracleDbType.Decimal, 2),
new OracleParameter(":C_EMPID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SENDTIME", OracleDbType.Date),
new OracleParameter(":C_RESULTCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RESULTDESC", OracleDbType.Varchar2, 500),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_FLAG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_PKID;
parameters[2].Value = model.N_SENDNUM;
parameters[3].Value = model.C_EMPID;
parameters[4].Value = model.D_SENDTIME;
parameters[5].Value = model.C_RESULTCODE;
parameters[6].Value = model.C_RESULTDESC;
parameters[7].Value = model.C_CONTENT;
parameters[8].Value = model.C_REMARK;
parameters[9].Value = model.C_FLAG;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_INTERFACE_LOG DataRowToModel(DataRow row)
{
Mod_TMB_INTERFACE_LOG model = new Mod_TMB_INTERFACE_LOG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_PKID"] != null)
{
model.C_PKID = row["C_PKID"].ToString();
}
if (row["N_SENDNUM"] != null && row["N_SENDNUM"].ToString() != "")
{
model.N_SENDNUM = decimal.Parse(row["N_SENDNUM"].ToString());
}
if (row["C_EMPID"] != null)
{
model.C_EMPID = row["C_EMPID"].ToString();
}
if (row["D_SENDTIME"] != null && row["D_SENDTIME"].ToString() != "")
{
model.D_SENDTIME = DateTime.Parse(row["D_SENDTIME"].ToString());
}
if (row["C_RESULTCODE"] != null)
{
model.C_RESULTCODE = row["C_RESULTCODE"].ToString();
}
if (row["C_RESULTDESC"] != null)
{
model.C_RESULTDESC = row["C_RESULTDESC"].ToString();
}
if (row["C_CONTENT"] != null)
{
model.C_CONTENT = row["C_CONTENT"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_FLAG"] != null)
{
model.C_FLAG = row["C_FLAG"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMB_INTERFACE_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMB_INTERFACE_LOG(");
strSql.Append("C_PKID,N_SENDNUM,C_EMPID,D_SENDTIME,C_RESULTCODE,C_RESULTDESC,C_CONTENT,C_REMARK,C_FLAG)");
strSql.Append(" values (");
strSql.Append(":C_PKID,:N_SENDNUM,:C_EMPID,:D_SENDTIME,:C_RESULTCODE,:C_RESULTDESC,:C_CONTENT,:C_REMARK,:C_FLAG)");
OracleParameter[] parameters =
{
new OracleParameter(":C_PKID", OracleDbType.Varchar2, 500),
new OracleParameter(":N_SENDNUM", OracleDbType.Decimal, 2),
new OracleParameter(":C_EMPID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SENDTIME", OracleDbType.Date),
new OracleParameter(":C_RESULTCODE", OracleDbType.Varchar2, 3000),
new OracleParameter(":C_RESULTDESC", OracleDbType.Varchar2, 1000),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 500),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_FLAG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PKID;
parameters[1].Value = model.N_SENDNUM;
parameters[2].Value = model.C_EMPID;
parameters[3].Value = model.D_SENDTIME;
parameters[4].Value = model.C_RESULTCODE;
parameters[5].Value = model.C_RESULTDESC;
parameters[6].Value = model.C_CONTENT;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_FLAG;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="parem"></param>
/// <returns></returns>
private void AddLog(List <string> parem)
{
try
{
Mod_TMB_INTERFACE_LOG mod = new Mod_TMB_INTERFACE_LOG();
mod.D_SENDTIME = DateTime.Now;
mod.C_RESULTCODE = parem[0]; //返回结果
mod.C_RESULTDESC = parem[1]; //返回结果描述
mod.C_CONTENT = parem[2]; //返回成功或空
mod.C_PKID = parem[3]; //主键
mod.C_EMPID = parem[4]; //操作人ID
mod.C_FLAG = parem[5]; //标识
mod.C_REMARK = parem[6]; //备注
tmb_interface_log.Add(mod);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_INTERFACE_LOG GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PKID,N_SENDNUM,C_EMPID,D_SENDTIME,C_RESULTCODE,C_RESULTDESC,C_CONTENT,C_REMARK,C_FLAG from TMB_INTERFACE_LOG ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Mod_TMB_INTERFACE_LOG model = new Mod_TMB_INTERFACE_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 发送实绩给NC
/// </summary>
/// <param name="xmlFileName">xml完整路径</param>
/// <returns></returns>
public bool SendXml_DM(string xmlFileName, string code)
{
try
{
Mod_TMD_DISPATCH modDispatch = tmd_dispatch.GetModel(code);
XmlDocument xmlDoc = new XmlDocument();
//创建类型声明节点
XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no");
xmlDoc.AppendChild(node);
//创建根节点
XmlElement root = xmlDoc.CreateElement("ufinterface");
#region//给节点属性赋值
root.SetAttribute("billtype", "7F");
root.SetAttribute("filename", "" + code + ".xml");
root.SetAttribute("isexchange", "Y");
root.SetAttribute("operation", "req");
root.SetAttribute("proc", "update");
root.SetAttribute("receiver", "101");
root.SetAttribute("replace", "Y");
root.SetAttribute("roottag", "bill");
root.SetAttribute("sender", "1107");
#endregion
xmlDoc.AppendChild(root);
//创建子根节点
XmlElement bill = xmlDoc.CreateElement("bill");
bill.SetAttribute("id", modDispatch.C_GUID);//发运单表头主键
root.AppendChild(bill);
XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null);
#region //表头_order_head
CreateNode(xmlDoc, head, "apprdate", Convert.ToDateTime(modDispatch.D_APPROVE_DT).ToString("yyy-MM-dd")); //发运审批日期
CreateNode(xmlDoc, head, "bconfirm", "N");
CreateNode(xmlDoc, head, "billdate", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd")); //制单日期
CreateNode(xmlDoc, head, "billnewaddtime", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss"));
CreateNode(xmlDoc, head, "bisopen", "");
CreateNode(xmlDoc, head, "bmissionbill", "N");
CreateNode(xmlDoc, head, "bmustreturnbillcode", "");
CreateNode(xmlDoc, head, "btestbyinvoice", "");
CreateNode(xmlDoc, head, "clastmodifierid", modDispatch.C_EMP_ID);//最后修改人
CreateNode(xmlDoc, head, "clastmodiname", "");
CreateNode(xmlDoc, head, "curbilltype", "");
CreateNode(xmlDoc, head, "dallpacknum", "0");
CreateNode(xmlDoc, head, "dallvolumn", "0");
CreateNode(xmlDoc, head, "dallweight", "0");
CreateNode(xmlDoc, head, "dfactweight", "");
CreateNode(xmlDoc, head, "dr", "0");
CreateNode(xmlDoc, head, "dtotal", "");
CreateNode(xmlDoc, head, "employee", "");
CreateNode(xmlDoc, head, "h_confirmarrivedate", "");
CreateNode(xmlDoc, head, "iprintcount", "");
CreateNode(xmlDoc, head, "isendtype", "3");//运费类别
CreateNode(xmlDoc, head, "linkman1", "");
CreateNode(xmlDoc, head, "oprdepartname", "");
CreateNode(xmlDoc, head, "phone1", "");
CreateNode(xmlDoc, head, "pk_defdoc0", modDispatch.C_IS_WIRESALE_ID); //是否线材销售主键
CreateNode(xmlDoc, head, "pk_defdoc1", "");
CreateNode(xmlDoc, head, "pk_defdoc10", "");
CreateNode(xmlDoc, head, "pk_defdoc11", "");
CreateNode(xmlDoc, head, "pk_defdoc12", "");
CreateNode(xmlDoc, head, "pk_defdoc13", "");
CreateNode(xmlDoc, head, "pk_defdoc14", "");
CreateNode(xmlDoc, head, "pk_defdoc15", "");
CreateNode(xmlDoc, head, "pk_defdoc16", "");
CreateNode(xmlDoc, head, "pk_defdoc17", "");
CreateNode(xmlDoc, head, "pk_defdoc18", "");
CreateNode(xmlDoc, head, "pk_defdoc19", "");
CreateNode(xmlDoc, head, "pk_defdoc2", "");
CreateNode(xmlDoc, head, "pk_defdoc3", "");
CreateNode(xmlDoc, head, "pk_defdoc4", "");
CreateNode(xmlDoc, head, "pk_defdoc5", "");
CreateNode(xmlDoc, head, "pk_defdoc6", "");
CreateNode(xmlDoc, head, "pk_defdoc7", "");
CreateNode(xmlDoc, head, "pk_defdoc8", "");
CreateNode(xmlDoc, head, "pk_defdoc9", "");
CreateNode(xmlDoc, head, "pk_delivbill_h", ""); //发运单表头主键modDispatch.C_GUID
CreateNode(xmlDoc, head, "pkapprperson", "");
CreateNode(xmlDoc, head, "pkbillperson", modDispatch.C_CREATE_ID); //制单人
CreateNode(xmlDoc, head, "pkcorpforgenoid", "1001"); //公司编码
CreateNode(xmlDoc, head, "pkdelivmode", modDispatch.C_SHIPVIA); //发运方式主键
CreateNode(xmlDoc, head, "pkdelivorg", "1001NC10000000006EHS"); //发运组织主键固定
CreateNode(xmlDoc, head, "pkdelivroute", "1001NC10000000006EHV"); //发运路线主键 固定
CreateNode(xmlDoc, head, "pkdriver", "");
CreateNode(xmlDoc, head, "pkoperator", modDispatch.C_BUSINESS_ID); //业务员主键
CreateNode(xmlDoc, head, "pkoprdepart", modDispatch.C_BUSINESS_DEPT); //业务部门主键
CreateNode(xmlDoc, head, "pksendperson", "");
CreateNode(xmlDoc, head, "pktrancust", modDispatch.C_COMCAR); //承运商
CreateNode(xmlDoc, head, "pktranorg", "");
CreateNode(xmlDoc, head, "pkvehicle", "");
CreateNode(xmlDoc, head, "pkvehicletype", "");
CreateNode(xmlDoc, head, "returndate", "");
CreateNode(xmlDoc, head, "returntime", "");
CreateNode(xmlDoc, head, "senddate", Convert.ToDateTime(modDispatch.D_DISP_DT).ToString("yyy-MM-dd"));//发运日期
CreateNode(xmlDoc, head, "startdate", "");
CreateNode(xmlDoc, head, "starttime", "");
CreateNode(xmlDoc, head, "taudittime", "");
CreateNode(xmlDoc, head, "tlastmodifytime", Convert.ToDateTime(modDispatch.D_MOD_DT).ToString("yyy-MM-dd HH:mm:ss")); //最后修改时间
CreateNode(xmlDoc, head, "tmaketime", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss")); // 制单时间
CreateNode(xmlDoc, head, "ts", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss"));
CreateNode(xmlDoc, head, "userid", modDispatch.C_CREATE_ID); //制单人
CreateNode(xmlDoc, head, "vapprpersonname", "");
CreateNode(xmlDoc, head, "vbillpersonname", "");
CreateNode(xmlDoc, head, "vdelivbillcode", modDispatch.C_ID);//发运单单据号
CreateNode(xmlDoc, head, "vdoname", "");
CreateNode(xmlDoc, head, "vdrivername", "");
CreateNode(xmlDoc, head, "vehiclelicense", "");
CreateNode(xmlDoc, head, "vnote", "");
CreateNode(xmlDoc, head, "voldDelivbillcode", "");
CreateNode(xmlDoc, head, "vroutedescr", "");
CreateNode(xmlDoc, head, "vroutename", "");
CreateNode(xmlDoc, head, "vsendtypename", "");
CreateNode(xmlDoc, head, "vtranname", "");
CreateNode(xmlDoc, head, "vtranorgname", "");
CreateNode(xmlDoc, head, "vuserdef0", modDispatch.C_IS_WIRESALE);// 是否线材销售 是/ 否
CreateNode(xmlDoc, head, "vuserdef1", "");
CreateNode(xmlDoc, head, "vuserdef10", "");
CreateNode(xmlDoc, head, "vuserdef11", "");
CreateNode(xmlDoc, head, "vuserdef12", "");
CreateNode(xmlDoc, head, "vuserdef13", "");
CreateNode(xmlDoc, head, "vuserdef14", "");
CreateNode(xmlDoc, head, "vuserdef15", "");
CreateNode(xmlDoc, head, "vuserdef16", "");
CreateNode(xmlDoc, head, "vuserdef17", "");
CreateNode(xmlDoc, head, "vuserdef18", "");
CreateNode(xmlDoc, head, "vuserdef19", "");
CreateNode(xmlDoc, head, "vuserdef2", "");
CreateNode(xmlDoc, head, "vuserdef3", "Y"); //是否已导出
CreateNode(xmlDoc, head, "vuserdef4", modDispatch.C_LIC_PLA_NO); //车牌号
CreateNode(xmlDoc, head, "vuserdef5", "");
CreateNode(xmlDoc, head, "vuserdef6", modDispatch.C_ATSTATION); //到站
CreateNode(xmlDoc, head, "vuserdef7", "");
CreateNode(xmlDoc, head, "vuserdef8", "");
CreateNode(xmlDoc, head, "vuserdef9", "");
CreateNode(xmlDoc, head, "vvehiclename", "");
CreateNode(xmlDoc, head, "vvhcltypename", "");
#endregion
bill.AppendChild(head);
XmlElement body = xmlDoc.CreateElement("bill_body");
bill.AppendChild(body);
DataTable dt = tmd_dispatchdetails.GetList(code).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int rowno = i + 1;
Mod_TMP_DAYPLAN modDayPlan = tmp_dayplan.GetModelID(dt.Rows[i]["C_PLAN_ID"].ToString());
if (modDayPlan != null)
{
#region //实体参数
Mod_TMO_ORDER modOrder = tmo_order.GetModel(modDayPlan.C_PKBILLB);
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modDayPlan.C_PKCUST); //客户档案
//Mod_TMB_AREA modArea = tmb_area.GetModel(modDayPlan.C_PKARRIVEAREA);//区域
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetMatModel(modDayPlan.C_PKINV); //物料
Mod_TMD_DISPATCHDETAILS modFYD = tmd_dispatchdetails.GetModel(dt.Rows[i]["C_ID"].ToString());
string pkstock = modFYD.C_SEND_STOCK_PK;//仓库编码
string addrpk = "";
DataTable dtaddress = tmb_area.GetAreaAddress(modFYD.C_SEND_AREA).Tables[0];
if (dtaddress.Rows.Count > 0)
{
addrpk = dtaddress.Rows[0]["PK_ADDRESS"].ToString();
}
#endregion
string NCCHECKID = modFYD.C_QUALIRY_LEV; //质量等级
string C_BATCH_NO = string.Empty; //批号
//if (!string.IsNullOrEmpty(dt.Rows[i]["C_BATCH_NO"].ToString()))
//{
// C_BATCH_NO = dt.Rows[i]["C_BATCH_NO"].ToString();//批号
//}
//else
//{
// C_BATCH_NO = dt.Rows[i]["C_STOVE"].ToString();//炉号
//}
decimal dunitprice = Convert.ToDecimal(modDayPlan.N_UNITPRICE); //含税单价
decimal N_JZ = Convert.ToDecimal(modFYD.N_JWGT); //净重
string wgt = Convert.ToString(modFYD.N_WGT); //计划重量
string num = Convert.ToString(modFYD.N_FYZS); //件数
decimal dmoney = dunitprice * N_JZ; //订单金额
XmlNode item = xmlDoc.CreateNode(XmlNodeType.Element, "item", null);
#region //表体_item
CreateNode(xmlDoc, item, "bappendent", "");
CreateNode(xmlDoc, item, "bcloseout", "");
CreateNode(xmlDoc, item, "bcloseout_old", "");
CreateNode(xmlDoc, item, "blargess", "N");
CreateNode(xmlDoc, item, "borderreturn", "N");
CreateNode(xmlDoc, item, "breceiveinform", "");
CreateNode(xmlDoc, item, "bsigned", "");
CreateNode(xmlDoc, item, "btestbyinvoice", "");
CreateNode(xmlDoc, item, "carrivecorpname", "");
CreateNode(xmlDoc, item, "cbiztype", modDayPlan.C_BIZTYPE); //业务类型
CreateNode(xmlDoc, item, "ccheckstate_bid", NCCHECKID); //实绩质量等级
CreateNode(xmlDoc, item, "ccheckstatename", "");
CreateNode(xmlDoc, item, "cfreezeid", "");
CreateNode(xmlDoc, item, "cinvmanid", "");
CreateNode(xmlDoc, item, "confirmarrivedate", "");
CreateNode(xmlDoc, item, "cquoteunitid", modDayPlan.C_UNITID); //报价计量单位ID
CreateNode(xmlDoc, item, "cquoteunitname", "");
CreateNode(xmlDoc, item, "creceiptcorp", GetCust(modFYD.C_CGC)); //收货单位名称
CreateNode(xmlDoc, item, "creceiptcorpid", modFYD.C_CGC); //收货单位
CreateNode(xmlDoc, item, "csendcorp", "");
CreateNode(xmlDoc, item, "csendcorpid", "");
CreateNode(xmlDoc, item, "dcancelassistnum", "");
CreateNode(xmlDoc, item, "dcancelnum", "");
CreateNode(xmlDoc, item, "dfee", "");
CreateNode(xmlDoc, item, "dfeeitem", "");
CreateNode(xmlDoc, item, "dinvassist", num); //辅数量-件数
CreateNode(xmlDoc, item, "dinvnum", wgt); //计划重量
CreateNode(xmlDoc, item, "dinvweight", "");
CreateNode(xmlDoc, item, "dmileage", "");
CreateNode(xmlDoc, item, "dmoney", dmoney.ToString());//订单金额
CreateNode(xmlDoc, item, "doutassistnum", "");
CreateNode(xmlDoc, item, "doutnum", "");
CreateNode(xmlDoc, item, "doutnummargin", "");
CreateNode(xmlDoc, item, "dpackboxnum", "");
CreateNode(xmlDoc, item, "dpacknum", "");
CreateNode(xmlDoc, item, "dpackvolumn", "");
CreateNode(xmlDoc, item, "dpackweight", "");
CreateNode(xmlDoc, item, "dr", "0");
CreateNode(xmlDoc, item, "dreturnassistnum", "");
CreateNode(xmlDoc, item, "dreturnnum", "");
CreateNode(xmlDoc, item, "dsignasnum", "");
CreateNode(xmlDoc, item, "dsignassistnum", "");
CreateNode(xmlDoc, item, "dsignnum", "");
CreateNode(xmlDoc, item, "dsourcerow", "");
CreateNode(xmlDoc, item, "dtotalout", "");
CreateNode(xmlDoc, item, "dunitprice", dunitprice.ToString());//含税单价
CreateNode(xmlDoc, item, "dvolumn", "");
CreateNode(xmlDoc, item, "dwaylossasnum", "");
CreateNode(xmlDoc, item, "dwaylossnum", "");
CreateNode(xmlDoc, item, "hsl", "");
CreateNode(xmlDoc, item, "iattitude", "");
CreateNode(xmlDoc, item, "ibatchstatus", "0");
CreateNode(xmlDoc, item, "ibetimes", "");
CreateNode(xmlDoc, item, "iloadnum", "");
CreateNode(xmlDoc, item, "ilockstatus", "");
CreateNode(xmlDoc, item, "ionroadtime", "");
CreateNode(xmlDoc, item, "ipacking", "");
CreateNode(xmlDoc, item, "irownumber", rowno.ToString());//行号
CreateNode(xmlDoc, item, "irowstatus", "0");
CreateNode(xmlDoc, item, "ischeckatp", "N");
CreateNode(xmlDoc, item, "linkman1", "");
CreateNode(xmlDoc, item, "nassistnetwgt", num); //实发辅数量
CreateNode(xmlDoc, item, "nfeedbacknum", wgt); //回写上游数量
CreateNode(xmlDoc, item, "nnetwgt", N_JZ.ToString()); //净重
CreateNode(xmlDoc, item, "nquoteunitnum", wgt); //报价计量单位数量？-存货数量
CreateNode(xmlDoc, item, "nquoteunitrate", "1"); //报价计量单位换算率固定
CreateNode(xmlDoc, item, "ntotalshouldoutnum", "");
CreateNode(xmlDoc, item, "orderplantime", "");
CreateNode(xmlDoc, item, "packsortcode", "");
CreateNode(xmlDoc, item, "packsortname", "");
CreateNode(xmlDoc, item, "phone1", "");//****?
CreateNode(xmlDoc, item, "pk_corp", "");
CreateNode(xmlDoc, item, "pk_defdoc0", "");
CreateNode(xmlDoc, item, "pk_defdoc1", "");
CreateNode(xmlDoc, item, "pk_defdoc10", "");
CreateNode(xmlDoc, item, "pk_defdoc11", "");
CreateNode(xmlDoc, item, "pk_defdoc12", "");
CreateNode(xmlDoc, item, "pk_defdoc13", "");
CreateNode(xmlDoc, item, "pk_defdoc14", "");
CreateNode(xmlDoc, item, "pk_defdoc15", "");
CreateNode(xmlDoc, item, "pk_defdoc16", "");
CreateNode(xmlDoc, item, "pk_defdoc17", "");
CreateNode(xmlDoc, item, "pk_defdoc18", "");
CreateNode(xmlDoc, item, "pk_defdoc19", "");
CreateNode(xmlDoc, item, "pk_defdoc2", "");
CreateNode(xmlDoc, item, "pk_defdoc3", "");
CreateNode(xmlDoc, item, "pk_defdoc4", "");
CreateNode(xmlDoc, item, "pk_defdoc5", "");
CreateNode(xmlDoc, item, "pk_defdoc6", "");
CreateNode(xmlDoc, item, "pk_defdoc7", "");
CreateNode(xmlDoc, item, "pk_defdoc8", "");
CreateNode(xmlDoc, item, "pk_defdoc9", "");
CreateNode(xmlDoc, item, "pk_delivbill_b", ""); //置空
CreateNode(xmlDoc, item, "pk_delivbill_h", "");
CreateNode(xmlDoc, item, "pk_invbasdoc", modOrder.C_INVBASDOCID); //存货档案主键
CreateNode(xmlDoc, item, "pk_packsort", "");
CreateNode(xmlDoc, item, "pk_transcontainer", "");
CreateNode(xmlDoc, item, "pkarriveaddress", addrpk); //到货地点
CreateNode(xmlDoc, item, "pkarrivearea", modFYD.C_SEND_AREA); //到货地区主键
CreateNode(xmlDoc, item, "pkarrivecorp", "");
CreateNode(xmlDoc, item, "pkassistmeasure", modOrder.C_FUNITID); //辅计量单位
CreateNode(xmlDoc, item, "pkbasinv", modOrder.C_INVBASDOCID); //存货档案主键
CreateNode(xmlDoc, item, "pkbasreceiptcorp", modCust.C_NC_ID); //客户主键
CreateNode(xmlDoc, item, "pkbassendcorp", "");
CreateNode(xmlDoc, item, "pkconsign", "");
CreateNode(xmlDoc, item, "pkcorpforgenoid", modDayPlan.C_PKSALECORP); //销售公司（1001）
CreateNode(xmlDoc, item, "pkcusbasdoc", modCust.C_NC_ID); //客户主键
CreateNode(xmlDoc, item, "pkcusmandoc", modDayPlan.C_PKCUST); //客户管理主键
CreateNode(xmlDoc, item, "pkcustinvoice", "");
CreateNode(xmlDoc, item, "pkdayplan", "");
CreateNode(xmlDoc, item, "pkdestrep", "");
CreateNode(xmlDoc, item, "pkdeststockorg", "");
CreateNode(xmlDoc, item, "pkinv", modOrder.C_INVENTORYID);//存货管理档案主键
CreateNode(xmlDoc, item, "pkinvoice", "");
CreateNode(xmlDoc, item, "pkitem", "");
CreateNode(xmlDoc, item, "pkitemperiod", "");
CreateNode(xmlDoc, item, "pkoperator", modDayPlan.C_PKOPERATOR); //业务员ID
CreateNode(xmlDoc, item, "pkoprdepart", modDayPlan.C_PKOPRDEPART); //业务员部门
CreateNode(xmlDoc, item, "pkorder", "");
CreateNode(xmlDoc, item, "pkorderplanid", "");
CreateNode(xmlDoc, item, "pkorderrow", "");
CreateNode(xmlDoc, item, "pkpackboxtype", "");
CreateNode(xmlDoc, item, "pksalecorp", "1001");
CreateNode(xmlDoc, item, "pksalegrp", modDayPlan.C_PKSALEORG); //销售组织主键
CreateNode(xmlDoc, item, "pksendaddress", "0001AA1000000002LFNT"); //发货地点
CreateNode(xmlDoc, item, "pksendarea", "dqda0000000000000057"); //发货地区
CreateNode(xmlDoc, item, "pksendstock", pkstock); //仓库
CreateNode(xmlDoc, item, "pksendstockorg", "1001NC10000000000669"); //发货库存组织主键-固定
CreateNode(xmlDoc, item, "pksrccalbodyar", "");
CreateNode(xmlDoc, item, "pkunit", "");
CreateNode(xmlDoc, item, "plantime", "");
CreateNode(xmlDoc, item, "receivedate", "");
CreateNode(xmlDoc, item, "requireday", Convert.ToDateTime(modDayPlan.D_REQUIREDATE).ToString("yyy-MM-dd")); //要求到货日期
CreateNode(xmlDoc, item, "sourcebillts", "");
CreateNode(xmlDoc, item, "ts", ""); //HH:mm:ss
CreateNode(xmlDoc, item, "ufdtmp", "");
CreateNode(xmlDoc, item, "userid", "");
CreateNode(xmlDoc, item, "varriveaddress", "其他地区");
CreateNode(xmlDoc, item, "vassistmeaname", "");
CreateNode(xmlDoc, item, "vbatchcode", C_BATCH_NO);//批号
CreateNode(xmlDoc, item, "vbilltype", "30");
CreateNode(xmlDoc, item, "vbilltypename", "");
CreateNode(xmlDoc, item, "vcargcode", "");
CreateNode(xmlDoc, item, "vconsign", "");
CreateNode(xmlDoc, item, "vcontainername", "");
CreateNode(xmlDoc, item, "vcustcode", modCust.C_NO); //客户编码
CreateNode(xmlDoc, item, "vcustname", modCust.C_NAME); //客户名称
CreateNode(xmlDoc, item, "vdayplancode", modDayPlan.C_PLCODE); //对应日计划单据号
CreateNode(xmlDoc, item, "vdestaddress", modFYD.C_AREA); //收货地址
CreateNode(xmlDoc, item, "vdestarea", modFYD.C_SEND_AREA); //收货地区
CreateNode(xmlDoc, item, "vdeststoreaddre", "");
CreateNode(xmlDoc, item, "vdeststorename", "");
CreateNode(xmlDoc, item, "vdeststoreorgname", "");
CreateNode(xmlDoc, item, "vfree0", "");
CreateNode(xmlDoc, item, "vfree1", modDayPlan.C_VFREE1); //自由项1
CreateNode(xmlDoc, item, "vfree10", modFYD.C_ID); //CRM发运单表体主键//C_PK_NCID
CreateNode(xmlDoc, item, "vfree2", modDayPlan.C_VFREE2); //自由项2
CreateNode(xmlDoc, item, "vfree3", ""); //包装
CreateNode(xmlDoc, item, "vfree4", "");
CreateNode(xmlDoc, item, "vfree5", "");
CreateNode(xmlDoc, item, "vfree6", "");
CreateNode(xmlDoc, item, "vfree7", "");
CreateNode(xmlDoc, item, "vfree8", modDayPlan.C_ID); //CRM发运日计划主键
CreateNode(xmlDoc, item, "vfree9", modDispatch.C_GUID); // CRM发运单表头主键
CreateNode(xmlDoc, item, "vfreeid1", "");
CreateNode(xmlDoc, item, "vfreeid10", "");
CreateNode(xmlDoc, item, "vfreeid2", "");
CreateNode(xmlDoc, item, "vfreeid3", "");
CreateNode(xmlDoc, item, "vfreeid4", "");
CreateNode(xmlDoc, item, "vfreeid5", "");
CreateNode(xmlDoc, item, "vfreeid6", "");
CreateNode(xmlDoc, item, "vfreeid7", "");
CreateNode(xmlDoc, item, "vfreeid8", "");
CreateNode(xmlDoc, item, "vfreeid9", "");
CreateNode(xmlDoc, item, "vfreename1", "");
CreateNode(xmlDoc, item, "vfreename10", "");
CreateNode(xmlDoc, item, "vfreename2", "");
CreateNode(xmlDoc, item, "vfreename3", "");
CreateNode(xmlDoc, item, "vfreename4", "");
CreateNode(xmlDoc, item, "vfreename5", "");
CreateNode(xmlDoc, item, "vfreename6", "");
CreateNode(xmlDoc, item, "vfreename7", "");
CreateNode(xmlDoc, item, "vfreename8", "");
CreateNode(xmlDoc, item, "vfreename9", "");
CreateNode(xmlDoc, item, "vinvcode", "");
CreateNode(xmlDoc, item, "vinvname", "");
CreateNode(xmlDoc, item, "vinvoicecode", "");
CreateNode(xmlDoc, item, "vitemname", "");
CreateNode(xmlDoc, item, "vitemperiodname", "");
CreateNode(xmlDoc, item, "vnote", "");
CreateNode(xmlDoc, item, "voperatorname", "");
CreateNode(xmlDoc, item, "voprdepartname", "");
CreateNode(xmlDoc, item, "vordercode", modDayPlan.C_SALECODE);//销售单据号
CreateNode(xmlDoc, item, "vreceiptcorpname", "");
CreateNode(xmlDoc, item, "vsalecorpname", "");
CreateNode(xmlDoc, item, "vsaleorgname", "");
CreateNode(xmlDoc, item, "vsendaddr", "");
CreateNode(xmlDoc, item, "vsendaddress", "");
CreateNode(xmlDoc, item, "vsendarea", "");
CreateNode(xmlDoc, item, "vsendcorpname", "");
CreateNode(xmlDoc, item, "vsendstoreaddre", "");
CreateNode(xmlDoc, item, "vsendstorename", "");
CreateNode(xmlDoc, item, "vsendstoreorgaddre", "");
CreateNode(xmlDoc, item, "vsendstoreorgname", "");
CreateNode(xmlDoc, item, "vsignname", "");
CreateNode(xmlDoc, item, "vsignnote", "");
CreateNode(xmlDoc, item, "vspec", modMat.C_SPEC); //规格
CreateNode(xmlDoc, item, "vsrccalbodyarname", "");
CreateNode(xmlDoc, item, "vtype", modMat.C_STL_GRD); //钢种
CreateNode(xmlDoc, item, "vunit", modMat.C_ZJLDWMC); //主计量单位名称
CreateNode(xmlDoc, item, "vuserdef0", "");
CreateNode(xmlDoc, item, "vuserdef1", modFYD.C_MZDATE); //计量毛重日期*****
CreateNode(xmlDoc, item, "vuserdef10", modDayPlan.C_CONNO); //合同号
CreateNode(xmlDoc, item, "vuserdef11", "");
CreateNode(xmlDoc, item, "vuserdef12", "");
CreateNode(xmlDoc, item, "vuserdef13", "");
CreateNode(xmlDoc, item, "vuserdef14", "");
CreateNode(xmlDoc, item, "vuserdef15", "");
CreateNode(xmlDoc, item, "vuserdef16", "");
CreateNode(xmlDoc, item, "vuserdef17", "");
CreateNode(xmlDoc, item, "vuserdef18", "");
CreateNode(xmlDoc, item, "vuserdef19", "");
CreateNode(xmlDoc, item, "vuserdef2", Convert.ToString(modFYD.N_MWGT)); //毛重*****
CreateNode(xmlDoc, item, "vuserdef3", Convert.ToString(modFYD.C_PZDATE)); //计量皮重日期****
CreateNode(xmlDoc, item, "vuserdef4", Convert.ToString(modFYD.N_PWGT)); //皮重
CreateNode(xmlDoc, item, "vuserdef5", Convert.ToString(modFYD.N_JWGT)); // 净重
CreateNode(xmlDoc, item, "vuserdef6", Convert.ToString(modFYD.N_MZTIME)); //计量毛重时间
CreateNode(xmlDoc, item, "vuserdef7", Convert.ToString(modFYD.N_PZTIME)); //计量皮重时间
CreateNode(xmlDoc, item, "vuserdef8", "");
CreateNode(xmlDoc, item, "vuserdef9", "");
#endregion
body.AppendChild(item);
}
}
}
xmlDoc.Save(xmlFileName);
List <string> parem = NCSendXml.SendXML(xmlDoc);
if (parem[0] == "1")
{
//更新发运单状态
tmd_dispatchdetails.UpdateFydStatus(code, 9);
#region //添加日志
try
{
Bll_TMB_INTERFACE_LOG tmb_interface_log = new Bll_TMB_INTERFACE_LOG();
Mod_TMB_INTERFACE_LOG mod = new Mod_TMB_INTERFACE_LOG();
mod.D_SENDTIME = DateTime.Now;
mod.C_RESULTCODE = parem[0]; //返回结果
mod.C_RESULTDESC = parem[1]; //返回结果描述
mod.C_CONTENT = parem[2]; //返回成功或空
mod.C_PKID = code; //主键
mod.C_FLAG = "WL-NC"; //标识
mod.C_REMARK = "物流实绩导入NC成功"; //备注
tmb_interface_log.Add(mod);
}
catch (Exception e)
{
throw e;
}
#endregion
return(true);
}
else
{
#region //添加日志
try
{
Bll_TMB_INTERFACE_LOG tmb_interface_log = new Bll_TMB_INTERFACE_LOG();
Mod_TMB_INTERFACE_LOG mod = new Mod_TMB_INTERFACE_LOG();
mod.D_SENDTIME = DateTime.Now;
mod.C_RESULTCODE = parem[0]; //返回结果
mod.C_RESULTDESC = parem[1]; //返回结果描述
mod.C_CONTENT = parem[2]; //返回成功或空
mod.C_PKID = code; //主键
mod.C_FLAG = "WL-NC"; //标识
mod.C_REMARK = "物流实绩导入NC失败"; //备注
tmb_interface_log.Add(mod);
}
catch (Exception e)
{
throw e;
}
#endregion
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMB_INTERFACE_LOG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMB_INTERFACE_LOG model)
{
return(dal.Add(model));
}
