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 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";
}
dao.Open();
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);
dao.Close();
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 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 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";
}
dao.Open();
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);
dao.Close();
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);
}
}
