public void AddDoTaskRule(T_WF_DOTASKRULE rule)
{
try
{
string insSql = "INSERT INTO T_WF_DOTASKRULE (DOTASKRULEID,COMPANYID,SYSTEMCODE,SYSTEMNAME,MODELCODE,MODELNAME,TRIGGERORDERSTATUS,CREATEDATETIME) VALUES (:DOTASKRULEID,:COMPANYID,:SYSTEMCODE,:SYSTEMNAME,:MODELCODE,:MODELNAME,:TRIGGERORDERSTATUS,:CREATEDATETIME)";
OracleParameter[] pageparm =
{
new OracleParameter(":DOTASKRULEID",OracleType.NVarChar,200),
new OracleParameter(":COMPANYID",OracleType.NVarChar,100),
new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100),
new OracleParameter(":SYSTEMNAME",OracleType.NVarChar,100),
new OracleParameter(":MODELCODE",OracleType.NVarChar,100),
new OracleParameter(":MODELNAME",OracleType.NVarChar,100),
new OracleParameter(":TRIGGERORDERSTATUS",OracleType.Number,22),
new OracleParameter(":CREATEDATETIME",OracleType.DateTime)
};
pageparm[0].Value = GetValue(rule.DOTASKRULEID);//待办规则主表ID
pageparm[1].Value = GetValue(rule.COMPANYID);//公司ID
pageparm[2].Value = GetValue(rule.SYSTEMCODE);//系统代码
pageparm[3].Value = GetValue(rule.SYSTEMNAME);//系统名称
pageparm[4].Value = GetValue(rule.MODELCODE);//模块代码
pageparm[5].Value = GetValue(rule.MODELNAME);//模块名称
pageparm[6].Value = GetValue(rule.TRIGGERORDERSTATUS);//触发条件的单据状态
pageparm[7].Value = GetValue(DateTime.Now);//创建日期时间
dal.ExecuteSql(insSql, pageparm);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public string EditDoTaskRule(T_WF_DOTASKRULE entity)
{
try
{
if (doTaskbll.GetBool(entity))
{
doTaskbll.EditDoTaskRule(entity);
}
else
{
return "2";
}
return "1";
}
catch (Exception ex)
{
return ex.Message;
}
}
public void EditDoTaskRule(T_WF_DOTASKRULE rule)
{
try
{
//string sql = " update T_WF_DOTASKRULE set COMPANYID='" + rule.COMPANYID + "',SYSTEMCODE='" + rule.SYSTEMCODE + "',SYSTEMNAME='" + rule.SYSTEMNAME + "',";
//sql += "MODELCODE='" + rule.MODELCODE + "',MODELNAME='" + rule.MODELNAME + "',TRIGGERORDERSTATUS=" + rule.TRIGGERORDERSTATUS + "";
//sql += " where DOTASKRULEID='" + rule.DOTASKRULEID + "'";
//dal.ExecuteSql(sql);
string updSql = "UPDATE T_WF_DOTASKRULE SET COMPANYID=:COMPANYID,SYSTEMCODE=:SYSTEMCODE,SYSTEMNAME=:SYSTEMNAME,MODELCODE=:MODELCODE,MODELNAME=:MODELNAME,TRIGGERORDERSTATUS=:TRIGGERORDERSTATUS WHERE DOTASKRULEID=:DOTASKRULEID";
OracleParameter[] pageparm =
{
new OracleParameter(":DOTASKRULEID",OracleType.NVarChar,200),
new OracleParameter(":COMPANYID",OracleType.NVarChar,100),
new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100),
new OracleParameter(":SYSTEMNAME",OracleType.NVarChar,100),
new OracleParameter(":MODELCODE",OracleType.NVarChar,100),
new OracleParameter(":MODELNAME",OracleType.NVarChar,100),
new OracleParameter(":TRIGGERORDERSTATUS",OracleType.Number,22)
};
pageparm[0].Value = GetValue(rule.DOTASKRULEID);//待办规则主表ID
pageparm[1].Value = GetValue(rule.COMPANYID);//公司ID
pageparm[2].Value = GetValue(rule.SYSTEMCODE);//系统代码
pageparm[3].Value = GetValue(rule.SYSTEMNAME);//系统名称
pageparm[4].Value = GetValue(rule.MODELCODE);//模块代码
pageparm[5].Value = GetValue(rule.MODELNAME);//模块名称
pageparm[6].Value = GetValue(rule.TRIGGERORDERSTATUS);//触发条件的单据状态
dal.ExecuteSql(updSql, pageparm);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool GetBool(T_WF_DOTASKRULE rule)
{
string sql = "select * from T_WF_DOTASKRULE where COMPANYID='" + rule.COMPANYID + "' and SYSTEMCODE='" + rule.SYSTEMCODE + "' and MODELCODE='" + rule.MODELCODE + "' and TRIGGERORDERSTATUS='" + rule.TRIGGERORDERSTATUS + "'";
sql += " and DOTASKRULEID!='" + rule.DOTASKRULEID + "'";
if (dal.GetDataTable(sql).Rows.Count > 0)
{
return false;
}
return true;
}
//自动触发规则定义
public IQueryable<V_DotaskRule> GetListFlowTrigger(string filterString, int pageIndex, int pageSize, ref int pageCount)
{
try
{
string sql = string.Empty;
if (filterString != null && filterString != "")
{
sql = "SELECT * FROM T_WF_DOTASKRULEDETAIL where " + filterString;
}
else
{
sql = "SELECT * FROM T_WF_DOTASKRULEDETAIL";
}
DataTable dtTriggerDefine = dao.GetDataTable(sql);
var items = ToList<T_WF_DOTASKRULEDETAIL>(dtTriggerDefine).AsQueryable();
if (filterString != null && filterString != "")
{
sql = "SELECT * FROM T_WF_DOTASKRULE where " + filterString;
}
else
{
sql = "SELECT * FROM T_WF_DOTASKRULE";
}
DataTable dtTriggerDefines = dao.GetDataTable(sql);
var itemes = ToList<T_WF_DOTASKRULE>(dtTriggerDefines).OrderBy(s=>s.MODELNAME);
List<V_DotaskRule> Dotaskrule = new List<V_DotaskRule>();
foreach (var item in items)
{
T_WF_DOTASKRULE rule = new T_WF_DOTASKRULE();
rule = itemes.Where(p => p.DOTASKRULEID == item.DOTASKRULEID).FirstOrDefault();
rule.DOTASKRULEDETAIL = null;
if (rule != null)
{
Dotaskrule.Add(new V_DotaskRule {
DOTASKRULE = rule,
DOTASKRULEDETAIL = item
});
}
}
Dotaskrule = Pager<V_DotaskRule>(Dotaskrule.AsQueryable(), pageIndex, pageSize, ref pageCount).ToList();
return Dotaskrule.AsQueryable();
}
catch
{
return null;
}
}
//自动触发规则定义
public IQueryable<V_DotaskRule> GetFlowTrigger(string filterString)
{
try
{
string sql = string.Empty;
string detailID = string.Empty;
if (filterString != null && filterString != "")
{
sql = "SELECT * FROM T_WF_DOTASKRULE where " + filterString;
}
else
{
sql = "SELECT * FROM T_WF_DOTASKRULE";
}
DataTable dtTriggerDefine = dao.GetDataTable(sql);
var items = ToList<T_WF_DOTASKRULE>(dtTriggerDefine).AsQueryable();
if (items.Count() > 0)
{
foreach (var item in items)
{
if (detailID == "")
{
detailID = "('" + item.DOTASKRULEID + "'";
}
else
{
detailID += ",'" + item.DOTASKRULEID + "'";
}
}
detailID += ")";
}
List<V_DotaskRule> Dotaskrule = new List<V_DotaskRule>();
if (detailID != "")
{
string strSqls = "SELECT * FROM T_WF_DOTASKRULEDETAIL where DOTASKRULEID in" + detailID;
DataTable dtTriggerDefines = dao.GetDataTable(strSqls);
var itemes = ToList<T_WF_DOTASKRULEDETAIL>(dtTriggerDefines).AsQueryable();
foreach (var item in itemes)
{
T_WF_DOTASKRULE rule = new T_WF_DOTASKRULE();
rule = items.Where(p => p.DOTASKRULEID == item.DOTASKRULEID).FirstOrDefault();
rule.DOTASKRULEDETAIL = null;
if (rule != null)
{
Dotaskrule.Add(new V_DotaskRule {
DOTASKRULE = rule,
DOTASKRULEDETAIL = item
});
}
}
}
return Dotaskrule.AsQueryable();
}
catch
{
return null;
}
}