public void Execute()
{
string sql = "";
string LogName = Context.JobDetail.JobDataMap.GetString("LogName");
int Days = Context.JobDetail.JobDataMap.GetInt("Days");
DbHelp dbHelp = new DbHelp(ConnString);
#region 执行任务语句
sql = string.Format("DELETE FROM [dbo].[sys_oper_log] WHERE createTime < '{0}';", DateTime.Now.AddDays(-1 * double.Parse(Days.ToString())));
dbHelp.DataOperator(sql);
sql = string.Format("DELETE FROM [dbo].[sys_job_log] WHERE createTime < '{0}';", DateTime.Now.AddDays(-1 * double.Parse(Days.ToString())));
dbHelp.DataOperator(sql);
#endregion
}
public void Execute()
{
DbHelp dbHelp = new DbHelp(ConnString);
string sql = string.Format(@"SELECT dbo.order_header.code,dbo.order_header.productCode,dbo.order_header.partMaterialCode,dbo.order_header.planQty FROM dbo.order_header WHERE dbo.order_header.status = '{0}'; ", OrderStatus.已准备);
DataSet ds = dbHelp.SelectGet(sql);
List <OrderHeader> ohlist = new List <OrderHeader>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderHeader orderheader = new OrderHeader();
orderheader.Code = dr["code"].ToString();
orderheader.ProductCode = dr["productCode"].ToString();
if (string.IsNullOrEmpty(dr["partMaterialCode"].ToString()))
{
orderheader.PartMaterialCode = dr["productCode"].ToString();
}
else
{
orderheader.PartMaterialCode = dr["partMaterialCode"].ToString();
}
orderheader.PlanQty = decimal.Parse(dr["planQty"].ToString());
ohlist.Add(orderheader);
}
if (ohlist.Count == ds.Tables[0].Rows.Count)
{
foreach (OrderHeader oh in ohlist)
{
string sqlmd = string.Format(@"SELECT * FROM dbo.material_demand where dbo.material_demand.orderCode = '{0}'; ", oh.Code);
DataSet materialdemand = dbHelp.SelectGet(sqlmd);
if (materialdemand.Tables[0].Rows.Count < 1)
{
string sqls = string.Format(@"SELECT * FROM dbo.mbom_header where dbo.mbom_header.productCode= '{0}'; ", oh.ProductCode);
DataSet mbomh = dbHelp.SelectGet(sqls);
if (mbomh.Tables[0].Rows.Count > 0)
{
string sqlmbd = string.Format(@"SELECT * FROM dbo.mbom_detail where dbo.mbom_detail.mbomHeaderId = {0}; ", int.Parse(mbomh.Tables[0].Rows[0]["id"].ToString()));
DataSet mbomdt = dbHelp.SelectGet(sqlmbd);
if (mbomdt.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < mbomdt.Tables[0].Rows.Count; i++)
{
string materialsql = string.Format("SELECT dbo.material.classABC FROM dbo.material where dbo.material.code = '{0}'; ", mbomdt.Tables[0].Rows[i]["materialCode"].ToString());
DataSet mateialds = dbHelp.SelectGet(materialsql);
decimal?DamandQty = oh.PlanQty * decimal.Parse(mbomdt.Tables[0].Rows[i]["BaseQty"].ToString());
string insql = string.Format(@"INSERT INTO [dbo].[material_demand] ([orderCode],[productCode],[partMaterialCode],[materialCode],[damandQty],[distributeQty],[status],[classABC],[createTime],[createBy])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'); ",
oh.Code, oh.ProductCode, oh.PartMaterialCode, mbomdt.Tables[0].Rows[i]["materialCode"].ToString(), DamandQty, decimal.Parse(mbomdt.Tables[0].Rows[i]["baseQty"].ToString()), "ready", mateialds.Tables[0].Rows[0]["classABC"].ToString(), DateTime.Now, "AutoJob");
dbHelp.DataOperator(insql);
}
}
}
}
}
}
}
public void LoggerJob()
{
string sql = "";
DbHelp dbHelp = new DbHelp(ConnString);
#region 更新任务时间
sql = string.Format("UPDATE [dbo].[sys_job] SET lastFireTime = '{0}', nextFireTime = '{1}' WHERE jobName = '{2}';", LastFireTime, NextFireTime, JobName);
dbHelp.DataOperator(sql);
#endregion
#region 记录任务日志
stopwatch.Stop();
JobMessage = "总共耗时:" + stopwatch.Elapsed.TotalMilliseconds.ToString() + " 毫秒";
JobName = JobName.Replace("'", "''");
JobGroup = JobGroup.Replace("'", "''");
MethodName = MethodName.Replace("'", "''");
MethodParams = MethodParams.Replace("'", "''");
JobMessage = JobMessage.Replace("'", "''");
ExceptionInfo = ExceptionInfo.Replace("'", "''");
sql = string.Format(@"INSERT INTO [dbo].[sys_job_log]
([jobName]
,[jobGroup]
,[methodName]
,[methodParams]
,[jobMessage]
,[exceptionInfo]
,[createTime]
,[createBy])
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
, GETDATE()
, 'System')", JobName, JobGroup, MethodName, MethodParams, JobMessage, ExceptionInfo);
dbHelp.DataOperator(sql);
#endregion
}
public void Execute()
{
DbHelp dbHelp = new DbHelp(ConnString);
string sql = string.Format(@"SELECT * FROM dbo.order_header WHERE dbo.order_header.status = '{0}'; ", OrderStatus.完成);
DataSet ds = dbHelp.SelectGet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//获取工单历史表,确定历史表中有此条数据
string orderhsql = string.Format(@"SELECT * FROM dbo.order_header_history WHERE dbo.order_header_history.code = '{0}'; ", dr["code"]);
DataSet ohds = dbHelp.SelectGet(orderhsql);
if (ohds.Tables[0].Rows.Count > 0)
{
string deldetail = string.Format(@"DELETE FROM dbo.order_detiail WHERE dbo.order_detiail.orderHeaderId = {0}; ", dr["id"]);
dbHelp.DataOperator(deldetail);
string delheader = string.Format(@"DELETE FROM dbo.order_header WHERE dbo.order_header.id = {0}; ", dr["id"]);
dbHelp.DataOperator(delheader);
}
}
}
}
private void Log(bool bresult)
{
Stopwatch.Stop();
try
{
if (string.IsNullOrEmpty(ConnString))
{
return;
}
string type = "发送";
string system = _System;
string method = _method;
string server = Server;
string path = _requestApi;
string[] paths = _requestApi.Split('/');
paths = paths[paths.Length - 1].Split('?');
string actionName = paths[0];
string queryString = paths.Length > 1 ? paths[1] : "";
string apiGroup = _apiGroup;
string request = _request;
string response = _response;
double totalMilliseconds = Stopwatch.Elapsed.TotalMilliseconds;
string logTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string name = "MES";
string ip = "";
string browser = "";
string result = bresult ? "成功" : "失败";
int flag = 1;
string createTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string createBy = "MES";
DbHelp dbHelp = new DbHelp(ConnString);
string sql = string.Format(@"INSERT INTO [dbo].[sys_interface_log]
([type]
,[system]
,[method]
,[server]
,[path]
,[actionName]
,[queryString]
,[apiGroup]
,[request]
,[response]
,[totalMilliseconds]
,[logTime]
,[name]
,[ip]
,[browser]
,[result]
,[flag]
,[createTime]
,[createBy])
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
,'{6}'
,'{7}'
,'{8}'
,'{9}'
,'{10}'
,'{11}'
,'{12}'
,'{13}'
,'{14}'
,'{15}'
,'{16}'
,'{17}'
,'{18}')",
type
, system
, method
, server
, path
, actionName
, queryString
, apiGroup
, request
, response
, totalMilliseconds
, logTime
, name
, ip
, browser
, result
, flag
, createTime
, createBy
);
dbHelp.DataOperator(sql);
}
catch (Exception ex) {
throw ex;
}
}
public void Execute()
{
DbHelp dbHelp = new DbHelp(ConnString);
string sql = string.Format(@"SELECT dbo.order_header.code,dbo.order_header.productCode,dbo.order_header.partMaterialCode,dbo.order_header.status,
(SELECT ISNULL(dbo.order_detiail.serialNumber, '') FROM dbo.order_detiail WHERE dbo.order_header.code=dbo.order_detiail.orderCode) AS serialNumber
FROM dbo.order_header WHERE dbo.order_header.status <> '{0}' AND dbo.order_header.status <> '{1}' AND dbo.order_header.status <> '{2}' AND dbo.order_header.planEndTime < GETDATE()
ORDER BY dbo.order_header.code ASC,dbo.order_header.planStartTime ASC; ", OrderStatus.完成, OrderStatus.已冻结, OrderStatus.已撤消);
DataSet ds = dbHelp.SelectGet(sql);
List <OrderAlert> oalist = new List <OrderAlert>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderAlert orderAlert = new OrderAlert();
orderAlert.OrderCode = dr["code"].ToString();
orderAlert.ProductCode = dr["productCode"].ToString();
orderAlert.PartMaterialCode = dr["partMaterialCode"].ToString();
orderAlert.SerialNumber = dr["serialNumber"].ToString();
orderAlert.AlertMsg = "已逾期未按计划时间完成生产";
orderAlert.Flag = 0;
orderAlert.IsSpeak = true;
orderAlert.Status = dr["status"].ToString();
oalist.Add(orderAlert);
}
if (oalist.Count == ds.Tables[0].Rows.Count)
{
foreach (OrderAlert oalt in oalist)
{
string sqls = string.Format(@"SELECT top 1 orderCode FROM dbo.order_alert WHERE dbo.order_alert.orderCode = '{0}' AND Flag=0; ", oalt.OrderCode);
DataSet dsalert = dbHelp.SelectGet(sqls);
if (dsalert.Tables[0].Rows.Count < 1)
{
string insql = string.Format(@"INSERT INTO [dbo].[order_alert] ([orderCode],[productCode],[partMaterialCode],[serialNumber],[status],[AlertMsg],[Flag],[IsSpeak],[createTime],[createBy])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','Job'); ", oalt.OrderCode, oalt.ProductCode, oalt.PartMaterialCode, oalt.SerialNumber, oalt.Status, oalt.AlertMsg, oalt.Flag, oalt.IsSpeak, DateTime.Now);
dbHelp.DataOperator(insql);
}
}
}
string donesql = string.Format(@"SELECT dbo.order_header.code,dbo.order_header.productCode,dbo.order_header.partMaterialCode,dbo.order_header.status,
(SELECT ISNULL(dbo.order_detiail.serialNumber, '') FROM dbo.order_detiail WHERE dbo.order_header.code=dbo.order_detiail.orderCode) AS serialNumber
FROM dbo.order_header WHERE (dbo.order_header.status = '{0}' OR dbo.order_header.status='{1}' OR dbo.order_header.status='{2}') AND dbo.order_header.planEndTime < GETDATE()
ORDER BY dbo.order_header.code ASC,dbo.order_header.planStartTime ASC; ", OrderStatus.完成, OrderStatus.已冻结, OrderStatus.已撤消);
DataSet doneds = dbHelp.SelectGet(donesql);
List <OrderAlert> orderAlerts = new List <OrderAlert>();
foreach (DataRow dr in doneds.Tables[0].Rows)
{
OrderAlert orderAlert = new OrderAlert();
orderAlert.OrderCode = dr["code"].ToString();
//orderAlert.ProductCode = dr["productCode"].ToString();
//orderAlert.PartMaterialCode = dr["partMaterialCode"].ToString();
//orderAlert.SerialNumber = dr["serialNumber"].ToString();
orderAlert.Flag = 1;
orderAlert.IsSpeak = false;
orderAlert.Status = dr["status"].ToString();
orderAlerts.Add(orderAlert);
}
if (orderAlerts.Count == ds.Tables[0].Rows.Count)
{
foreach (OrderAlert oalt in orderAlerts)
{
string sqls = string.Format(@"SELECT top 1 orderCode FROM dbo.order_alert WHERE dbo.order_alert.orderCode = '{0}' AND Flag=0; ", oalt.OrderCode);
DataSet dsalert = dbHelp.SelectGet(sqls);
if (dsalert.Tables[0].Rows.Count > 0)
{
string upsql = string.Format(@"UPDATE [dbo].[order_alert] set [status]='{0}', [Flag]='{1}',[IsSpeak]='{2}',[updatetime]='{4}',[updateBy]='Job' WHERE [orderCode]='{3}'; ", oalt.Status, oalt.Flag, oalt.IsSpeak, oalt.OrderCode, DateTime.Now);
dbHelp.DataOperator(upsql);
}
}
}
}
public void Execute()
{
DbHelp dbHelp = new DbHelp(ConnString);
string sql = string.Format(@"SELECT [id],[needStation],[locationCode],[callTime],[callType] FROM [dbo].[material_call_header] WHERE [dbo].[material_call_header].[status] = '{0}'; ", CallStatus.已准备);
DataSet ds = dbHelp.SelectGet(sql);
var ccode = "";
List <MaterialCallHeader> chlist = new List <MaterialCallHeader>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
MaterialCallHeader callheader = new MaterialCallHeader();
callheader.Id = int.Parse(dr["id"].ToString());
callheader.NeedStation = dr["needStation"].ToString();
callheader.LocationCode = dr["locationCode"].ToString();
callheader.CallTime = DateTime.Parse(dr["callTime"].ToString());
callheader.CallType = dr["callType"].ToString();
chlist.Add(callheader);
}
if (chlist.Count == ds.Tables[0].Rows.Count)
{
foreach (MaterialCallHeader callhd in chlist)
{
string sqlmdth = string.Format(@"SELECT * FROM [dbo].[material_distribute_task_header] WHERE [dbo].[material_distribute_task_header].materialCallId = {0}; ", callhd.Id);
DataSet materialdthd = dbHelp.SelectGet(sqlmdth);
if (materialdthd.Tables[0].Rows.Count < 1)
{ //读取叫料明细数据
string calldtsql = string.Format("SELECT * FROM dbo.material_call_detail where dbo.material_call_detail.callHeaderId = {0}; ", callhd.Id);
DataSet calldtds = dbHelp.SelectGet(calldtsql);
//取料框ABC类别
string ABCsql = string.Format("SELECT * FROM dbo.location where dbo.location.code = '{0}'; ", callhd.LocationCode);
DataSet ABCds = dbHelp.SelectGet(ABCsql);
if (!string.IsNullOrEmpty(ABCds.Tables[0].Rows[0]["ContainerCode"].ToString()))
{
ccode = ABCds.Tables[0].Rows[0]["ContainerCode"].ToString();
}
string taskNo = "";
if (callhd.CallType == CallType.料)
{
string product = "";
string productid = "";
string confirm = MaterialConfirm.已确认.ToString();
if (ABCds.Tables[0].Rows[0]["type"].ToString() != "C")
{
product = calldtds.Tables[0].Rows[0]["productCode"].ToString();
productid = calldtds.Tables[0].Rows[0]["productId"].ToString();
confirm = MaterialConfirm.未确认.ToString();
}
if (ABCds.Tables[0].Rows[0]["Status"].ToString() == LocationStatus.空仓位)
{//第一次叫料，直接生成配送任务
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.工位叫料), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
parameters[1].Direction = ParameterDirection.Output;
taskNo = dbHelp.ProcOutput("Proc_GetTaskNo", parameters, "@NEW_ID").ToString();//生成任务号
//写入物料配送任务主表
string intaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[productId],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}'); ",
taskNo, callhd.Id, product, ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, "", callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.料配送, "", callhd.LocationCode, productid, confirm);
dbHelp.DataOperator(intaskhdsql);
}
else
{//先生成取空料框任务
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.取空料框), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
parameters[1].Direction = ParameterDirection.Output;
string emptyTaskNo = dbHelp.ProcOutput("Proc_GetTaskNo", parameters, "@NEW_ID").ToString();//生成任务号
//写入物料配送任务主表
string intaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'); ",
emptyTaskNo, callhd.Id, "", ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, ccode, callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.回收料框, callhd.LocationCode, "", MaterialConfirm.已确认);
dbHelp.DataOperator(intaskhdsql);
//再生成配送任务
SqlParameter[] gparameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.工位叫料), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
gparameters[1].Direction = ParameterDirection.Output;
taskNo = dbHelp.ProcOutput("Proc_GetTaskNo", gparameters, "@NEW_ID").ToString();//生成任务号
//写入物料配送任务主表
string gintaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[productId],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}'); ",
taskNo, callhd.Id, product, ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, "", callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.料配送, "", callhd.LocationCode, productid, confirm);
dbHelp.DataOperator(gintaskhdsql);
}
//写入配送明细表逻辑
if (calldtds.Tables[0].Rows.Count > 0)
{
//遍历叫料明细数据
foreach (DataRow item in calldtds.Tables[0].Rows)
{
//获取写入的配送头表信息
string dtaskheadersql = string.Format(@"SELECT * FROM [dbo].[material_distribute_task_header] WHERE [dbo].[material_distribute_task_header].taskNo = '{0}'; ", taskNo);
DataSet dtaskheaderds = dbHelp.SelectGet(dtaskheadersql);
if (dtaskheaderds.Tables[0].Rows.Count > 0)
{
//获取物料需求表数据
string materialmdsql = string.Format(@"SELECT * FROM dbo.material_demand where dbo.material_demand.orderCode = '{0}'; ", item["orderCode"].ToString());
DataSet materialmdds = dbHelp.SelectGet(materialmdsql);
if (materialmdds.Tables[0].Rows.Count > 0)
{
//遍历物料需求数据
foreach (DataRow mditem in materialmdds.Tables[0].Rows)
{
if (mditem["classABC"].ToString() == ABCds.Tables[0].Rows[0]["type"].ToString())
{
string intaskdtsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_detail] ([materialDistributeTaskHeaderId],[orderCode],[materialCode],[serialNumber],[qty],[userCode],[createTime],[createBy])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'); ",
dtaskheaderds.Tables[0].Rows[0]["id"].ToString(), mditem["orderCode"].ToString(), mditem["materialCode"].ToString(), item["serialNumber"].ToString(), mditem["distributeQty"].ToString(), "AutoJob", DateTime.Now, "AutoJob");
dbHelp.DataOperator(intaskdtsql);
}
}
}
}
}
}
}
else if (callhd.CallType == CallType.料)
{
if (ABCds.Tables[0].Rows[0]["Status"].ToString() == LocationStatus.空仓位)
{//第一次呼叫下料，先补空料框
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.补给空框), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
parameters[1].Direction = ParameterDirection.Output;
taskNo = dbHelp.ProcOutput("Proc_GetTaskNo", parameters, "@NEW_ID").ToString(); //生成任务号
//写入物料配送任务主表
string intaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'); ",
taskNo, callhd.Id, "", ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, "", callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.补给料框, "", callhd.LocationCode, MaterialConfirm.已确认);
dbHelp.DataOperator(intaskhdsql);
}
else
{//生成下料任务
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.成品下料), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
parameters[1].Direction = ParameterDirection.Output;
taskNo = dbHelp.ProcOutput("Proc_GetTaskNo", parameters, "@NEW_ID").ToString();//生成任务号
//写入物料配送任务主表
string intaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'); ",
taskNo, callhd.Id, "", ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, ccode, callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.料取件, callhd.LocationCode, "", MaterialConfirm.已确认);
dbHelp.DataOperator(intaskhdsql);
//下料完成后，补给空料框任务
SqlParameter[] bparameters = new SqlParameter[] { new SqlParameter("@TASKTYPE", AGVTaskNo.补给空框), new SqlParameter("@NEW_ID", SqlDbType.VarChar, 32) };
bparameters[1].Direction = ParameterDirection.Output;
taskNo = dbHelp.ProcOutput("Proc_GetTaskNo", bparameters, "@NEW_ID").ToString();//生成任务号
//写入物料配送任务主表
string bintaskhdsql = string.Format(@"INSERT INTO [dbo].[material_distribute_task_header] ([taskNo],[materialCallId],[productCode],[containerType],[userCode],[needStation],[locationCode],[containerCode],[needTime],[status],[createTime],[createBy],[callType],[startPlace],[EndPlace],[materialConfirm])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'); ",
taskNo, callhd.Id, "", ABCds.Tables[0].Rows[0]["type"].ToString(), "AutoJob", callhd.NeedStation, callhd.LocationCode, "", callhd.CallTime, "1", DateTime.Now, "AutoJob", TaskType.补给料框, "", callhd.LocationCode, MaterialConfirm.已确认);
dbHelp.DataOperator(bintaskhdsql);
}
}
}
}
}
}