/// <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.TaskLogFactory.ITaskLogDetail bllDT = new BLL.SynergisnLogDT();
DAL.SynergismLogDt dalDT = new SynergismLogDt();
Model.Synergismlogdt dtPrev;
dtPrev = bllDT.GetPrevious(dt, dt.OP);
Model.ConnectInfo ConnectStr = dalDT.getConnectStr(dtPrev);
return(DAL.Common.GetVerifyDate(ConnectStr, dtPrev));
}
public override Model.DealResult MakeVouch(BaseData bd)
{
Model.DealResult dr = new Model.DealResult();
DbHelperSQLP help = new DbHelperSQLP(bd.ConnectInfo.Constring);
string sql = "select cvalue from accinformation with(nolock) where cname = 'bSAcreat' and ISNULL(cValue,'')<>''";
string flag = help.GetSingle(sql).NullToString();
if (flag.ToLower() != "true")
{
return(base.MakeVouch(bd));
}
Model.Synergismlogdt dt = bd.Synergismlogdt;
BLL.SynergisnLogDT bll = new BLL.SynergisnLogDT();
Model.Synergismlogdt prnext = bll.GetPrevious(dt, null);
if (prnext.Cvouchertype != "01" && prnext.Cvouchertype != "03")
{
return(base.MakeVouch(bd)); //modified by liuxzha 支持退货单
}
string id = string.Empty;
int time = 1;
while (string.IsNullOrEmpty(id) && time < 5)
{
sql = "select id from rdrecord32 with(nolock) where cbuscode='" + prnext.Cvoucherno + "'";
id = help.GetSingle(sql).NullToString();
System.Threading.Thread.Sleep(1000 * time);
time++;
}
if (string.IsNullOrEmpty(id))
{
throw new Exception("未能取到U8系统自动生成的出库单!");
}
// DAL.Common.WriteWinLog(id);
dr.VouchIdRet = id;
return(dr);
}
/// <summary>
/// 任务detail BLL 工厂
/// </summary>
/// <param name="tasktype"></param>
/// <returns></returns>
public static BLL.TaskLogFactory.ITaskLogDetail GetITaskLogDetailBLL(int tasktype)
{
BLL.TaskLogFactory.ITaskLogDetail logdtbll;
switch (tasktype)
{
case 0:
logdtbll = new BLL.TaskLogFactory.CQ.TaskDetail();
break;
case 1:
logdtbll = new BLL.SynergisnLogDT();
break;
case 2:
logdtbll = new BLL.TaskLogFactory.DS.TaskDetail();
break;
default:
BLL.Common.ErrorMsg(SysInfo.productName, "tasktype" + tasktype + "未适配!");
return(null);
}
return(logdtbll);
}
/// <summary>
/// 写入协同单据的ID值，以便后续单据变号后根据ID更新最新的单据号值
/// </summary>
/// <param name="model"></param>
private void InsSYNERGISMLOGDTID(Model.Synergismlogdt model)
{
string ssql = "";
string ivoucherid = "";
string sConn = "";
List <Model.Synergismlogdt> ListSyn = new List <Model.Synergismlogdt>();
BLL.SynergisnLogDT LogDTBLL = new BLL.SynergisnLogDT();
ListSyn = LogDTBLL.GetModelList(" d.id ='" + model.Id + "' and isnull(d.cvoucherno,'')<>'' ");
for (int i = 0; i < ListSyn.Count; i++)
{
StringBuilder strSql = new StringBuilder();
Model.Synergismlogdt LogDTModel = ListSyn[i];
sConn = getConnStr(LogDTModel);
DbHelperSQLP objSql = new DbHelperSQLP(sConn);
if (sConn == "")
{
continue;
}
switch (LogDTModel.Cvouchertype)
{
case "27":
ssql = "select id from PU_AppVouch with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "24":
ssql = "select id from RdRecord01 with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "88":
ssql = "select POID from PO_Pomain with(nolock) where cPoID='" + LogDTModel.Cvoucherno + "'";
break;
case "0301":
ssql = "select id from RdRecord08 with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "0302":
ssql = "select id from RdRecord09 with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "01":
ssql = "select dlid from DispatchList with(nolock) where cdlcode='" + LogDTModel.Cvoucherno + "' and bReturnFlag=0";
break;
case "0303":
ssql = "select id from RdRecord32 with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "17":
ssql = "select id from SO_SOMain with(nolock) where cSoCode='" + LogDTModel.Cvoucherno + "'";
break;
case "26":
ssql = "select id from PU_ArrivalVouch with(nolock) where cCode='" + LogDTModel.Cvoucherno + "'";
break;
case "03":
ssql = "select dlid from DispatchList with(nolock) where cdlcode='" + LogDTModel.Cvoucherno + "' and bReturnFlag=1";
break;
default:
ssql = "";
break;
}
if (ssql != "")
{
DataSet ds = objSql.Query(ssql);
if (ds.Tables[0].Rows.Count > 0)
{
ivoucherid = ds.Tables[0].Rows[0][0].ToString();
DataSet dsC = DbHelperSQL.Query("select top 1 1 from HY_DZ_K7_SYNERGISMLOGDTID with(nolock) where ivoucherid='" + ivoucherid + "' and cvouchtype='" + LogDTModel.Cvouchertype + "' and accid='" + LogDTModel.Accid + "'");
if (dsC.Tables[0].Rows.Count > 0)
{
continue;
}
strSql.Append("insert into HY_DZ_K7_SYNERGISMLOGDTID(");
strSql.Append("autoid,accid,cvouchtype,cvoucherno,ivoucherid");
strSql.Append(") values (");
strSql.Append("@autoid,@accid,@cvouchtype,@cvoucherno,@ivoucherid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@autoid", SqlDbType.Int, 4),
new SqlParameter("@accid", SqlDbType.NVarChar, 30),
new SqlParameter("@cvouchtype", SqlDbType.NVarChar, 30),
new SqlParameter("@cvoucherno", SqlDbType.NVarChar, 30),
new SqlParameter("@ivoucherid", SqlDbType.Int, 4)
};
parameters[0].Value = LogDTModel.Autoid;
parameters[1].Value = LogDTModel.Accid;
parameters[2].Value = LogDTModel.Cvouchertype;
parameters[3].Value = LogDTModel.Cvoucherno;
parameters[4].Value = ivoucherid;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
else
{
continue;
}
}
}
}
