/// <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.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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); 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.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 SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata) { ApiService.DAL.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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 += " 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 , "; sql += " lb.iquantity as MES_iquantity, "; sql += " lb.iquantity 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); 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.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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 SetFromTabets(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata) { ApiService.DAL.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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 SetFromTabet(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata) { string sourceHeadTable = "pu_ArrHead"; string sourceBodyTable = "pu_ArrBody"; ApiService.DAL.TaskLogFactory.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); 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 SetFromTabetsChild(Model.Synergismlogdt dt, Model.Synergismlogdt pdt, Model.APIData apidata) { ApiService.DAL.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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); 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.TaskLogFactory.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); 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.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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); 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.TaskLogFactory.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.cAVCode as mes_cAVCode ,"; 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.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); 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.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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); 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.TaskLogFactory.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //new ApiService.DAL.SynergismLogDt(); 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.TaskLogFactory.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); 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.TaskLogFactory.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 += " 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); 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.TaskLogFactory.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.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.cRdCode as cCode,"; 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 += " 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); 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.TaskLogFactory.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); 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.TaskLogFactory.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); BLL.Common.ErrorMsg(ds, "未能获取 表头信息"); return(ds); }