//更新配置
public void Update(WorkFlowCfg flowCfg)
{
SqlParameter[] sqlParams =
{
new SqlParameter("id", flowCfg.id),
new SqlParameter("flowType", flowCfg.flowType),
new SqlParameter("workShop", flowCfg.flowType),
new SqlParameter("workShopName", flowCfg.flowType),
new SqlParameter("flowIdentify", flowCfg.flowType),
new SqlParameter("flowName", flowCfg.flowType),
new SqlParameter("timeBoundary_left", flowCfg.flowType),
new SqlParameter("timeBoundary_right", flowCfg.flowType),
new SqlParameter("withPlanID", flowCfg.flowType),
new SqlParameter("enable", flowCfg.flowType),
new SqlParameter("necessary", flowCfg.necessary)
};
string sql = @"select count(*) from TAB_Plan_WorkFlowCfg where strFlowIdentify = @flowIdentify and strflowType = @flowType and @nID <> @id";
if (Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, sql, sqlParams)) > 0)
{
throw new Exception(string.Format("已存在流程类型为\"{0}\" 流程标识为\"{1}\"的配置信息.", flowCfg.flowType, flowCfg.flowIdentify));
}
sql = @"udpate TAB_Plan_WorkFlowCfg set strflowType = @flowType,strWorkShop = @workShop,strWorkShopName = @workShopName,
strFlowIdentify = @flowIdentify,strFlowName = @flowName,nTimeBoundary_left = @timeBoundary_left,
nTimeBoundary_right=@timeBoundary_right,nWithPlanID=@withPlanID,nEnable=@enable,nNecessary = @necessary) where nID = @id";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, sqlParams);
}
//查询配置列表
public void Query(string flowType, string workShop, List <WorkFlowCfg> cfgs)
{
cfgs.Clear();
string sql = @"select * from TAB_Plan_WorkFlowCfg where 1=1";
if (!string.IsNullOrEmpty(flowType))
{
sql += string.Format(" and strFlowType = '{0}'", flowType);
}
if (!string.IsNullOrEmpty(workShop))
{
sql += string.Format(" and strWorkShop = '{0}'", workShop);
}
WorkFlowCfg cfg;
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
cfg = new WorkFlowCfg();
DataRowToCfg(dr, cfg);
cfgs.Add(cfg);
}
}
//删除配置信息
public InterfaceRet Del(string data)
{
_ret.Clear();
WorkFlowCfg workFlowCfg = Newtonsoft.Json.JsonConvert.DeserializeObject <WorkFlowCfg>(data);
_dbWorkFlowCfg.Del(workFlowCfg.id);
return(_ret);
}
//数据行信息填充到实体
private void DataRowToCfg(DataRow dr, WorkFlowCfg cfg)
{
cfg.id = ObjectConvertClass.static_ext_int(dr["nID"]);
cfg.flowType = ObjectConvertClass.static_ext_string(dr["strFlowType"]);
cfg.flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]);
cfg.flowName = ObjectConvertClass.static_ext_string(dr["strFlowName"]);
cfg.timeBoundary_left = ObjectConvertClass.static_ext_int(dr["nTimeBoundary_left"]);
cfg.timeBoundary_right = ObjectConvertClass.static_ext_int(dr["nTimeBoundary_right"]);
cfg.withPlanID = ObjectConvertClass.static_ext_int(dr["nWithPlanID"]);
cfg.workShop = ObjectConvertClass.static_ext_string(dr["strWorkShop"]);
cfg.workShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
cfg.necessary = ObjectConvertClass.static_ext_int(dr["nNecessary"]);
cfg.lackFlowHint = ObjectConvertClass.static_ext_string(dr["strLackFlowHint"]);
}
//通过flowType,flowIdentify查找配置
public WorkFlowCfg Find(string flowType, string flowIdentify)
{
string sql = @"select * from TAB_Plan_WorkFlowCfg where strFlowType = '{0}' and strFlowIdentify = '{1}'";
sql = string.Format(sql, flowType, flowIdentify);
WorkFlowCfg cfg;
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0];
if (dt.Rows.Count > 0)
{
cfg = new WorkFlowCfg();
DataRowToCfg(dt.Rows[0], cfg);
return(cfg);
}
else
{
return(null);
}
}