/// <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 st.cCode as cCode,sb.*,";
sql += " lt.cWhCode as MES_cWhCode,";
sql += " lb.cInvCode as MES_cInvCode,lb.iquantity as MES_iquantity, ";
sql += " CASE lb." + opertype + " WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
//sql += " lb.iquantity * sb.iOriCost as pro_iOriMoney , "; //原币含税单价
sql += " lb.iquantity * sb.iOriCost as pro_iOriMoney , "; //原币金额(不含税)
sql += " lb.iquantity * sb.iOriCost * sb.iTaxRate/100 as pro_iOriTaxPrice , "; //原币税额
sql += " (lb.iquantity * sb.iOriCost + lb.iquantity * sb.iOriCost * sb.iTaxRate/100 ) as pro_iOriSum , "; //原币价税合计
sql += " lb.iquantity * sb.iCost as pro_iMoney , "; //本币金额
sql += " lb.iquantity * sb.iCost * sb.iTaxRate/100 as pro_iTaxPrice , "; //本币税额
sql += " (lb.iquantity * sb.iCost + lb.iquantity * sb.iCost * sb.iTaxRate/100 ) as pro_iSum "; //本币价税合计
sql += " FROM " + sourceBodyTable + " sb with(nolock) ";
sql += " INNER JOIN " + sourceHeadTable + " st with(nolock) on sb.id = st.id ";
sql += " INNER JOIN " + bodytable + " lb with(nolock) on lb.dhid = sb.autoid ";
sql += " 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);
ApiService.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 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 1 as a where 1=2 ";
//sql += " CASE lb.opertype WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
//sql += " '" + cimodel.UserId + "' as cMaker,";
//sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as dTVDate "; //移库日期
//sql += ",'" + System.DateTime.Now.ToString(SysInfo.datetimeFormat) + "' as dnmaketime, "; //制单时间
//sql += " lt.MOCODE as mes_MOCODE ,"; //生产订单号
//sql += " lt.MOSEQ as mes_MOSEQ ,"; //订单行号
//sql += " lt.ITEMCODE as mes_ITEMCODE ,"; //物料编码
//sql += " lt.OPSeq as mes_OPSeq ,"; //工序行号
//sql += " lt.OPCode as mes_OPCode, "; //工序编号
//sql += " lt.OPDescription as mes_OPDescription, "; //工序说明
//sql += " lt.PersonCode as mes_PersonCode, "; //人员编码
//sql += " lt.ResCode as mes_ResCode, "; //资源编码
//sql += " lt.Istatus as mes_Istatus, "; //状态
//sql += " lt.Qty as mes_Qty, "; //数量
//sql += " lt.StartDate as mes_StartDate, "; //开工日期
//sql += " lt.StartTime as mes_StartTime, "; //开工时间
//sql += " lt.ISCOMDATE as mes_ISCOMDATE, "; //完工时间
//sql += " lt.ISCOMTIME as mes_ISCOMTIME, "; //完工时间
//sql += " lt.opdoccode as mes_opdoccode, "; //生成的工序转移单号
//sql += " lt.workdoccode as mes_workdoccode "; //生成的工时记录单号
//sql += " from " + headtable + " where lt.id ='" + dt.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 SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select st.*,";
sql += " lt.PlanCode as MES_PlanCode ,lt.MoCode as MES_MoCode,lt.cWcCode as MES_cWcCode,lt.cInvCode as MES_cInvCode, ";
sql += " lt.cSoCode as MES_cSoCode ,lt.cForCode as MES_cForCode,lt.PStartDate as MES_PStartDate,lt.PDueDate as MES_PDueDate, ";
sql += " lt.DmandDate as MES_DmandDate ,lt.MoType as MES_MoType,lt.iquantity as MES_iquantity, ";
sql += " sob.iRowNo as sob_iRowNo,sob.cSOCode as sob_cSOCode, ";
sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate, ";
sql += " tt.MoTypeId as PRO_MoTypeId, ";
sql += " tt.MoTypeCode as PRO_MoType, ";
sql += " '生产订单' as cSource ";
sql += " from " + headtable + " lt with(nolock) ";
sql += " LEFT JOIN " + sourceHeadTable + " st with(nolock) on ltrim(rtrim(lt.PlanCode)) = ltrim(rtrim(st.PlanCode)) ";
sql += " LEFT JOIN mom_motype tt with(nolock) ON lt.MoType = substring(tt.MotypeCode,LEN(tt.MotypeCode),1) ";
sql += " left join SO_SODetails sob with(nolock) on Convert(nvarchar,sob.iSOsID) = st.sodid ";
sql += " where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.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 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 ";
sql += " lt.cCVCode as mes_cCVCode ,"; //盘点单号
sql += " lt.dCVDate as mes_dCVDate ,"; //计划盘点日期
sql += " lt.dACDate as mes_dACDate ,"; //实际盘点日期
sql += " lt.cDepCode as mes_cDepCode ,"; //盘点部门
sql += " lt.cPersonCode as mes_cPersonCode ,";
sql += " lt.cWhCode as mes_cWhCode, ";
sql += " lt.cIRdCode as MES_cIRdCode, ";
sql += " lt.cORdCode as MES_cORdCode, ";
sql += " CASE lb.opertype WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
sql += " lb.cinvcode as mes_cinvcode ,lb.cVenCode as MES_B_cVenCode, ";
sql += " lb.iquantity as MES_iquantity, ";
sql += " lb.cVenCode as mes_cvencode ";
sql += " from " + bodytable + " lb with(nolock) 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);
ApiService.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 SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
string sourceHeadTable = "pu_ArrHead";
string sourceBodyTable = "pu_ArrBody";
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //ClassFactory.GetITaskLogMain(3);;
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select sb.*,";
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 += " inv.cComUnitCode as inv_cComUnitCode,inv.cAssComUnitCode as inv_cAssComUnitCode,inv.cSTComUnitCode as inv_cSTComUnitCode ";
sql += " FROM " + sourceBodyTable + " sb with(nolock) ";
sql += " INNER JOIN " + sourceHeadTable + " st with(nolock) on sb.id = st.id ";
sql += " INNER JOIN " + bodytable + " lb with(nolock) on lb.dhid = sb.autoid ";
sql += " INNER JOIN " + headtable + " lt with(nolock) on lt.id = lb.id ";
sql += " INNER JOIN inventory inv with(nolock) on inv.cinvcode = lb.cinvcode ";
sql += " where lt.id ='" + dt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.BLL.Common.ErrorMsg(ds, "未能获取采购到货单表体信息");
return(ds);
}
public override System.Data.DataSet SetFromTabetsChild(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 st.*,";
sql += " lt.PlanCode as MES_cWhCode ,lt.MoCode as MES_MoCode,lt.cWcCode as MES_cWcCode, ";
sql += " lt.cSoCode as MES_cSoCode ,lt.cForCode as MES_cForCode,lt.PStartDate as MES_PStartDate,lt.PDueDate as MES_PDueDate, ";
sql += " lt.DmandDate as MES_DmandDate ,lt.MoType as MES_MoType, ";
sql += " lb.BomID as MES_BomID ,lb.cInvCode as MES_cInvCode,lb.iquantity as MES_iquantity, ";
sql += " lb.iquantity * lt.iquantity as MES_C_iquantity, ";
sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate , ";
sql += " '生产订单' as cSource ";
sql += " from " + headtable + " lt with(nolock) ";
sql += " inner join " + bodytable + " lb with(nolock) on lt.id = lb.id ";
sql += " left join " + sourceHeadTable + " st with(nolock) on ltrim(rtrim(lt.PlanCode)) = ltrim(rtrim(st.PlanCode)) ";
sql += " where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.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 sourceHeadTable = "pu_ArrHead";
string sourceBodyTable = "pu_ArrBody";
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select distinct st.*,";
sql += " st.ccode as MES_cARVCode, "; //到货单号
sql += " st.id as iarriveid ,"; //到货单id
sql += " st.id as ipurarriveid ,"; //采购到货单id
sql += " '' as ipurorderid ,"; //采购订单ID
sql += " lt.cvencode as MES_cvencode,";
sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate "; //入库日期
sql += ",'" + System.DateTime.Now.ToString(SysInfo.datetimeFormat) + "' as dnmaketime, "; //制单时间
sql += " lt." + voucherNoColumnName + " 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 " + sourceBodyTable + " sb with(nolock) ";
sql += " INNER JOIN " + sourceHeadTable + " st with(nolock) on sb.id = st.id ";
sql += " INNER JOIN " + bodytable + " lb with(nolock) on lb.dhid = sb.autoid ";
sql += " INNER JOIN " + headtable + " lt with(nolock) on lt.id = lb.id where lt.id ='" + dt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.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 SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
string _sourcetablenameh = "pu_ArrHead";
string _sourcetablenameb = "pu_ArrBody";
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //ClassFactory.GetITaskLogMain(3);;
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);
ApiService.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.TaskLog.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);
ApiService.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 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 ";
sql += " '" + cimodel.UserId + "' as cMaker,";
sql += " lt.MOCODE as mes_MOCODE ,"; //生产订单号
sql += " lt.MOSEQ as mes_MOSEQ ,"; //订单行号
sql += " lt.ITEMCODE as mes_ITEMCODE ,"; //物料编码
sql += " lt.OPSeq as mes_OPSeq ,"; //工序行号
sql += " lt.OPCode as mes_OPCode, "; //工序编号
sql += " lt.OPDescription as mes_OPDescription, "; //工序说明
sql += " lt.PersonCode as mes_PersonCode, "; //人员编码
sql += " lt.ResCode as mes_ResCode, "; //资源编码
sql += " lt.Istatus as mes_Istatus, "; //状态
sql += " lt.Qty as mes_Qty, "; //数量
sql += " lt.StartDate as mes_StartDate, "; //开工日期
sql += " lt.StartTime as mes_StartTime, "; //开工时间
sql += " lt.ISCOMDATE as mes_ISCOMDATE, "; //完工时间
sql += " lt.ISCOMTIME as mes_ISCOMTIME, "; //完工时间
sql += " lt.opdoccode as mes_opdoccode, "; //生成的工序转移单号
sql += " lt.workdoccode as mes_workdoccode "; //生成的工时记录单号
sql += " from " + headtable + " lt 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)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select ";
sql += " '" + cimodel.UserId + "' as cMaker,";
sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as dTVDate "; //移库日期
sql += ",'" + System.DateTime.Now.ToString(SysInfo.datetimeFormat) + "' as dnmaketime, "; //制单时间
sql += " lt.cTvCode as mes_cTvCode ,";
sql += " lt.cIDepCode as mes_T_cIDepCode ,";
sql += " lt.cODepCode as mes_T_cODepCode ,";
sql += " lt.cIWhCode as mes_cIWhCode ,";
sql += " lt.cOWhCode as mes_cOWhCode ,";
sql += " lt.cIRdCode as mes_cIRdCode ,";
sql += " lt.cORdCode as mes_cORdCode, ";
sql += " lt.cPersonCode as mes_T_cPersonCode, "; //经办人
sql += " lt.cremark as mes_cTVMemo ";
sql += " from " + bodytable + " lb with(nolock) 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);
ApiService.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 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);
}
/// <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 MES_cWhCode,lt.Qty as mes_qty,lt.ISCOMDATE as mes_ISCOMDATE,lt.ISCOMTIME as mes_ISCOMTIME,lt.cRdCode as cCode ";
sql += " from mom_orderdetail b with(nolock) inner join mom_order t with(nolock) on b.moid = t.moid inner join " + headtable + " lt with(nolock) on lt.mocode = t.mocode and lt.[MOSEQ] = b.[SortSeq] 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)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select t.*,lt.cWhCode as cWhCode ,lt.cRdCode as cCode ";
sql += ",'" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate ";
sql += ",'生产订单' as cSource ";
sql += " from v_mom_order_wf t with(nolock) 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);
}
/// <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 = "SaleOrderQ";
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select t.*,";
sql += "lt." + voucherNoColumnName + " as cCode ";
sql += ",'" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate ";
sql += ",lt.cRemark as mes_t_cRemark ";
sql += " from " + _sourcetablenameh + " t with(nolock) left join " + headtable + " lt with(nolock) on lt.cSoCode = t.cSoCode where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.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)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
//string sql = "select mrd.*,mr.moid,mr.modid,"; // mrd.FirstFlag 1 首工序
//sql += " '" + cimodel.UserId + "' as cMaker,";
//sql += " '" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as dTVDate "; //移库日期
//sql += ",'" + System.DateTime.Now.ToString(SysInfo.datetimeFormat) + "' as dnmaketime, "; //制单时间
//sql += " lt.MOCODE as mes_MOCODE ,"; //生产订单号
//sql += " lt.MOSEQ as mes_MOSEQ ,"; //订单行号
//sql += " lt.ITEMCODE as mes_ITEMCODE ,"; //物料编码
//sql += " lt.OPSeq as mes_OPSeq ,"; //工序行号
//sql += " lt.OPCode as mes_OPCode, "; //工序编号
//sql += " lt.OPDescription as mes_OPDescription, "; //工序说明
//sql += " lt.PersonCode as mes_PersonCode, "; //人员编码
//sql += " lt.ResCode as mes_ResCode, "; //资源编码
//sql += " lt.Istatus as mes_Istatus, "; //状态
//sql += " lt.Qty as mes_Qty, "; //数量
//sql += " lt.StartDate as mes_StartDate, "; //开工日期
//sql += " lt.StartTime as mes_StartTime, "; //开工时间
//sql += " lt.ISCOMDATE as mes_ISCOMDATE, "; //完工时间
//sql += " lt.ISCOMTIME as mes_ISCOMTIME, "; //完工时间
//sql += " lt.opdoccode as mes_opdoccode, "; //生成的工序转移单号
//sql += " lt.workdoccode as mes_workdoccode "; //生成的工时记录单号
//sql += " from " + headtable + " with(nolock) ";
//sql += " inner join mom_order m with(nolock) on op.mocode = m.mocode ";
//sql += " inner join sfc_morouting mr with(nolock) on m.moid = mr.moid ";
//sql += " inner join sfc_moroutingdetail mrd with(nolock) on mr.MoRoutingId = mrd.MoRoutingId and op.OPSeq = mrd.OPSeq ";
// sql += " where lt.id ='" + pdt.Id + "' ";
//DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
//DataSet ds = help.Query(sql);
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
IDataParameter[] Para = new SqlParameter[1];
Para[0] = new SqlParameter("@id", pdt.Id);
DataSet ds = help.RunProcedure("Proc_GetOptranform", Para, "MES_Int_optransform");
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 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.*,";
sql += " sb.DSortSeq as DSortSeq , ";
sql += " lt.cWhCode as MES_cWhCode,lt.cRdCode as cCode,sb.modid as modid,";
sql += " lb.iquantity as MES_iquantity, lb.cVenCode as mes_cvencode,lb.cpinvcode as mes_cpinvcode,lb.cInvCode as mes_cinvcode,lb.mocode as mes_mocode, ";
sql += " CASE lb.opertype WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
sql += " lb.MOCODE as MES_B_MOCODE ";
sql += " from " + sourceBodyTable + " sb with(nolock) INNER JOIN " + sourceHeadTable + " t with(nolock) on sb.moid = t.moid ";
sql += " INNER JOIN mom_moallocate b with(nolock) on b.modid = sb.modid ";
sql += " INNER JOIN " + bodytable + " lb with(nolock) on lb.mocode = t.mocode and lb.cinvcode = b.invcode and lb.cpinvcode = sb.dinvcode ";
sql += " 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);
ApiService.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)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select ";
sql += " lt.cvencode as MES_cvencode ";
sql += ",lt.cCusCode as mes_t_cCusCode ";
sql += ",lt.cRemark as mes_t_cRemark ";
sql += ",lt.cDefine2 as mes_t_cDefine2 ";
sql += ",'" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as 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 ";
//sql += " ,lt.cPersonCode as MES_cPersonCode ";
sql += " from " + bodytable + " lb with(nolock) 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);
ApiService.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)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select top 1 st.*,"; // t.*,";
sql += " lt.cRdCode as MES_cRdCode ,lt.ddate as MES_ddate, ";
sql += " lt.cWhCode as MES_cWhCode ,lt.cRdStyleCode as MES_cRdStyleCode, ";
sql += " lt.cDepCode as MES_cDepCode ,lt.cVenCode as MES_cVenCode, ";
sql += " lt.cPersonCode as MES_cPersonCode ,lt.cRemark as MES_cRemark, ";
sql += " '采购退货单' as cSource ";
sql += " from " + headtable + " lt with(nolock) ";
sql += " INNER JOIN " + bodytable + " lb with(nolock) on lb.id = lt.id ";
sql += " INNER JOIN " + sourceBodyTable + " sb with(nolock) on sb.autoid = lb.dhid ";
sql += " INNER JOIN " + sourceHeadTable + " st with(nolock) on sb.id = st.id ";
sql += " where lt.id ='" + pdt.Id + "' ";
DbHelperSQLP help = new DbHelperSQLP(cimodel.Constring);
DataSet ds = help.Query(sql);
ApiService.BLL.Common.ErrorMsg(ds, "未能获取采购退货单表头信息");
return(ds);
}
public override System.Data.DataSet SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata)
{
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
return(U8.Interface.Bus.ApiService.Voucher.DAL.Common.GetSourceDetailDataset(pdt.Cvouchertype, pdt.Cvoucherno, cimodel.Constring));
}
