/// <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 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.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);
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);
}
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 _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);
}
/// <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);
}
/// <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 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.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>
/// <returns></returns>
public Model.ConnectInfo GetConnectInfo(Model.Synergismlogdt dt)
{
DAL.Regist rdal = new Regist();
Model.Regist rmdoel = rdal.GetModel(dt.Accid);
if (rmdoel != null)
{
Model.ConnectInfo cimodel = new Model.ConnectInfo();
cimodel.AccId = rmdoel.Cacc_id;
cimodel.Source = rmdoel.Datasource;
cimodel.Password = rmdoel.Cpassword;
cimodel.Srv = rmdoel.Caddress;
//应用服务器 add by wangdd
cimodel.sSrv = rmdoel.Cservername;
cimodel.SubId = "DP"; //测试
cimodel.UserId = rmdoel.Cuser_id;
cimodel.YearId = rmdoel.Ibeginyear.ToString();
cimodel.Serial = BLL.Common.GetSerial();
cimodel.BEnable = rmdoel.Benable == "1" || rmdoel.Benable == "是";
cimodel.Constring = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID=sa;Password={2};Current Language=Simplified Chinese", rmdoel.Caddress, rmdoel.Caccname, rmdoel.Cdbpwd);
cimodel.Date = BLL.Common.GetVerifyData(dt);
if (cimodel.Date == DateTime.Now.ToString("yyyy-MM-dd"))
{
cimodel.Date = BLL.Common.GetLoginDate(rmdoel);
}
return(cimodel);
}
return(null);
}
/// <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 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 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>
/// <returns></returns>
public static string GetVerifyData(Model.Synergismlogdt dt)
{
string strDefault = DateTime.Now.ToString("yyyy-MM-dd").Replace('.', '-').Replace('/', '-');
if (dt.Ilineno <= 1)
{
return(strDefault);
}
BLL.TaskLog.ITaskLogDetail bllDT = ClassFactory.GetITaskLogDetailBLL(dt.TaskType);
DAL.TaskLog.ITaskLogDetail dalDT = ClassFactory.GetITaskLogDetailDAL(dt.TaskType);
Model.Synergismlogdt dtPrev;
dtPrev = bllDT.GetPrevious(dt, dt.OP);
Model.ConnectInfo ConnectStr = dalDT.getConnectStr(dtPrev);
return(DAL.Common.GetVerifyDate(ConnectStr, dtPrev));
}
/// <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 t.*,";
sql += "lt.cWhCode as MES_cWhCode ,lt.cRdCode as cCode,lt.cvencode as mes_cvencode, lt.cDepCode as mes_cdepcode,lt.cRdStyleCode as MES_cRdStyleCode ";
sql += ",'" + System.DateTime.Now.ToString(SysInfo.dateFormat) + "' as ddate,";
sql += " lb.MoCode as MES_T_MOCODE ";
sql += ",'生产订单' as cSource ";
sql += " from " + sourceHeadTable + " t with(nolock) INNER JOIN " + bodytable + " lb with(nolock) on lb.mocode = t.mocode 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>
/// <returns></returns>
public Model.ConnectInfo GetConnectInfo(Model.Synergismlogdt dt)
{
Model.Regist rmdoel = new U8.Interface.Bus.ApiService.Model.Regist();
rmdoel.Cservername = U8.Interface.Bus.Config.ConfigUtility.U8AppSrv; //string dbname = Comm.RegistryKeyHelp.getValueRegEdit(SysInfo.u8path, "dbname");
rmdoel.Cacc_id = U8.Interface.Bus.Config.ConfigUtility.U8AppAcc; //"888";
rmdoel.Cuser_id = U8.Interface.Bus.Config.ConfigUtility.U8AppUser; // string username = Comm.RegistryKeyHelp.getValueRegEdit(SysInfo.u8path, "username");
rmdoel.Cmaker = U8.Interface.Bus.Config.ConfigUtility.U8AppUser;
rmdoel.Cpassword = U8.Interface.Bus.Comm.DESEncrypt.Decrypt(U8.Interface.Bus.Config.ConfigUtility.U8AppPwd); // Comm.RegistryKeyHelp.getValueRegEdit(SysInfo.u8path, "pwd"); pwd = Comm.DESEncrypt.Decrypt(pwd);
rmdoel.Benable = "1";
rmdoel.Datasource = "(default)";
rmdoel.Caccname = U8.Interface.Bus.Config.ConfigUtility.DataBaseCatalog; // ConfigurationManager.AppSettings["dbcatalogname"]; //UFDATA_888_2015
rmdoel.Cdbpwd = U8.Interface.Bus.Comm.DESEncrypt.Decrypt(U8.Interface.Bus.Config.ConfigUtility.DataBasePwd); // ConfigurationManager.AppSettings["dbpwd"];
rmdoel.Caddress = U8.Interface.Bus.Config.ConfigUtility.DataBaseSrv; // ConfigurationManager.AppSettings["dbserver"];
if (rmdoel != null)
{
Model.ConnectInfo cimodel = new Model.ConnectInfo();
cimodel.AccId = rmdoel.Cacc_id;
cimodel.Source = rmdoel.Datasource;
cimodel.Password = rmdoel.Cpassword;
cimodel.Srv = rmdoel.Caddress;
//应用服务器 add by wangdd
cimodel.sSrv = rmdoel.Cservername;
cimodel.SubId = "DP"; //测试
cimodel.UserId = rmdoel.Cuser_id;
if (string.IsNullOrEmpty(U8.Interface.Bus.Config.ConfigUtility.U8AppYear)) //rmdoel.Ibeginyear.ToString();
{
cimodel.YearId = DateTime.Now.ToString("yyyy");
}
else
{
cimodel.YearId = U8.Interface.Bus.Config.ConfigUtility.U8AppYear;
}
cimodel.Serial = ApiService.BLL.Common.GetSerial();
cimodel.BEnable = rmdoel.Benable == "1" || rmdoel.Benable == "是";
cimodel.Constring = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID=sa;Password={2};Current Language=Simplified Chinese", rmdoel.Caddress, rmdoel.Caccname, rmdoel.Cdbpwd);
//cimodel.Date = BLL.Common.GetVerifyData(dt);
//if (cimodel.Date == DateTime.Now.ToString("yyyy-MM-dd")) cimodel.Date = BLL.Common.GetLoginDate(rmdoel);
cimodel.Date = DateTime.Now.ToString("yyyy-MM-dd");
return(cimodel);
}
return(null);
}
/// <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 = "SaleOrderQ";
string _sourcetablenameb = "SaleOrderSQ";
ApiService.DAL.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType); //ClassFactory.GetITaskLogMain(3);;
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select b.*,";
sql += " CASE lb.opertype WHEN 0 THEN 'A' WHEN 1 THEN 'M' WHEN '2' THEN 'D' ELSE 'A' END as editprop, ";
sql += " lb.cWhCode as mes_cWhCode,lb.iquantity as mes_iquantity,lb.cvencode as mes_cvencode ";
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.isosid = b.isosid 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 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.TaskLog.ITaskLogDetail dtdal = ClassFactory.GetITaskLogDetailDAL(apidata.TaskType);
Model.ConnectInfo cimodel = dtdal.GetConnectInfo(pdt);
string sql = "select ";
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.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);
}
/// <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.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 += " 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 += " 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);
}
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));
}
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));
}
