/// <summary>
/// 获取apibroker
/// </summary>
/// <param name="apidata"></param>
/// <param name="u8Login"></param>
/// <param name="broker"></param>
/// <returns></returns>
public Model.DealResult GetU8ApiBroker(Model.APIData apidata, U8Login.clsLogin u8Login, out U8ApiBroker broker, string op)
{
Model.DealResult dr = new Model.DealResult();
dr = base.GetU8ApiBroker(apidata, u8Login, out broker, op);
apidata.SVouchType = SetVouchType();
return(dr);
}
/// <summary>
/// 弃审
/// </summary>
/// <param name="bd"></param>
/// <param name="dt"></param>
/// <returns></returns>
public override Model.DealResult CancelAudit(Model.APIData bd, Model.Synergismlogdt dt)
{
Model.DealResult dr = new Model.DealResult();
Model.APIData apidata = bd as Model.APIData;
if (CheckAuditStatus(dt.Cvoucherno, apidata.ConnectInfo.Constring) == false)
{
return(dr);
}
string vouchid = GetCodeorID(dt.Cvoucherno, apidata, "id");
string auditaddress = SetApiAddressCancelAudit();
U8Login.clsLogin u8Login = new U8Login.clsLogin();
GetU8Login(apidata, u8Login);
U8ApiBroker broker = null;
dr = GetU8ApiBroker(apidata, u8Login, out broker, "cancelaudit");
broker.AssignNormalValue("sVouchType", apidata.SVouchType);
broker.AssignNormalValue("VouchId", vouchid);
broker.AssignNormalValue("cnnFrom", null);
broker.AssignNormalValue("TimeStamp", DAL.Common.GetUtfsByID(vouchid, SetTableName(), apidata.ConnectInfo.Constring));
MSXML2.IXMLDOMDocument2 domMsg = new MSXML2.DOMDocument();
broker.AssignNormalValue("domMsg", domMsg);
broker.AssignNormalValue("bCheck", false);
broker.AssignNormalValue("bBeforCheckStock", false);
broker.AssignNormalValue("bList", null);
dr = BrokerInvoker(broker);
return(dr);
}
/// <summary>
/// 组织数据
/// </summary>
/// <param name="dt">当前任务节点信息</param>
/// <param name="bd">HY_DZ_K7_DLLReflect 中预置的 data类</param>
/// <returns></returns>
public override Model.DealResult MakeData(Model.Synergismlogdt dt, BaseData bd)
{
Model.DealResult dr = new Model.DealResult();
Model.APIData apidata = bd as Model.APIData; //API实体,包括当前任务节点信息
DAL.TaskLog.ITaskLogDetail dtdal;
//当前任务节点信息
dtdal = ClassFactory.GetITaskLogDetailDAL(3);
Model.Synergismlogdt pdt = dtdal.GetPrevious(dt); //上一任务节点信息
apidata.ConnectInfo = dtdal.GetConnectInfo(dt); //获取当前结点的数据串连接串
apidata.Synergismlogdt = dt;
if (!apidata.Dodelete)
{
DataSet rdds = SetFromTabet(dt, pdt, apidata); //上一节点 单据头信息
DataSet rdsds = SetFromTabets(dt, pdt, apidata); //上一节点 单据体信息
DAL.IFieldcmps fieldcmpdal = ClassFactory.GetIFieldcmpsDAL(apidata.TaskType); //new DAL.Fieldcmps();
List <Model.Fieldcmps> listfd = fieldcmpdal.GetListFieldcmps(dt, pdt, apidata.TaskType); //字段对照信息
BLL.U8NameValue u8namevaluebll = new BLL.U8NameValue(); //字段赋值
u8namevaluebll.SetHeadData(apidata, rdds, rdsds, listfd, dt);
u8namevaluebll.SetSfcBodyData(apidata, rdds, rdsds, listfd, dt);
//设置订单关联
DAL.Common.SetInBody(apidata);
SetNormalValue(apidata, dt);
}
return(dr);
}
/// <summary>
/// 审核
/// </summary>
/// <param name="bd"></param>
/// <param name="vouchid"></param>
/// <returns></returns>
public override Model.DealResult MakeAudit(BaseData bd, Model.Synergismlogdt dt)
{
Model.DealResult dr = new Model.DealResult();
Model.APIData apidata = bd as Model.APIData;
string vouchid = GetCodeorID(dt.Cvoucherno, apidata, "id");
string auditaddress = SetApiAddressAudit();
U8Login.clsLogin u8Login = new U8Login.clsLogin();
GetU8Login(apidata, u8Login);
U8ApiBroker broker = null;
dr = GetU8ApiBroker(apidata, u8Login, out broker, "audit");
broker.AssignNormalValue("sVouchType", apidata.SVouchType);
broker.AssignNormalValue("VouchId", vouchid);
broker.AssignNormalValue("cnnFrom", null);
broker.AssignNormalValue("TimeStamp", DAL.Common.GetUtfsByID(vouchid, SetTableName(), apidata.ConnectInfo.Constring));
MSXML2.IXMLDOMDocument2 domMsg = new MSXML2.DOMDocument();
broker.AssignNormalValue("domMsg", domMsg);
broker.AssignNormalValue("bCheck", false);
broker.AssignNormalValue("bBeforCheckStock", false);
broker.AssignNormalValue("bList", null);
dr = BrokerInvoker(broker);
if (!DAL.Common.SetVerifyDate(bd.ConnectInfo, dt))
{
U8.Interface.Bus.Log.WriteWinLog("设置单据审核日期失败,Cvouchertype:" + dt.Cvouchertype + ";Cvoucherno:" + dt.Cvoucherno + ".");
}
return(dr);
}
public override void SetNormalValue(Model.APIData apidata, Model.Synergismlogdt dt)
{
base.SetNormalValue(apidata, dt);
//单据号获取
string ccode = "ccode";
Model.U8NameValue nv = ApiService.DAL.Common.U8NameValueFind(apidata.HeadData, ccode);
if (nv == null)
{
return;
}
if (!string.IsNullOrEmpty(nv.U8FieldValue))
{
return;
}
DbHelperSQLP help = new DbHelperSQLP(apidata.ConnectInfo.Constring);
string sql = "select top 1 ccode from PU_AppVouch with(nolock) ";
nv.U8FieldValue = help.GetSingle(sql).NullToString();
if (string.IsNullOrEmpty(nv.U8FieldValue))
{
nv.U8FieldValue = "0000000001";
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="bd"></param>
/// <param name="dt"></param>
/// <returns></returns>
public override Model.DealResult UndoMake(BaseData bd, Model.Synergismlogdt dt)
{
Model.DealResult dr = new Model.DealResult();
Model.APIData apidata = bd as Model.APIData;
try
{
dr = CancelAudit(apidata, dt);
}
catch (Exception ex)
{
U8.Interface.Bus.Log.WriteWinLog("stockop_cancelaudit:" + ex.ToString());
dr.ResultNum = -1;
dr.ResultMsg = ex.Message;
return(dr);
}
string vouchid = GetCodeorID(dt.Cvoucherno, apidata, "id");
string auditaddress = SetApiAddressDelete();
U8Login.clsLogin u8Login = new U8Login.clsLogin();
GetU8Login(apidata, u8Login);
U8ApiBroker broker = null;
dr = GetU8ApiBroker(apidata, u8Login, out broker, "delete");
broker.AssignNormalValue("sVouchType", apidata.SVouchType);
broker.AssignNormalValue("VouchId", vouchid);
broker.AssignNormalValue("cnnFrom", null);
broker.AssignNormalValue("TimeStamp", DAL.Common.GetUtfsByID(vouchid, SetTableName(), apidata.ConnectInfo.Constring));
MSXML2.IXMLDOMDocument2 domMsg = new MSXML2.DOMDocument();
broker.AssignNormalValue("domMsg", domMsg);
broker.AssignNormalValue("bCheck", false);
broker.AssignNormalValue("bBeforCheckStock", false);
broker.AssignNormalValue("bList", null);
dr = BrokerInvoker(broker);
return(dr);
}
public override void SetNormalValue(Model.APIData apidata, Model.Synergismlogdt dt)
{
base.SetNormalValue(apidata, dt);
//单据号获取
string ccode = "ccode";
Model.U8NameValue nv = ApiService.DAL.Common.U8NameValueFind(apidata.HeadData, ccode);
if (nv == null)
{
return;
}
if (!string.IsNullOrEmpty(nv.U8FieldValue))
{
return;
}
DbHelperSQLP help = new DbHelperSQLP(apidata.ConnectInfo.Constring);
string sql = "select top 1 ccode from PU_ArrivalVouch with(nolock) ";
nv.U8FieldValue = help.GetSingle(sql).NullToString();
if (string.IsNullOrEmpty(nv.U8FieldValue))
{
nv.U8FieldValue = "0000000001";
}
//envContext.SetApiContext("VoucherType", new int()); //上下文数据类型：int，含义：单据类型， 采购退货单 2
//envContext.SetApiContext("bPositive", new bool()); //上下文数据类型：bool，含义：红蓝标识：True,蓝字；False,红字
//envContext.SetApiContext("sBillType", new string()); //上下文数据类型：string，含义：到货单类型， 到货单 0 退货单 1
//envContext.SetApiContext("sBusType", new string()); //上下文数据类型：string，含义：业务类型：普通采购,直运采购,受托代销
}
public override Model.DealResult AssignNormalValues(Model.APIData apidata, UFIDA.U8.U8APIFramework.U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
broker.AssignNormalValue("VoucherState", 2);
MSXML2.IXMLDOMDocument2 CurDom = new MSXML2.DOMDocument();
broker.AssignNormalValue("CurDom", CurDom);
broker.AssignNormalValue("UserMode", 0);
return(dr);
}
/// <summary>
/// 设置表体
/// </summary>
/// <param name="apidata"></param>
/// <param name="broker"></param>
/// <returns></returns>
public Model.DealResult SetDomBody(Model.APIData apidata, U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
BusinessObject domBody = broker.GetBoParam("domBody");
domBody.RowCount = apidata.BodyData.Count;
int i = 0;
domBody.NeedFieldsCheck = false;
foreach (List <Model.U8NameValue> lunv in apidata.BodyData)
{
foreach (Model.U8NameValue unv in lunv)
{
string fieldName = unv.U8FieldName.ToLower();
//工厂编码特殊处理，解决部分环境BO不支持cfactorycode问题
if (fieldName == "cfactorycode")
{
continue;
}
if (unv.U8FieldName == "bgsp" && domBody.CardNumber == "U870_TRANS_0303")
{
if (unv.U8FieldValue.ToString() == "是")
{
domBody[i][unv.U8FieldName.ToLower()] = "1";
}
else if (unv.U8FieldValue.ToString() == "否")
{
domBody[i][unv.U8FieldName.ToLower()] = "0";
}
else
{
domBody[i][unv.U8FieldName.ToLower()] = unv.U8FieldValue;
}
}
else
{
int iFieldType = DAL.Common.GetFieldType(apidata.ConnectInfo.Constring, unv.U8FieldName, domBody.CardNumber);
if (iFieldType == 5 && !string.IsNullOrEmpty(unv.U8FieldValue))
{
domBody[i][unv.U8FieldName.ToLower()] = Convert.ToDateTime(unv.U8FieldValue).ToString("yyyy-MM-dd");
}
else
{
domBody[i][unv.U8FieldName.ToLower()] = unv.U8FieldValue;
}
}
}
i++;
}
return(dr);
}
/// <summary>
///
/// </summary>
/// <param name="apidata"></param>
/// <param name="broker"></param>
/// <returns></returns>
public override Model.DealResult AssignNormalValues(Model.APIData apidata, UFIDA.U8.U8APIFramework.U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
broker.AssignNormalValue("VoucherState", 0);
string vnewid = string.Empty;
broker.AssignNormalValue("vNewID", vnewid);
MSXML2.IXMLDOMDocument2 domMsg = new MSXML2.DOMDocument();
broker.AssignNormalValue("DomConfig", domMsg);
return(dr);
}
/// <summary>
/// 设置表头
/// </summary>
/// <param name="apidata"></param>
/// <param name="broker"></param>
/// <returns></returns>
public Model.DealResult SetDomHead(Model.APIData apidata, U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
ExtensionBusinessEntity extbo = broker.GetExtBoEntity("extbo");
//extbo.ItemCount = apidata.HeadData.Count;
foreach (Model.U8NameValue unv in apidata.HeadData)
{
extbo[0][unv.U8FieldName] = unv.U8FieldValue;
}
return(dr);
}
/// <summary>
/// 用domxml的方法加载数据--表头
/// </summary>
/// <param name="apidata"></param>
/// <param name="broker"></param>
/// <param name="domheadxml"></param>
/// <returns></returns>
public Model.DealResult SetDomHead(Model.APIData apidata, U8ApiBroker broker, MSXML2.DOMDocument domheadxml)
{
Model.DealResult dr = new Model.DealResult();
MSXML2.IXMLDOMNode headnode = domheadxml.selectSingleNode("//rs:data");
MSXML2.IXMLDOMElement element = domheadxml.createElement("z:row");
foreach (Model.U8NameValue unv in apidata.HeadData)
{
element.setAttribute(unv.U8FieldName.ToLower(), unv.U8FieldValue);
}
headnode.appendChild(element);
return(dr);
}
/// <summary>
/// 设置表头
/// </summary>
/// <param name="apidata"></param>
/// <param name="broker"></param>
/// <returns></returns>
public Model.DealResult SetDomHead(Model.APIData apidata, U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
BusinessObject DomHead = broker.GetBoParam("DomHead");
DomHead.NeedFieldsCheck = false;
DomHead.RowCount = 1; //设置BO对象(表头)行数，只能为一行
foreach (Model.U8NameValue unv in apidata.HeadData)
{
DomHead[0][unv.U8FieldName.ToLower()] = unv.U8FieldValue;
}
return(dr);
}
/// <summary>
/// 组织数据
/// </summary>
/// <param name="dt">当前任务节点信息</param>
/// <param name="bd">HY_DZ_K7_DLLReflect 中预置的 data类</param>
/// <returns></returns>
public override Model.DealResult MakeData(Model.Synergismlogdt dt, BaseData bd)
{
Model.DealResult dr = new Model.DealResult();
Model.APIData apidata = bd as Model.APIData; //API实体,包括当前任务节点信息
DAL.TaskLogFactory.ITaskLogDetail dtdal;
//当前任务节点信息
switch (apidata.TaskType)
{
case 0:
dtdal = new DAL.TaskLogFactory.CQ.TaskDetail();
break;
case 1:
dtdal = new DAL.SynergismLogDt();
break;
case 2:
dtdal = new DAL.TaskLogFactory.CQ.TaskDetail();
break;
default:
BLL.Common.ErrorMsg(SysInfo.productName, "tasktype" + apidata.TaskType + "未适配!");
dr.Message = "tasktype" + apidata.TaskType + "未适配!";
return(dr);
}
Model.Synergismlogdt pdt = dtdal.GetPrevious(dt); //上一任务节点信息
apidata.ConnectInfo = dtdal.GetConnectInfo(dt); //获取当前结点的数据串连接串
apidata.Synergismlogdt = dt;
if (!apidata.Dodelete)
{
DataSet rdds = SetFromTabet(dt, pdt, apidata); //上一节点 单据头信息
DataSet rdsds = SetFromTabets(dt, pdt, apidata); //上一节点 单据体信息
DAL.IFieldcmps fieldcmpdal = ClassFactory.GetIFieldcmpsDAL(apidata.TaskType); //new DAL.Fieldcmps();
List <Model.Fieldcmps> listfd = fieldcmpdal.GetListFieldcmps(dt, pdt); //字段对照信息
BLL.U8NameValue u8namevaluebll = new BLL.U8NameValue(); //字段赋值
u8namevaluebll.SetHeadData(apidata, rdds, rdsds, listfd, dt);
u8namevaluebll.SetBodyData(apidata, rdds, rdsds, listfd, dt);
//设置订单关联
DAL.Common.SetInBody(apidata);
SetNormalValue(apidata, dt);
}
return(dr);
}
/// <summary>
/// 获取apibroker
/// </summary>
/// <param name="apidata"></param>
/// <param name="u8Login"></param>
/// <param name="broker"></param>
/// <returns></returns>
public Model.DealResult GetU8ApiBroker(Model.APIData apidata, U8Login.clsLogin u8Login, out U8ApiBroker broker, string op)
{
broker = null;
Model.DealResult dr = new Model.DealResult();
switch (op)
{
case "add":
apidata.ApiAddress = SetApiAddressAdd();
break;
case "delete":
apidata.ApiAddress = SetApiAddressDelete();
break;
case "audit":
apidata.ApiAddress = SetApiAddressAudit();
break;
case "load":
apidata.ApiAddress = SetApiAddressLoad();
break;
case "cancelaudit":
apidata.ApiAddress = SetApiAddressCancelAudit();
break;
case "update":
apidata.ApiAddress = SetApiAddressUpdate();
break;
}
try
{
U8EnvContext envContext = new U8EnvContext();
envContext.U8Login = u8Login;
SetApiContext(envContext);
U8ApiAddress myApiAddress = new U8ApiAddress(apidata.ApiAddress);
broker = new U8ApiBroker(myApiAddress, envContext);
}
catch (Exception ex)
{
dr.ResultNum = -1;
dr.ResultMsg = ex.ToString();
throw new Exception(dr.ResultMsg);
}
return(dr);
}
public override Model.DealResult AssignNormalValues(Model.APIData apidata, U8ApiBroker broker)
{
Model.DealResult dr = new Model.DealResult();
broker.AssignNormalValue("sVouchType", SetVouchType());
broker.AssignNormalValue("domPosition", null);
broker.AssignNormalValue("cnnFrom", null);
broker.AssignNormalValue("VouchId", "");
MSXML2.IXMLDOMDocument2 domMsg = new MSXML2.DOMDocument();
broker.AssignNormalValue("domMsg", domMsg);
broker.AssignNormalValue("bCheck", true);
broker.AssignNormalValue("bBeforCheckStock", true);
broker.AssignNormalValue("bIsRedVouch", false);
broker.AssignNormalValue("sAddedState", null);
broker.AssignNormalValue("bReMote", false);
return(dr);
}
/// <summary>
/// 设置通用变量
/// </summary>
/// <param name="apidata"></param>
/// <param name="dt"></param>
public static void SetNormalValue(Model.APIData apidata, Model.Synergismlogdt dt)
{
string vt_id = "vt_id";
Model.U8NameValue nv = DAL.Common.U8NameValueFind(apidata.HeadData, vt_id);
if (nv != null)
{
if (string.IsNullOrEmpty(nv.U8FieldValue))
{
DbHelperSQLP help = new DbHelperSQLP(apidata.ConnectInfo.Constring);
string sql = string.Format("select def_id from vouchers_base with(nolock) where CardNumber='{0}'", dt.Cvouchertype);
nv.U8FieldValue = help.GetSingle(sql).NullToString();
}
}
string iinvexchrate = "iinvexchrate";
if (apidata.SfcBodyData != null && apidata.SfcBodyData.Count > 0)
{
foreach (Model.BodyRow sfcrow in apidata.SfcBodyData)
{
Model.U8NameValue nv_iinvexchrate = DAL.Common.U8NameValueFind(sfcrow.BodyCols, iinvexchrate);
if (nv_iinvexchrate != null)
{
if (string.IsNullOrEmpty(nv_iinvexchrate.U8FieldValue))
{
nv_iinvexchrate.U8FieldValue = "0";
}
}
}
}
else
{
foreach (List <Model.U8NameValue> list in apidata.BodyData)
{
Model.U8NameValue nv_iinvexchrate = DAL.Common.U8NameValueFind(list, iinvexchrate);
if (nv_iinvexchrate != null)
{
if (string.IsNullOrEmpty(nv_iinvexchrate.U8FieldValue))
{
nv_iinvexchrate.U8FieldValue = "0";
}
}
}
}
}
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from Rdrecord01 with(nolock) where ccode='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(ccode,'') from Rdrecord01 with(nolock) where id='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DbHelperSQLP sqlp = new DbHelperSQLP(apidata.ConnectInfo.Constring);
return(sqlp.GetSingle(sqlstr).NullToString());
}
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
Model.APIData apidata = bd as Model.APIData;
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from PU_AppVouch with(nolock) where ccode='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(ccode,'') from PU_AppVouch with(nolock) where id='" + strID + "'";
}
DbHelperSQLP sqlp = new DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
// DAL.Common.ErrorMsg(ret, "未能获取采购申请单ID或单号");
return(ret);
}
/// <summary>
/// 判断日志中记录的单据在账套中是否真的存在 added by liuxzha 2015.03.23
/// 日志查询界面使用
/// </summary>
/// <param name="autoid"></param>
/// <returns> 0 本节点没有生成，子结点也没生成;
/// 10 本节点生成，子结点没有生成,单据为未审核状态
/// 11 本节点生成，子结点没有生成,单据为已审核状态
/// 100 本节点没有生成，子结点已经生成
/// 110 本节点生成，子结点也已经生成,单据为未审核状态
/// 111 本节点生成，子结点也已经生成,单据为已审核状态</returns>
public int ChkExistsInData(string autoid)
{
int res = 0;
//bool bHasCreateChild = false; //在日志中是否已生成子节点
DAL.SynergismLogDt daldt = new SynergismLogDt();
BLL.SynergisnLogDT logdtbll = new SynergisnLogDT();
Model.Synergismlogdt dt = daldt.GetModel(autoid);
List <Model.Synergismlogdt> nextlist = logdtbll.GetNext(dt, null);
foreach (Model.Synergismlogdt next in nextlist)
{
if (!string.IsNullOrEmpty(next.Cvoucherno))
{
//bHasCreateChild = true;
res += 100;
}
}
BaseData bd = ClassFactory.GetBaseData(dt);
bd.Dodelete = true;
bd.Synergismlogdt = dt;
bd.Fristsynergismlogdt = daldt.GetFirst(dt);
BaseOp op = ClassFactory.GetBaseOp(dt);
op.MakeData(dt, bd);
Model.APIData apidata = bd as Model.APIData;
string vouchid = op.GetCodeorID(dt.Cvoucherno, bd, "id");
if (!string.IsNullOrEmpty(vouchid))
{
res += 10; //本节点已生成
if (((APIOp)op).CheckAuditStatus(dt.Cvoucherno, apidata.ConnectInfo.Constring))
{
res += 1;
}
}
return(res);
}
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull( dlid,'') from DispatchList with(nolock) where cDLCode='" + strID + "' and cvouchtype = '05' ";
}
if (codeorid == "code")
{
sqlstr = "select isnull( cDLCode,'') from DispatchList with(nolock) where dlid='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DbHelperSQLP sqlp = new DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
//DAL.Common.ErrorMsg(ret, "未能获取发货单ID或单号");
return(ret);
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(moid,'') from mom_order with(nolock) where mocode='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(mocode,'') from mom_order with(nolock) where moid ='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
ApiService.BLL.Common.ErrorMsg(ret, "未能获生产订单ID或单号");
return(ret);
}
/// <summary>
/// 表体
/// </summary>
/// <param name="apidata"></param>
/// <param name="rdds"></param>
/// <param name="rdsds"></param>
/// <param name="listfd"></param>
/// <param name="dt"></param>
public void SetSfcBodyData(Model.APIData apidata, System.Data.DataSet rdds, System.Data.DataSet rdsds, List <Model.Fieldcmps> listfd, Model.Synergismlogdt dt)
{
//赋值
apidata.SfcBodyData = new List <U8.Interface.Bus.ApiService.Model.BodyRow>();
//表体
int rowno = 0; //来源单据行号
for (int i = 0; i < rdsds.Tables[0].Rows.Count; i++)
{
rowno = i;
Model.BodyRow lmu8nv = new Model.BodyRow();
foreach (Model.Fieldcmps fd in listfd)
{
SetSfcBodyCols(listfd, fd, ref i, ref rowno, apidata, dt, lmu8nv, rdds, rdsds);
}
apidata.SfcBodyData.Add(lmu8nv);
}
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from AssemVouch with(nolock) where cAVCode ='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(cAVCode,'') from AssemVouch with(nolock) where id ='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
BLL.Common.ErrorMsg(ret, "未能获取" + voucherTypeName + "ID或单号");
return(ret);
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from PU_ArrivalVouch with(nolock) where " + targetVoucherNoColumnName + "='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(" + targetVoucherNoColumnName + ",'') from PU_ArrivalVouch with(nolock) where id ='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
ApiService.BLL.Common.ErrorMsg(ret, "未能获采购退货单ID或单号");
return(ret);
}
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string strCode = string.Empty;
try
{
Model.APIData apidta = bd as Model.APIData;
DAL.Rdrecord32 rd32dal = new DAL.Rdrecord32();
if (codeorid == "code")
{
strCode = rd32dal.GetCodeByID(strID, apidta.ConnectInfo.Constring);
}
if (codeorid == "id")
{
strCode = rd32dal.GetIDByCode(strID, apidta.ConnectInfo.Constring);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(strCode);
}
/// <summary>
/// 获取来源表体数据
/// </summary>
/// <param name="dt"></param>
/// <param name="pdt"></param>
/// <param name="apidata"></param>
/// <returns></returns>
public override System.Data.DataSet SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
string _sourcetablenameh = "pu_ArrHead";
string _sourcetablenameb = "pu_ArrBody";
ApiService.DAL.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt();
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select b.*,";
sql += " lt.cWhCode as MES_cWhCode,lt.cRdStyleCode as MES_cRdCode,lt.cDepCode as MES_cDepCode,lt.cPersonCode as MES_cPersonCode, ";
sql += " lt.cvencode as MES_cvencode,";
sql += " CASE lb.opertype WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
sql += " lb.iquantity as MES_iquantity ";
sql += " from " + _sourcetablenameb + " b with(nolock) ";
sql += " inner join " + _sourcetablenameh + " t with(nolock) on b.id = t.id ";
sql += " inner join " + bodytable + " lb with(nolock) on lb.dhid = b.autoid ";
sql += " inner join " + headtable + " lt with(nolock) on lt.id = lb.id ";
sql += " where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
BLL.Common.ErrorMsg(ds, "未能获取采购到货单表体信息");
return(ds);
}
/// <summary>
/// 获取来源表头数据
/// </summary>
/// <param name="dt"></param>
/// <param name="pdt"></param>
/// <param name="apidata"></param>
/// <returns></returns>
public override System.Data.DataSet SetFromTabet(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
string _sourcetablenameh = "pu_ArrHead";
string _sourcetablenameb = "pu_ArrBody";
ApiService.DAL.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select t.*,";
sql += " t.id as iarriveid ,"; //到货单id
sql += " t.id as ipurarriveid ,"; //采购到货单id
sql += " '' as ipurorderid ,"; //采购订单ID
sql += " lt.cvencode as MES_cvencode,";
sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as pro_ddate "; //入库日期
sql += ",'" + System.DateTime.Now.ToString(SysInfo.datetimeFormat) + "' as dnmaketime, "; //制单时间
sql += " lt.cRdCode as cCode ,";
sql += " lt.cWhCode as MES_cWhCode,lt.cRdStyleCode as MES_cRdCode,lt.cDepCode as MES_cDepCode,lt.cPersonCode as MES_cPersonCode , ";
sql += " lb.dhCode as MES_dhCode, ";
sql += " '" + apidata.ConnectInfo.UserId + "' as PRO_CMaker ";
sql += " from pu_ArrHead t with(nolock) ";
sql += " left join " + bodytable + " lb with(nolock) on lb.dhCode = t.ccode ";
sql += " left join " + headtable + " lt with(nolock) on lt.id = lb.id where lt.id ='" + pdt.Id + "' ";
//sql += " from " + _sourcetablenameb + " b with(nolock) inner join " + _sourcetablenameh + " t with(nolock) on b.id = t.id inner join " + bodytable + " lb with(nolock) on lb.dhid = b.autoid inner join " + headtable + " lt with(nolock) on lt.id = lb.id where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
BLL.Common.ErrorMsg(ds, "未能获取采购到货单表头信息");
return(ds);
}
public override System.Data.DataSet SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
ApiService.DAL.SynergismLogDt dtdal = new ApiService.DAL.SynergismLogDt();
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
return(Common.GetSourceDetailDataset(pdt.Cvouchertype, pdt.Cvoucherno, cimodel.Constring));
}
/// <summary>
/// 获取来源表体数据
/// </summary>
/// <param name="dt"></param>
/// <param name="pdt"></param>
/// <param name="apidata"></param>
/// <returns></returns>
public override System.Data.DataSet SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //ClassFactory.GetITaskLogMain(3);;
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select b.*,lt.cWhCode as cWhCode,lb.iquantity as iquantity,lt.cRdCode as cCode ";
sql += " from v_mom_orderdetail_wf b with(nolock) left join v_mom_order_wf t with(nolock) on b.moid = t.moid left join " + bodytable + " lb with(nolock) on lb.mocode = t.mocode left join " + headtable + " lt with(nolock) on lt.id = lb.id where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.BLL.Common.ErrorMsg(ds, "未能获取其他入库单表体信息");
return(ds);
}
