/// <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; } } } }