/// <summary>
/// 返回模板配置信息
/// </summary>
/// <param name="TemplateKey">模块关键字</param>
/// <param name="TemplateCode">模块单据编码</param>
/// <returns></returns>
public Verify_TemplateConfig VerifyTemplateConfig(AuditModuleEnum TemplateKey, string TemplateCode)
{
Verify_TemplateConfig resulst = AuditTemplateConfigInstance.GetAll()
.Where(o => o.VT_Key == TemplateKey.ToString() && o.VT_Template_Code == TemplateCode).FirstOrDefault();
return(resulst);
}
public List<Verify_TemplateConfig> GetTemplateConfigList(string strCondition)
{
List<Verify_TemplateConfig> ret = new List<Verify_TemplateConfig>();
string sql = @"SELECT VT_ID,VT_Key,VT_Template_Code,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,vtc.Stat
FROM Verify_TemplateConfig vtc
JOIN Verify_Users vu on vu.VU_VerifyNode_Code =vtc.VT_VerifyNode_Code
WHERE 1=1 AND ((vtc.Stat is null) or (vtc.Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
SqlDataReader dr = null;
try
{
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
if (dr["VT_ID"] != DBNull.Value) verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
if (dr["VT_Key"] != DBNull.Value) verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
if (dr["VT_Template_Code"] != DBNull.Value) verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
if (dr["VT_VerifyNode_Code"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
if (dr["VT_VerifyNode_Name"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
if (dr["Flag"] != DBNull.Value) verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
if (dr["VT_VerifyNode_Order"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
if (dr["VT_VerifyNode_Back"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
if (dr["Stat"] != DBNull.Value) verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
ret.Add(verify_TemplateConfig);
}
}
catch (System.Exception ex) { throw ex; }
finally { if (dr != null) { dr.Close(); } }
return ret;
}
public bool UpdateConfig(Verify_TemplateConfig model)
{
if (AuditTemplateConfigInstance.Update(model) > 0)
{
return(true);
}
return(false);
}
public bool AddConfig(Verify_TemplateConfig model)
{
if (AuditTemplateConfigInstance.Add(model) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Verify_TemplateConfig model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Verify_TemplateConfig GetModel(string strCondition)
{
List<Verify_TemplateConfig> list = instance.GetListByWhere(strCondition);
Verify_TemplateConfig model = new Verify_TemplateConfig();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
public List <Verify_Users> GetVerifyUserList(string VerfiyKey, string Node)
{
bool _isLastAuditNode = false;
Verify_Users model = new Verify_Users();
//获取下一阶段节点信息
Verify_TemplateConfig nextConfig = this.VerifyNextNodes(VerfiyKey, Node, out _isLastAuditNode);
if (nextConfig != null)
{
List <Verify_Users> List = AuditUserInstance.GetAll()
.Where(o => o.VU_VerifyNode_Code == nextConfig.VT_VerifyNode_Code).ToList();
return(List);
}
return(new List <Verify_Users>());
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Verify_TemplateConfig GetModel(string strCondition)
{
List <Verify_TemplateConfig> list = instance.GetListByWhere(strCondition);
Verify_TemplateConfig model = new Verify_TemplateConfig();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Verify_TemplateConfig model, bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 逻辑删除数据
/// </summary>
/// <param name='model'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <Verify_TemplateConfig> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Verify_TemplateConfig model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Verify_TemplateConfig model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public Verify_Users GetVerifyUser(string VerfiyKey, string Node)
{
bool _isLastAuditNode = false;
Verify_Users model = new Verify_Users();
//获取下一阶段节点信息
Verify_TemplateConfig nextConfig = this.VerifyNextNodes(VerfiyKey, Node, out _isLastAuditNode);
if (nextConfig != null)
{
List <Verify_Users> List = AuditUserInstance.GetAll()
.Where(o => o.VU_VerifyNode_Code == nextConfig.VT_VerifyNode_Code).ToList();
if (List.Count > 0)
{
model = List.FirstOrDefault();
}
else
{
model = null;
}
}
return(model);
}
public bool Config(string data, string module)
{
string[] Nodes = data.TrimEnd(',').Trim().Split(',');
//当前模块对应配置阶段
List <Verify_TemplateConfig> tlist = GetTemplateConfig(module);
//所有阶段列表
List <Verify_Nodes> list = GetVerifyNodes("1=1");
int max = 0;
if (tlist.Count == 0)
{
max = 0;
}
else
{
max = tlist.Max(o => o.VT_VerifyNode_Order);
}
foreach (var n in Nodes)
{
if (string.IsNullOrEmpty(n))
{
continue;
}
var vnode = list.FirstOrDefault(o => o.VerifyNode_Code == n);
Verify_TemplateConfig config = new Verify_TemplateConfig();
config.VT_VerifyNode_Code = vnode.VerifyNode_Code;
config.VT_VerifyNode_Name = vnode.VerifyNode_Name;
config.VT_Key = module;
config.VT_VerifyNode_Order = ++max;
config.VT_Template_Code = GenerateTemplateConfigCode();
AddConfig(config);
}
return(true);
}
/// <summary>
/// 获取下一个审核节点
/// </summary>
/// <param name="VerfiyKey">模块关键字</param>
/// <param name="TemplateCode">模块编码</param>
/// <param name="CurNode">当前节点</param>
/// <param name="IsLastAuditNode">是否为最后一个审核节点</param>
/// <returns>返回下一节点信息，是否为最后一个审核节点</returns>
public Verify_TemplateConfig VerifyNextNodes(string VerfiyKey, string CurNode, out bool IsLastAuditNode)
{
IsLastAuditNode = false;
var result = this.AuditTemplateConfigInstance.GetAll()
.Where(o => o.VT_Key == VerfiyKey.ToString())
.OrderBy(o => o.VT_VerifyNode_Order);
List <Verify_TemplateConfig> list = new List <Verify_TemplateConfig>();
Verify_TemplateConfig SearchResult = new Verify_TemplateConfig();
int NextNode = 0;
if (result.Count() > 0)
{
try
{
list = result.ToList();
int CurNodeIndex = list.FindIndex(o => o.VT_VerifyNode_Code == CurNode);
if (CurNodeIndex < result.Count())
{
NextNode = CurNodeIndex + 1;
}
else
{
NextNode = result.Count();
IsLastAuditNode = true;
}
SearchResult = list[NextNode];
}
catch (System.Exception ex)
{
SearchResult = null;
}
}
else
{
SearchResult = null;
}
return(SearchResult);
}
/// <summary>
///
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public int DeleteTempldateNode(Verify_TemplateConfig node)
{
node.Stat = 1;
return Instance.Update(node);
}
/// <summary>
/// 获取下一个审核节点
/// </summary>
/// <param name="VerfiyKey">模块关键字</param>
/// <param name="TemplateCode">模块编码</param>
/// <param name="CurNode">当前节点</param>
/// <param name="IsLastAuditNode">是否为最后一个审核节点</param>
/// <returns>返回下一节点信息，是否为最后一个审核节点</returns>
public Verify_TemplateConfig VerifyNextNodes(string VerfiyKey, string CurNode, out bool IsLastAuditNode)
{
IsLastAuditNode = false;
var result = this.AuditTemplateConfigInstance.GetAll()
.Where(o => o.VT_Key == VerfiyKey.ToString())
.OrderBy(o => o.VT_VerifyNode_Order);
List<Verify_TemplateConfig> list = new List<Verify_TemplateConfig>();
Verify_TemplateConfig SearchResult = new Verify_TemplateConfig();
int NextNode = 0;
if (result.Count() > 0)
{
try
{
list = result.ToList();
int CurNodeIndex = list.FindIndex(o => o.VT_VerifyNode_Code == CurNode);
if (CurNodeIndex < result.Count())
{
NextNode = CurNodeIndex + 1;
}
else
{
NextNode = result.Count();
IsLastAuditNode = true;
}
SearchResult = list[NextNode];
}
catch (System.Exception ex)
{
SearchResult = null;
}
}
else
{
SearchResult = null;
}
return SearchResult;
}
public bool Config(string data, string module)
{
string[] Nodes = data.TrimEnd(',').Trim().Split(',');
//当前模块对应配置阶段
List<Verify_TemplateConfig> tlist = GetTemplateConfig(module);
//所有阶段列表
List<Verify_Nodes> list = GetVerifyNodes("1=1");
int max = 0;
if (tlist.Count == 0)
{
max = 0;
}
else
{
max = tlist.Max(o => o.VT_VerifyNode_Order);
}
foreach (var n in Nodes)
{
if (string.IsNullOrEmpty(n))
{
continue;
}
var vnode = list.FirstOrDefault(o => o.VerifyNode_Code == n);
Verify_TemplateConfig config = new Verify_TemplateConfig();
config.VT_VerifyNode_Code = vnode.VerifyNode_Code;
config.VT_VerifyNode_Name = vnode.VerifyNode_Name;
config.VT_Key = module;
config.VT_VerifyNode_Order = ++max;
config.VT_Template_Code = GenerateTemplateConfigCode();
AddConfig(config);
}
return true;
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Verify_TemplateConfig GetModel(int id)
{
Verify_TemplateConfig model = instance.GetByKey(id);
return(model);
}
private void InitData()
{
AuditGridInit();
FormHelper gen = new FormHelper();
gen.GenerateForm("CForm_FAuditHistory", this.pnlMain, new Point(6, 20));
RejectBackNode = adInstance.GetVerifyTemplateRejectBack(ModuleCode, CurNode);
MethodInvoker mm = new MethodInvoker(GetNextNode);
mm.BeginInvoke(null, null);
}
/// <summary>
/// 获取指定的审核模板配置表 Verify_TemplateConfig对象集合
/// </summary>
public List<Verify_TemplateConfig> GetListByWhere(string strCondition)
{
List<Verify_TemplateConfig> ret = new List<Verify_TemplateConfig>();
string sql = "SELECT VT_ID,VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode FROM Verify_TemplateConfig WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
if (dr["VT_ID"] != DBNull.Value) verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
if (dr["VT_Template_Code"] != DBNull.Value) verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
if (dr["VT_Key"] != DBNull.Value) verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
if (dr["VT_VerifyNode_Code"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
if (dr["VT_VerifyNode_Name"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
if (dr["Flag"] != DBNull.Value) verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
if (dr["VT_VerifyNode_Order"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
if (dr["VT_VerifyNode_Back"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
if (dr["VT_VerifyNode_BackName"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_BackName = Convert.ToString(dr["VT_VerifyNode_BackName"]);
if (dr["VT_Remark"] != DBNull.Value) verify_TemplateConfig.VT_Remark = Convert.ToString(dr["VT_Remark"]);
if (dr["Stat"] != DBNull.Value) verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["VT_AcSum"] != DBNull.Value) verify_TemplateConfig.VT_AcSum = Convert.ToDecimal(dr["VT_AcSum"]);
if (dr["VT_AcNodeName"] != DBNull.Value) verify_TemplateConfig.VT_AcNodeName = Convert.ToString(dr["VT_AcNodeName"]);
if (dr["VT_AcNodeCode"] != DBNull.Value) verify_TemplateConfig.VT_AcNodeCode = Convert.ToString(dr["VT_AcNodeCode"]);
ret.Add(verify_TemplateConfig);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 获取指定的审核模板配置表 Verify_TemplateConfig对象(即:一条记录
/// </summary>
public Verify_TemplateConfig GetByKey(decimal vT_ID)
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
string sql = "SELECT VT_ID,VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode FROM Verify_TemplateConfig WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND VT_ID=@VT_ID ";
idb.AddParameter("@VT_ID", vT_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["VT_ID"] != DBNull.Value)
{
verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
}
if (dr["VT_Template_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
}
if (dr["VT_Key"] != DBNull.Value)
{
verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
}
if (dr["VT_VerifyNode_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
}
if (dr["VT_VerifyNode_Name"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
}
if (dr["Flag"] != DBNull.Value)
{
verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
}
if (dr["VT_VerifyNode_Order"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
}
if (dr["VT_VerifyNode_Back"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
}
if (dr["VT_VerifyNode_BackName"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_BackName = Convert.ToString(dr["VT_VerifyNode_BackName"]);
}
if (dr["VT_Remark"] != DBNull.Value)
{
verify_TemplateConfig.VT_Remark = Convert.ToString(dr["VT_Remark"]);
}
if (dr["Stat"] != DBNull.Value)
{
verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["VT_AcSum"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcSum = Convert.ToDecimal(dr["VT_AcSum"]);
}
if (dr["VT_AcNodeName"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcNodeName = Convert.ToString(dr["VT_AcNodeName"]);
}
if (dr["VT_AcNodeCode"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcNodeCode = Convert.ToString(dr["VT_AcNodeCode"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(verify_TemplateConfig);
}
/// <summary>
/// 添加审核模板配置表 Verify_TemplateConfig对象(即:一条记录)
/// </summary>
public int Add(Verify_TemplateConfig verify_TemplateConfig)
{
string sql = "INSERT INTO Verify_TemplateConfig (VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode) VALUES (@VT_Template_Code,@VT_Key,@VT_VerifyNode_Code,@VT_VerifyNode_Name,@Flag,@VT_VerifyNode_Order,@VT_VerifyNode_Back,@VT_VerifyNode_BackName,@VT_Remark,@Stat,@VT_AcSum,@VT_AcNodeName,@VT_AcNodeCode)";
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Template_Code))
{
idb.AddParameter("@VT_Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Template_Code", verify_TemplateConfig.VT_Template_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Key))
{
idb.AddParameter("@VT_Key", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Key", verify_TemplateConfig.VT_Key);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Code))
{
idb.AddParameter("@VT_VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Code", verify_TemplateConfig.VT_VerifyNode_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Name))
{
idb.AddParameter("@VT_VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Name", verify_TemplateConfig.VT_VerifyNode_Name);
}
if (verify_TemplateConfig.Flag == 0)
{
idb.AddParameter("@Flag", 0);
}
else
{
idb.AddParameter("@Flag", verify_TemplateConfig.Flag);
}
if (verify_TemplateConfig.VT_VerifyNode_Order == 0)
{
idb.AddParameter("@VT_VerifyNode_Order", 0);
}
else
{
idb.AddParameter("@VT_VerifyNode_Order", verify_TemplateConfig.VT_VerifyNode_Order);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Back))
{
idb.AddParameter("@VT_VerifyNode_Back", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Back", verify_TemplateConfig.VT_VerifyNode_Back);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_BackName))
{
idb.AddParameter("@VT_VerifyNode_BackName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_BackName", verify_TemplateConfig.VT_VerifyNode_BackName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Remark))
{
idb.AddParameter("@VT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Remark", verify_TemplateConfig.VT_Remark);
}
if (verify_TemplateConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_TemplateConfig.Stat);
}
if (verify_TemplateConfig.VT_AcSum == 0)
{
idb.AddParameter("@VT_AcSum", 0);
}
else
{
idb.AddParameter("@VT_AcSum", verify_TemplateConfig.VT_AcSum);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeName))
{
idb.AddParameter("@VT_AcNodeName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeName", verify_TemplateConfig.VT_AcNodeName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeCode))
{
idb.AddParameter("@VT_AcNodeCode", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeCode", verify_TemplateConfig.VT_AcNodeCode);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加审核模板配置表 Verify_TemplateConfig对象(即:一条记录)
/// </summary>
public int Add(Verify_TemplateConfig verify_TemplateConfig)
{
string sql = "INSERT INTO Verify_TemplateConfig (VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode) VALUES (@VT_Template_Code,@VT_Key,@VT_VerifyNode_Code,@VT_VerifyNode_Name,@Flag,@VT_VerifyNode_Order,@VT_VerifyNode_Back,@VT_VerifyNode_BackName,@VT_Remark,@Stat,@VT_AcSum,@VT_AcNodeName,@VT_AcNodeCode)";
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Template_Code))
{
idb.AddParameter("@VT_Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Template_Code", verify_TemplateConfig.VT_Template_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Key))
{
idb.AddParameter("@VT_Key", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Key", verify_TemplateConfig.VT_Key);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Code))
{
idb.AddParameter("@VT_VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Code", verify_TemplateConfig.VT_VerifyNode_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Name))
{
idb.AddParameter("@VT_VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Name", verify_TemplateConfig.VT_VerifyNode_Name);
}
if (verify_TemplateConfig.Flag == 0)
{
idb.AddParameter("@Flag", 0);
}
else
{
idb.AddParameter("@Flag", verify_TemplateConfig.Flag);
}
if (verify_TemplateConfig.VT_VerifyNode_Order == 0)
{
idb.AddParameter("@VT_VerifyNode_Order", 0);
}
else
{
idb.AddParameter("@VT_VerifyNode_Order", verify_TemplateConfig.VT_VerifyNode_Order);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Back))
{
idb.AddParameter("@VT_VerifyNode_Back", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Back", verify_TemplateConfig.VT_VerifyNode_Back);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_BackName))
{
idb.AddParameter("@VT_VerifyNode_BackName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_BackName", verify_TemplateConfig.VT_VerifyNode_BackName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Remark))
{
idb.AddParameter("@VT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Remark", verify_TemplateConfig.VT_Remark);
}
if (verify_TemplateConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_TemplateConfig.Stat);
}
if (verify_TemplateConfig.VT_AcSum == 0)
{
idb.AddParameter("@VT_AcSum", 0);
}
else
{
idb.AddParameter("@VT_AcSum", verify_TemplateConfig.VT_AcSum);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeName))
{
idb.AddParameter("@VT_AcNodeName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeName", verify_TemplateConfig.VT_AcNodeName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeCode))
{
idb.AddParameter("@VT_AcNodeCode", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeCode", verify_TemplateConfig.VT_AcNodeCode);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = string.Empty;
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
finally
{
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex);
} return Re;
}
/// <summary>
/// 获取指定的审核模板配置表 Verify_TemplateConfig对象(即:一条记录
/// </summary>
public Verify_TemplateConfig GetByKey(decimal vT_ID)
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
string sql = "SELECT VT_ID,VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode FROM Verify_TemplateConfig WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND VT_ID=@VT_ID ";
idb.AddParameter("@VT_ID", vT_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["VT_ID"] != DBNull.Value) verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
if (dr["VT_Template_Code"] != DBNull.Value) verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
if (dr["VT_Key"] != DBNull.Value) verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
if (dr["VT_VerifyNode_Code"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
if (dr["VT_VerifyNode_Name"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
if (dr["Flag"] != DBNull.Value) verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
if (dr["VT_VerifyNode_Order"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
if (dr["VT_VerifyNode_Back"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
if (dr["VT_VerifyNode_BackName"] != DBNull.Value) verify_TemplateConfig.VT_VerifyNode_BackName = Convert.ToString(dr["VT_VerifyNode_BackName"]);
if (dr["VT_Remark"] != DBNull.Value) verify_TemplateConfig.VT_Remark = Convert.ToString(dr["VT_Remark"]);
if (dr["Stat"] != DBNull.Value) verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["VT_AcSum"] != DBNull.Value) verify_TemplateConfig.VT_AcSum = Convert.ToDecimal(dr["VT_AcSum"]);
if (dr["VT_AcNodeName"] != DBNull.Value) verify_TemplateConfig.VT_AcNodeName = Convert.ToString(dr["VT_AcNodeName"]);
if (dr["VT_AcNodeCode"] != DBNull.Value) verify_TemplateConfig.VT_AcNodeCode = Convert.ToString(dr["VT_AcNodeCode"]);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return verify_TemplateConfig;
}
public int AddTemplateNode(Verify_TemplateConfig node)
{
return Instance.Add(node);
}
/// <summary>
/// 更新审核模板配置表 Verify_TemplateConfig对象(即:一条记录
/// </summary>
public int Update(Verify_TemplateConfig verify_TemplateConfig)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Verify_TemplateConfig SET ");
if(verify_TemplateConfig.VT_Template_Code_IsChanged){sbParameter.Append("VT_Template_Code=@VT_Template_Code, ");}
if(verify_TemplateConfig.VT_Key_IsChanged){sbParameter.Append("VT_Key=@VT_Key, ");}
if(verify_TemplateConfig.VT_VerifyNode_Code_IsChanged){sbParameter.Append("VT_VerifyNode_Code=@VT_VerifyNode_Code, ");}
if(verify_TemplateConfig.VT_VerifyNode_Name_IsChanged){sbParameter.Append("VT_VerifyNode_Name=@VT_VerifyNode_Name, ");}
if(verify_TemplateConfig.Flag_IsChanged){sbParameter.Append("Flag=@Flag, ");}
if(verify_TemplateConfig.VT_VerifyNode_Order_IsChanged){sbParameter.Append("VT_VerifyNode_Order=@VT_VerifyNode_Order, ");}
if(verify_TemplateConfig.VT_VerifyNode_Back_IsChanged){sbParameter.Append("VT_VerifyNode_Back=@VT_VerifyNode_Back, ");}
if(verify_TemplateConfig.VT_VerifyNode_BackName_IsChanged){sbParameter.Append("VT_VerifyNode_BackName=@VT_VerifyNode_BackName, ");}
if(verify_TemplateConfig.VT_Remark_IsChanged){sbParameter.Append("VT_Remark=@VT_Remark, ");}
if(verify_TemplateConfig.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(verify_TemplateConfig.VT_AcSum_IsChanged){sbParameter.Append("VT_AcSum=@VT_AcSum, ");}
if(verify_TemplateConfig.VT_AcNodeName_IsChanged){sbParameter.Append("VT_AcNodeName=@VT_AcNodeName, ");}
if(verify_TemplateConfig.VT_AcNodeCode_IsChanged){sbParameter.Append("VT_AcNodeCode=@VT_AcNodeCode ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and VT_ID=@VT_ID; " );
string sql=sb.ToString();
if(verify_TemplateConfig.VT_Template_Code_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Template_Code))
{
idb.AddParameter("@VT_Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Template_Code", verify_TemplateConfig.VT_Template_Code);
}
}
if(verify_TemplateConfig.VT_Key_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Key))
{
idb.AddParameter("@VT_Key", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Key", verify_TemplateConfig.VT_Key);
}
}
if(verify_TemplateConfig.VT_VerifyNode_Code_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Code))
{
idb.AddParameter("@VT_VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Code", verify_TemplateConfig.VT_VerifyNode_Code);
}
}
if(verify_TemplateConfig.VT_VerifyNode_Name_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Name))
{
idb.AddParameter("@VT_VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Name", verify_TemplateConfig.VT_VerifyNode_Name);
}
}
if(verify_TemplateConfig.Flag_IsChanged)
{
if (verify_TemplateConfig.Flag == 0)
{
idb.AddParameter("@Flag", 0);
}
else
{
idb.AddParameter("@Flag", verify_TemplateConfig.Flag);
}
}
if(verify_TemplateConfig.VT_VerifyNode_Order_IsChanged)
{
if (verify_TemplateConfig.VT_VerifyNode_Order == 0)
{
idb.AddParameter("@VT_VerifyNode_Order", 0);
}
else
{
idb.AddParameter("@VT_VerifyNode_Order", verify_TemplateConfig.VT_VerifyNode_Order);
}
}
if(verify_TemplateConfig.VT_VerifyNode_Back_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Back))
{
idb.AddParameter("@VT_VerifyNode_Back", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Back", verify_TemplateConfig.VT_VerifyNode_Back);
}
}
if(verify_TemplateConfig.VT_VerifyNode_BackName_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_BackName))
{
idb.AddParameter("@VT_VerifyNode_BackName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_BackName", verify_TemplateConfig.VT_VerifyNode_BackName);
}
}
if(verify_TemplateConfig.VT_Remark_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Remark))
{
idb.AddParameter("@VT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Remark", verify_TemplateConfig.VT_Remark);
}
}
if(verify_TemplateConfig.Stat_IsChanged)
{
if (verify_TemplateConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_TemplateConfig.Stat);
}
}
if(verify_TemplateConfig.VT_AcSum_IsChanged)
{
if (verify_TemplateConfig.VT_AcSum == 0)
{
idb.AddParameter("@VT_AcSum", 0);
}
else
{
idb.AddParameter("@VT_AcSum", verify_TemplateConfig.VT_AcSum);
}
}
if(verify_TemplateConfig.VT_AcNodeName_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeName))
{
idb.AddParameter("@VT_AcNodeName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeName", verify_TemplateConfig.VT_AcNodeName);
}
}
if(verify_TemplateConfig.VT_AcNodeCode_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeCode))
{
idb.AddParameter("@VT_AcNodeCode", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeCode", verify_TemplateConfig.VT_AcNodeCode);
}
}
idb.AddParameter("@VT_ID", verify_TemplateConfig.VT_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = string.Empty;
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
finally
{
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex);
} return Re;
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Verify_TemplateConfig model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
public List <Verify_TemplateConfig> GetTemplateConfigList(string strCondition)
{
List <Verify_TemplateConfig> ret = new List <Verify_TemplateConfig>();
string sql = @"SELECT VT_ID,VT_Key,VT_Template_Code,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,vtc.Stat
FROM Verify_TemplateConfig vtc
JOIN Verify_Users vu on vu.VU_VerifyNode_Code =vtc.VT_VerifyNode_Code
WHERE 1=1 AND ((vtc.Stat is null) or (vtc.Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
SqlDataReader dr = null;
try
{
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
if (dr["VT_ID"] != DBNull.Value)
{
verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
}
if (dr["VT_Key"] != DBNull.Value)
{
verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
}
if (dr["VT_Template_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
}
if (dr["VT_VerifyNode_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
}
if (dr["VT_VerifyNode_Name"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
}
if (dr["Flag"] != DBNull.Value)
{
verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
}
if (dr["VT_VerifyNode_Order"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
}
if (dr["VT_VerifyNode_Back"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
}
if (dr["Stat"] != DBNull.Value)
{
verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
}
ret.Add(verify_TemplateConfig);
}
}
catch (System.Exception ex) { throw ex; }
finally { if (dr != null)
{
dr.Close();
}
}
return(ret);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Verify_TemplateConfig model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 更新审核模板配置表 Verify_TemplateConfig对象(即:一条记录
/// </summary>
public int Update(Verify_TemplateConfig verify_TemplateConfig)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Verify_TemplateConfig SET ");
if (verify_TemplateConfig.VT_Template_Code_IsChanged)
{
sbParameter.Append("VT_Template_Code=@VT_Template_Code, ");
}
if (verify_TemplateConfig.VT_Key_IsChanged)
{
sbParameter.Append("VT_Key=@VT_Key, ");
}
if (verify_TemplateConfig.VT_VerifyNode_Code_IsChanged)
{
sbParameter.Append("VT_VerifyNode_Code=@VT_VerifyNode_Code, ");
}
if (verify_TemplateConfig.VT_VerifyNode_Name_IsChanged)
{
sbParameter.Append("VT_VerifyNode_Name=@VT_VerifyNode_Name, ");
}
if (verify_TemplateConfig.Flag_IsChanged)
{
sbParameter.Append("Flag=@Flag, ");
}
if (verify_TemplateConfig.VT_VerifyNode_Order_IsChanged)
{
sbParameter.Append("VT_VerifyNode_Order=@VT_VerifyNode_Order, ");
}
if (verify_TemplateConfig.VT_VerifyNode_Back_IsChanged)
{
sbParameter.Append("VT_VerifyNode_Back=@VT_VerifyNode_Back, ");
}
if (verify_TemplateConfig.VT_VerifyNode_BackName_IsChanged)
{
sbParameter.Append("VT_VerifyNode_BackName=@VT_VerifyNode_BackName, ");
}
if (verify_TemplateConfig.VT_Remark_IsChanged)
{
sbParameter.Append("VT_Remark=@VT_Remark, ");
}
if (verify_TemplateConfig.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (verify_TemplateConfig.VT_AcSum_IsChanged)
{
sbParameter.Append("VT_AcSum=@VT_AcSum, ");
}
if (verify_TemplateConfig.VT_AcNodeName_IsChanged)
{
sbParameter.Append("VT_AcNodeName=@VT_AcNodeName, ");
}
if (verify_TemplateConfig.VT_AcNodeCode_IsChanged)
{
sbParameter.Append("VT_AcNodeCode=@VT_AcNodeCode ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and VT_ID=@VT_ID; ");
string sql = sb.ToString();
if (verify_TemplateConfig.VT_Template_Code_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Template_Code))
{
idb.AddParameter("@VT_Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Template_Code", verify_TemplateConfig.VT_Template_Code);
}
}
if (verify_TemplateConfig.VT_Key_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Key))
{
idb.AddParameter("@VT_Key", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Key", verify_TemplateConfig.VT_Key);
}
}
if (verify_TemplateConfig.VT_VerifyNode_Code_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Code))
{
idb.AddParameter("@VT_VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Code", verify_TemplateConfig.VT_VerifyNode_Code);
}
}
if (verify_TemplateConfig.VT_VerifyNode_Name_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Name))
{
idb.AddParameter("@VT_VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Name", verify_TemplateConfig.VT_VerifyNode_Name);
}
}
if (verify_TemplateConfig.Flag_IsChanged)
{
if (verify_TemplateConfig.Flag == 0)
{
idb.AddParameter("@Flag", 0);
}
else
{
idb.AddParameter("@Flag", verify_TemplateConfig.Flag);
}
}
if (verify_TemplateConfig.VT_VerifyNode_Order_IsChanged)
{
if (verify_TemplateConfig.VT_VerifyNode_Order == 0)
{
idb.AddParameter("@VT_VerifyNode_Order", 0);
}
else
{
idb.AddParameter("@VT_VerifyNode_Order", verify_TemplateConfig.VT_VerifyNode_Order);
}
}
if (verify_TemplateConfig.VT_VerifyNode_Back_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Back))
{
idb.AddParameter("@VT_VerifyNode_Back", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Back", verify_TemplateConfig.VT_VerifyNode_Back);
}
}
if (verify_TemplateConfig.VT_VerifyNode_BackName_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_BackName))
{
idb.AddParameter("@VT_VerifyNode_BackName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_BackName", verify_TemplateConfig.VT_VerifyNode_BackName);
}
}
if (verify_TemplateConfig.VT_Remark_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Remark))
{
idb.AddParameter("@VT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Remark", verify_TemplateConfig.VT_Remark);
}
}
if (verify_TemplateConfig.Stat_IsChanged)
{
if (verify_TemplateConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_TemplateConfig.Stat);
}
}
if (verify_TemplateConfig.VT_AcSum_IsChanged)
{
if (verify_TemplateConfig.VT_AcSum == 0)
{
idb.AddParameter("@VT_AcSum", 0);
}
else
{
idb.AddParameter("@VT_AcSum", verify_TemplateConfig.VT_AcSum);
}
}
if (verify_TemplateConfig.VT_AcNodeName_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeName))
{
idb.AddParameter("@VT_AcNodeName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeName", verify_TemplateConfig.VT_AcNodeName);
}
}
if (verify_TemplateConfig.VT_AcNodeCode_IsChanged)
{
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeCode))
{
idb.AddParameter("@VT_AcNodeCode", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeCode", verify_TemplateConfig.VT_AcNodeCode);
}
}
idb.AddParameter("@VT_ID", verify_TemplateConfig.VT_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Verify_TemplateConfig model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
/// <summary>
/// 获取所有的审核模板配置表 Verify_TemplateConfig对象(即:一条记录
/// </summary>
public List <Verify_TemplateConfig> GetAll()
{
List <Verify_TemplateConfig> ret = new List <Verify_TemplateConfig>();
string sql = "SELECT VT_ID,VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode FROM Verify_TemplateConfig where 1=1 AND ((Stat is null) or (Stat=0) ) order by VT_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig();
if (dr["VT_ID"] != DBNull.Value)
{
verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]);
}
if (dr["VT_Template_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]);
}
if (dr["VT_Key"] != DBNull.Value)
{
verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]);
}
if (dr["VT_VerifyNode_Code"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]);
}
if (dr["VT_VerifyNode_Name"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]);
}
if (dr["Flag"] != DBNull.Value)
{
verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]);
}
if (dr["VT_VerifyNode_Order"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]);
}
if (dr["VT_VerifyNode_Back"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]);
}
if (dr["VT_VerifyNode_BackName"] != DBNull.Value)
{
verify_TemplateConfig.VT_VerifyNode_BackName = Convert.ToString(dr["VT_VerifyNode_BackName"]);
}
if (dr["VT_Remark"] != DBNull.Value)
{
verify_TemplateConfig.VT_Remark = Convert.ToString(dr["VT_Remark"]);
}
if (dr["Stat"] != DBNull.Value)
{
verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["VT_AcSum"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcSum = Convert.ToDecimal(dr["VT_AcSum"]);
}
if (dr["VT_AcNodeName"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcNodeName = Convert.ToString(dr["VT_AcNodeName"]);
}
if (dr["VT_AcNodeCode"] != DBNull.Value)
{
verify_TemplateConfig.VT_AcNodeCode = Convert.ToString(dr["VT_AcNodeCode"]);
}
ret.Add(verify_TemplateConfig);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
public int UpdateTemplateConfig(Verify_TemplateConfig config)
{
return Instance.Update(config);
}
