/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Rec_RefDepend GetModel(string strCondition)
{
List<Sys_Rec_RefDepend> list = instance.GetListByWhere(strCondition);
Sys_Rec_RefDepend model = new Sys_Rec_RefDepend();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 更新单据参考依赖关系 Sys_Rec_RefDepend对象(即:一条记录
/// </summary>
public int Update(Sys_Rec_RefDepend sys_Rec_RefDepend)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Sys_Rec_RefDepend SET ");
if(sys_Rec_RefDepend.RefDepend_Code_IsChanged){sbParameter.Append("RefDepend_Code=@RefDepend_Code, ");}
if(sys_Rec_RefDepend.RefDepend_Type_IsChanged){sbParameter.Append("RefDepend_Type=@RefDepend_Type, ");}
if(sys_Rec_RefDepend.RefDepend_Object_IsChanged){sbParameter.Append("RefDepend_Object=@RefDepend_Object, ");}
if(sys_Rec_RefDepend.RefDepend_ObjectName_IsChanged){sbParameter.Append("RefDepend_ObjectName=@RefDepend_ObjectName, ");}
if(sys_Rec_RefDepend.RefDepend_ShowMain_IsChanged){sbParameter.Append("RefDepend_ShowMain=@RefDepend_ShowMain, ");}
if(sys_Rec_RefDepend.RefDepend_ShowOther_IsChanged){sbParameter.Append("RefDepend_ShowOther=@RefDepend_ShowOther, ");}
if(sys_Rec_RefDepend.RefDepend_ShowName_IsChanged){sbParameter.Append("RefDepend_ShowName=@RefDepend_ShowName, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF1_IsChanged){sbParameter.Append("RefDepend_UDEF1=@RefDepend_UDEF1, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF2_IsChanged){sbParameter.Append("RefDepend_UDEF2=@RefDepend_UDEF2, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF3_IsChanged){sbParameter.Append("RefDepend_UDEF3=@RefDepend_UDEF3, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF4_IsChanged){sbParameter.Append("RefDepend_UDEF4=@RefDepend_UDEF4, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF5_IsChanged){sbParameter.Append("RefDepend_UDEF5=@RefDepend_UDEF5, ");}
if(sys_Rec_RefDepend.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF6_IsChanged){sbParameter.Append("RefDepend_UDEF6=@RefDepend_UDEF6, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF7_IsChanged){sbParameter.Append("RefDepend_UDEF7=@RefDepend_UDEF7, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF8_IsChanged){sbParameter.Append("RefDepend_UDEF8=@RefDepend_UDEF8, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF9_IsChanged){sbParameter.Append("RefDepend_UDEF9=@RefDepend_UDEF9, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF10_IsChanged){sbParameter.Append("RefDepend_UDEF10=@RefDepend_UDEF10, ");}
if(sys_Rec_RefDepend.RefDepend_ConfFlag_IsChanged){sbParameter.Append("RefDepend_ConfFlag=@RefDepend_ConfFlag, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF11_IsChanged){sbParameter.Append("RefDepend_UDEF11=@RefDepend_UDEF11, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF12_IsChanged){sbParameter.Append("RefDepend_UDEF12=@RefDepend_UDEF12, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF13_IsChanged){sbParameter.Append("RefDepend_UDEF13=@RefDepend_UDEF13, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF14_IsChanged){sbParameter.Append("RefDepend_UDEF14=@RefDepend_UDEF14, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF15_IsChanged){sbParameter.Append("RefDepend_UDEF15=@RefDepend_UDEF15, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF16_IsChanged){sbParameter.Append("RefDepend_UDEF16=@RefDepend_UDEF16, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF17_IsChanged){sbParameter.Append("RefDepend_UDEF17=@RefDepend_UDEF17, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF18_IsChanged){sbParameter.Append("RefDepend_UDEF18=@RefDepend_UDEF18, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF19_IsChanged){sbParameter.Append("RefDepend_UDEF19=@RefDepend_UDEF19, ");}
if(sys_Rec_RefDepend.RefDepend_UDEF20_IsChanged){sbParameter.Append("RefDepend_UDEF20=@RefDepend_UDEF20 ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and RefDepend_ID=@RefDepend_ID; " );
string sql=sb.ToString();
if(sys_Rec_RefDepend.RefDepend_Code_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Code))
{
idb.AddParameter("@RefDepend_Code", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Code", sys_Rec_RefDepend.RefDepend_Code);
}
}
if(sys_Rec_RefDepend.RefDepend_Type_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Type))
{
idb.AddParameter("@RefDepend_Type", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Type", sys_Rec_RefDepend.RefDepend_Type);
}
}
if(sys_Rec_RefDepend.RefDepend_Object_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Object))
{
idb.AddParameter("@RefDepend_Object", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Object", sys_Rec_RefDepend.RefDepend_Object);
}
}
if(sys_Rec_RefDepend.RefDepend_ObjectName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ObjectName))
{
idb.AddParameter("@RefDepend_ObjectName", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ObjectName", sys_Rec_RefDepend.RefDepend_ObjectName);
}
}
if(sys_Rec_RefDepend.RefDepend_ShowMain_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowMain))
{
idb.AddParameter("@RefDepend_ShowMain", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowMain", sys_Rec_RefDepend.RefDepend_ShowMain);
}
}
if(sys_Rec_RefDepend.RefDepend_ShowOther_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowOther))
{
idb.AddParameter("@RefDepend_ShowOther", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowOther", sys_Rec_RefDepend.RefDepend_ShowOther);
}
}
if(sys_Rec_RefDepend.RefDepend_ShowName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowName))
{
idb.AddParameter("@RefDepend_ShowName", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowName", sys_Rec_RefDepend.RefDepend_ShowName);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF1_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF1))
{
idb.AddParameter("@RefDepend_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF1", sys_Rec_RefDepend.RefDepend_UDEF1);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF2_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF2))
{
idb.AddParameter("@RefDepend_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF2", sys_Rec_RefDepend.RefDepend_UDEF2);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF3_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF3))
{
idb.AddParameter("@RefDepend_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF3", sys_Rec_RefDepend.RefDepend_UDEF3);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF4_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF4))
{
idb.AddParameter("@RefDepend_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF4", sys_Rec_RefDepend.RefDepend_UDEF4);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF5_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF5))
{
idb.AddParameter("@RefDepend_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF5", sys_Rec_RefDepend.RefDepend_UDEF5);
}
}
if(sys_Rec_RefDepend.Stat_IsChanged)
{
if (sys_Rec_RefDepend.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Rec_RefDepend.Stat);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF6_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF6))
{
idb.AddParameter("@RefDepend_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF6", sys_Rec_RefDepend.RefDepend_UDEF6);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF7_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF7))
{
idb.AddParameter("@RefDepend_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF7", sys_Rec_RefDepend.RefDepend_UDEF7);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF8_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF8))
{
idb.AddParameter("@RefDepend_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF8", sys_Rec_RefDepend.RefDepend_UDEF8);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF9_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF9))
{
idb.AddParameter("@RefDepend_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF9", sys_Rec_RefDepend.RefDepend_UDEF9);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF10_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF10))
{
idb.AddParameter("@RefDepend_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF10", sys_Rec_RefDepend.RefDepend_UDEF10);
}
}
if(sys_Rec_RefDepend.RefDepend_ConfFlag_IsChanged)
{
if (sys_Rec_RefDepend.RefDepend_ConfFlag == 0)
{
idb.AddParameter("@RefDepend_ConfFlag", 0);
}
else
{
idb.AddParameter("@RefDepend_ConfFlag", sys_Rec_RefDepend.RefDepend_ConfFlag);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF11_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF11))
{
idb.AddParameter("@RefDepend_UDEF11", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF11", sys_Rec_RefDepend.RefDepend_UDEF11);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF12_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF12))
{
idb.AddParameter("@RefDepend_UDEF12", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF12", sys_Rec_RefDepend.RefDepend_UDEF12);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF13_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF13))
{
idb.AddParameter("@RefDepend_UDEF13", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF13", sys_Rec_RefDepend.RefDepend_UDEF13);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF14_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF14))
{
idb.AddParameter("@RefDepend_UDEF14", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF14", sys_Rec_RefDepend.RefDepend_UDEF14);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF15_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF15))
{
idb.AddParameter("@RefDepend_UDEF15", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF15", sys_Rec_RefDepend.RefDepend_UDEF15);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF16_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF16))
{
idb.AddParameter("@RefDepend_UDEF16", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF16", sys_Rec_RefDepend.RefDepend_UDEF16);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF17_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF17))
{
idb.AddParameter("@RefDepend_UDEF17", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF17", sys_Rec_RefDepend.RefDepend_UDEF17);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF18_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF18))
{
idb.AddParameter("@RefDepend_UDEF18", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF18", sys_Rec_RefDepend.RefDepend_UDEF18);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF19_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF19))
{
idb.AddParameter("@RefDepend_UDEF19", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF19", sys_Rec_RefDepend.RefDepend_UDEF19);
}
}
if(sys_Rec_RefDepend.RefDepend_UDEF20_IsChanged)
{
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF20))
{
idb.AddParameter("@RefDepend_UDEF20", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF20", sys_Rec_RefDepend.RefDepend_UDEF20);
}
}
idb.AddParameter("@RefDepend_ID", sys_Rec_RefDepend.RefDepend_ID);
return idb.ExeCmd(sql);
}
/// <summary>
/// 获取指定的单据参考依赖关系 Sys_Rec_RefDepend对象集合
/// </summary>
public List<Sys_Rec_RefDepend> GetListByWhere(string strCondition)
{
List<Sys_Rec_RefDepend> ret = new List<Sys_Rec_RefDepend>();
string sql = "SELECT RefDepend_ID,RefDepend_Code,RefDepend_Type,RefDepend_Object,RefDepend_ObjectName,RefDepend_ShowMain,RefDepend_ShowOther,RefDepend_ShowName,RefDepend_UDEF1,RefDepend_UDEF2,RefDepend_UDEF3,RefDepend_UDEF4,RefDepend_UDEF5,Stat,RefDepend_UDEF6,RefDepend_UDEF7,RefDepend_UDEF8,RefDepend_UDEF9,RefDepend_UDEF10,RefDepend_ConfFlag,RefDepend_UDEF11,RefDepend_UDEF12,RefDepend_UDEF13,RefDepend_UDEF14,RefDepend_UDEF15,RefDepend_UDEF16,RefDepend_UDEF17,RefDepend_UDEF18,RefDepend_UDEF19,RefDepend_UDEF20 FROM Sys_Rec_RefDepend WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
sql += " ORDER BY RefDepend_ID DESC ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_Rec_RefDepend sys_Rec_RefDepend = new Sys_Rec_RefDepend();
if (dr["RefDepend_ID"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ID = Convert.ToDecimal(dr["RefDepend_ID"]);
if (dr["RefDepend_Code"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Code = Convert.ToString(dr["RefDepend_Code"]);
if (dr["RefDepend_Type"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Type = Convert.ToString(dr["RefDepend_Type"]);
if (dr["RefDepend_Object"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Object = Convert.ToString(dr["RefDepend_Object"]);
if (dr["RefDepend_ObjectName"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ObjectName = Convert.ToString(dr["RefDepend_ObjectName"]);
if (dr["RefDepend_ShowMain"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowMain = Convert.ToString(dr["RefDepend_ShowMain"]);
if (dr["RefDepend_ShowOther"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowOther = Convert.ToString(dr["RefDepend_ShowOther"]);
if (dr["RefDepend_ShowName"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowName = Convert.ToString(dr["RefDepend_ShowName"]);
if (dr["RefDepend_UDEF1"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF1 = Convert.ToString(dr["RefDepend_UDEF1"]);
if (dr["RefDepend_UDEF2"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF2 = Convert.ToString(dr["RefDepend_UDEF2"]);
if (dr["RefDepend_UDEF3"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF3 = Convert.ToString(dr["RefDepend_UDEF3"]);
if (dr["RefDepend_UDEF4"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF4 = Convert.ToString(dr["RefDepend_UDEF4"]);
if (dr["RefDepend_UDEF5"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF5 = Convert.ToString(dr["RefDepend_UDEF5"]);
if (dr["Stat"] != DBNull.Value) sys_Rec_RefDepend.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["RefDepend_UDEF6"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF6 = Convert.ToString(dr["RefDepend_UDEF6"]);
if (dr["RefDepend_UDEF7"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF7 = Convert.ToString(dr["RefDepend_UDEF7"]);
if (dr["RefDepend_UDEF8"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF8 = Convert.ToString(dr["RefDepend_UDEF8"]);
if (dr["RefDepend_UDEF9"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF9 = Convert.ToString(dr["RefDepend_UDEF9"]);
if (dr["RefDepend_UDEF10"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF10 = Convert.ToString(dr["RefDepend_UDEF10"]);
if (dr["RefDepend_ConfFlag"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ConfFlag = Convert.ToInt32(dr["RefDepend_ConfFlag"]);
if (dr["RefDepend_UDEF11"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF11 = Convert.ToString(dr["RefDepend_UDEF11"]);
if (dr["RefDepend_UDEF12"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF12 = Convert.ToString(dr["RefDepend_UDEF12"]);
if (dr["RefDepend_UDEF13"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF13 = Convert.ToString(dr["RefDepend_UDEF13"]);
if (dr["RefDepend_UDEF14"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF14 = Convert.ToString(dr["RefDepend_UDEF14"]);
if (dr["RefDepend_UDEF15"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF15 = Convert.ToString(dr["RefDepend_UDEF15"]);
if (dr["RefDepend_UDEF16"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF16 = Convert.ToString(dr["RefDepend_UDEF16"]);
if (dr["RefDepend_UDEF17"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF17 = Convert.ToString(dr["RefDepend_UDEF17"]);
if (dr["RefDepend_UDEF18"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF18 = Convert.ToString(dr["RefDepend_UDEF18"]);
if (dr["RefDepend_UDEF19"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF19 = Convert.ToString(dr["RefDepend_UDEF19"]);
if (dr["RefDepend_UDEF20"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF20 = Convert.ToString(dr["RefDepend_UDEF20"]);
ret.Add(sys_Rec_RefDepend);
}
}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>
/// 获取指定的单据参考依赖关系 Sys_Rec_RefDepend对象(即:一条记录
/// </summary>
public Sys_Rec_RefDepend GetByKey(decimal refDepend_ID)
{
Sys_Rec_RefDepend sys_Rec_RefDepend = new Sys_Rec_RefDepend();
string sql = "SELECT RefDepend_ID,RefDepend_Code,RefDepend_Type,RefDepend_Object,RefDepend_ObjectName,RefDepend_ShowMain,RefDepend_ShowOther,RefDepend_ShowName,RefDepend_UDEF1,RefDepend_UDEF2,RefDepend_UDEF3,RefDepend_UDEF4,RefDepend_UDEF5,Stat,RefDepend_UDEF6,RefDepend_UDEF7,RefDepend_UDEF8,RefDepend_UDEF9,RefDepend_UDEF10,RefDepend_ConfFlag,RefDepend_UDEF11,RefDepend_UDEF12,RefDepend_UDEF13,RefDepend_UDEF14,RefDepend_UDEF15,RefDepend_UDEF16,RefDepend_UDEF17,RefDepend_UDEF18,RefDepend_UDEF19,RefDepend_UDEF20 FROM Sys_Rec_RefDepend WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND RefDepend_ID=@RefDepend_ID ";
idb.AddParameter("@RefDepend_ID", refDepend_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["RefDepend_ID"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ID = Convert.ToDecimal(dr["RefDepend_ID"]);
if (dr["RefDepend_Code"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Code = Convert.ToString(dr["RefDepend_Code"]);
if (dr["RefDepend_Type"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Type = Convert.ToString(dr["RefDepend_Type"]);
if (dr["RefDepend_Object"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_Object = Convert.ToString(dr["RefDepend_Object"]);
if (dr["RefDepend_ObjectName"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ObjectName = Convert.ToString(dr["RefDepend_ObjectName"]);
if (dr["RefDepend_ShowMain"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowMain = Convert.ToString(dr["RefDepend_ShowMain"]);
if (dr["RefDepend_ShowOther"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowOther = Convert.ToString(dr["RefDepend_ShowOther"]);
if (dr["RefDepend_ShowName"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ShowName = Convert.ToString(dr["RefDepend_ShowName"]);
if (dr["RefDepend_UDEF1"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF1 = Convert.ToString(dr["RefDepend_UDEF1"]);
if (dr["RefDepend_UDEF2"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF2 = Convert.ToString(dr["RefDepend_UDEF2"]);
if (dr["RefDepend_UDEF3"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF3 = Convert.ToString(dr["RefDepend_UDEF3"]);
if (dr["RefDepend_UDEF4"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF4 = Convert.ToString(dr["RefDepend_UDEF4"]);
if (dr["RefDepend_UDEF5"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF5 = Convert.ToString(dr["RefDepend_UDEF5"]);
if (dr["Stat"] != DBNull.Value) sys_Rec_RefDepend.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["RefDepend_UDEF6"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF6 = Convert.ToString(dr["RefDepend_UDEF6"]);
if (dr["RefDepend_UDEF7"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF7 = Convert.ToString(dr["RefDepend_UDEF7"]);
if (dr["RefDepend_UDEF8"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF8 = Convert.ToString(dr["RefDepend_UDEF8"]);
if (dr["RefDepend_UDEF9"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF9 = Convert.ToString(dr["RefDepend_UDEF9"]);
if (dr["RefDepend_UDEF10"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF10 = Convert.ToString(dr["RefDepend_UDEF10"]);
if (dr["RefDepend_ConfFlag"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_ConfFlag = Convert.ToInt32(dr["RefDepend_ConfFlag"]);
if (dr["RefDepend_UDEF11"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF11 = Convert.ToString(dr["RefDepend_UDEF11"]);
if (dr["RefDepend_UDEF12"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF12 = Convert.ToString(dr["RefDepend_UDEF12"]);
if (dr["RefDepend_UDEF13"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF13 = Convert.ToString(dr["RefDepend_UDEF13"]);
if (dr["RefDepend_UDEF14"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF14 = Convert.ToString(dr["RefDepend_UDEF14"]);
if (dr["RefDepend_UDEF15"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF15 = Convert.ToString(dr["RefDepend_UDEF15"]);
if (dr["RefDepend_UDEF16"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF16 = Convert.ToString(dr["RefDepend_UDEF16"]);
if (dr["RefDepend_UDEF17"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF17 = Convert.ToString(dr["RefDepend_UDEF17"]);
if (dr["RefDepend_UDEF18"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF18 = Convert.ToString(dr["RefDepend_UDEF18"]);
if (dr["RefDepend_UDEF19"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF19 = Convert.ToString(dr["RefDepend_UDEF19"]);
if (dr["RefDepend_UDEF20"] != DBNull.Value) sys_Rec_RefDepend.RefDepend_UDEF20 = Convert.ToString(dr["RefDepend_UDEF20"]);
}
}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 sys_Rec_RefDepend;
}
/// <summary>
/// 添加单据参考依赖关系 Sys_Rec_RefDepend对象(即:一条记录)
/// </summary>
public int Add(Sys_Rec_RefDepend sys_Rec_RefDepend)
{
string sql = "INSERT INTO Sys_Rec_RefDepend (RefDepend_Code,RefDepend_Type,RefDepend_Object,RefDepend_ObjectName,RefDepend_ShowMain,RefDepend_ShowOther,RefDepend_ShowName,RefDepend_UDEF1,RefDepend_UDEF2,RefDepend_UDEF3,RefDepend_UDEF4,RefDepend_UDEF5,Stat,RefDepend_UDEF6,RefDepend_UDEF7,RefDepend_UDEF8,RefDepend_UDEF9,RefDepend_UDEF10,RefDepend_ConfFlag,RefDepend_UDEF11,RefDepend_UDEF12,RefDepend_UDEF13,RefDepend_UDEF14,RefDepend_UDEF15,RefDepend_UDEF16,RefDepend_UDEF17,RefDepend_UDEF18,RefDepend_UDEF19,RefDepend_UDEF20) VALUES (@RefDepend_Code,@RefDepend_Type,@RefDepend_Object,@RefDepend_ObjectName,@RefDepend_ShowMain,@RefDepend_ShowOther,@RefDepend_ShowName,@RefDepend_UDEF1,@RefDepend_UDEF2,@RefDepend_UDEF3,@RefDepend_UDEF4,@RefDepend_UDEF5,@Stat,@RefDepend_UDEF6,@RefDepend_UDEF7,@RefDepend_UDEF8,@RefDepend_UDEF9,@RefDepend_UDEF10,@RefDepend_ConfFlag,@RefDepend_UDEF11,@RefDepend_UDEF12,@RefDepend_UDEF13,@RefDepend_UDEF14,@RefDepend_UDEF15,@RefDepend_UDEF16,@RefDepend_UDEF17,@RefDepend_UDEF18,@RefDepend_UDEF19,@RefDepend_UDEF20)";
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Code))
{
idb.AddParameter("@RefDepend_Code", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Code", sys_Rec_RefDepend.RefDepend_Code);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Type))
{
idb.AddParameter("@RefDepend_Type", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Type", sys_Rec_RefDepend.RefDepend_Type);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_Object))
{
idb.AddParameter("@RefDepend_Object", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_Object", sys_Rec_RefDepend.RefDepend_Object);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ObjectName))
{
idb.AddParameter("@RefDepend_ObjectName", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ObjectName", sys_Rec_RefDepend.RefDepend_ObjectName);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowMain))
{
idb.AddParameter("@RefDepend_ShowMain", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowMain", sys_Rec_RefDepend.RefDepend_ShowMain);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowOther))
{
idb.AddParameter("@RefDepend_ShowOther", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowOther", sys_Rec_RefDepend.RefDepend_ShowOther);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_ShowName))
{
idb.AddParameter("@RefDepend_ShowName", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_ShowName", sys_Rec_RefDepend.RefDepend_ShowName);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF1))
{
idb.AddParameter("@RefDepend_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF1", sys_Rec_RefDepend.RefDepend_UDEF1);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF2))
{
idb.AddParameter("@RefDepend_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF2", sys_Rec_RefDepend.RefDepend_UDEF2);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF3))
{
idb.AddParameter("@RefDepend_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF3", sys_Rec_RefDepend.RefDepend_UDEF3);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF4))
{
idb.AddParameter("@RefDepend_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF4", sys_Rec_RefDepend.RefDepend_UDEF4);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF5))
{
idb.AddParameter("@RefDepend_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF5", sys_Rec_RefDepend.RefDepend_UDEF5);
}
if (sys_Rec_RefDepend.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Rec_RefDepend.Stat);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF6))
{
idb.AddParameter("@RefDepend_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF6", sys_Rec_RefDepend.RefDepend_UDEF6);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF7))
{
idb.AddParameter("@RefDepend_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF7", sys_Rec_RefDepend.RefDepend_UDEF7);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF8))
{
idb.AddParameter("@RefDepend_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF8", sys_Rec_RefDepend.RefDepend_UDEF8);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF9))
{
idb.AddParameter("@RefDepend_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF9", sys_Rec_RefDepend.RefDepend_UDEF9);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF10))
{
idb.AddParameter("@RefDepend_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF10", sys_Rec_RefDepend.RefDepend_UDEF10);
}
if (sys_Rec_RefDepend.RefDepend_ConfFlag == 0)
{
idb.AddParameter("@RefDepend_ConfFlag", 0);
}
else
{
idb.AddParameter("@RefDepend_ConfFlag", sys_Rec_RefDepend.RefDepend_ConfFlag);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF11))
{
idb.AddParameter("@RefDepend_UDEF11", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF11", sys_Rec_RefDepend.RefDepend_UDEF11);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF12))
{
idb.AddParameter("@RefDepend_UDEF12", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF12", sys_Rec_RefDepend.RefDepend_UDEF12);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF13))
{
idb.AddParameter("@RefDepend_UDEF13", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF13", sys_Rec_RefDepend.RefDepend_UDEF13);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF14))
{
idb.AddParameter("@RefDepend_UDEF14", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF14", sys_Rec_RefDepend.RefDepend_UDEF14);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF15))
{
idb.AddParameter("@RefDepend_UDEF15", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF15", sys_Rec_RefDepend.RefDepend_UDEF15);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF16))
{
idb.AddParameter("@RefDepend_UDEF16", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF16", sys_Rec_RefDepend.RefDepend_UDEF16);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF17))
{
idb.AddParameter("@RefDepend_UDEF17", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF17", sys_Rec_RefDepend.RefDepend_UDEF17);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF18))
{
idb.AddParameter("@RefDepend_UDEF18", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF18", sys_Rec_RefDepend.RefDepend_UDEF18);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF19))
{
idb.AddParameter("@RefDepend_UDEF19", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF19", sys_Rec_RefDepend.RefDepend_UDEF19);
}
if (string.IsNullOrEmpty(sys_Rec_RefDepend.RefDepend_UDEF20))
{
idb.AddParameter("@RefDepend_UDEF20", DBNull.Value);
}
else
{
idb.AddParameter("@RefDepend_UDEF20", sys_Rec_RefDepend.RefDepend_UDEF20);
}
return idb.ExeCmd(sql);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_Rec_RefDepend 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>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Sys_Rec_RefDepend 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'>实体</param>
/// <returns>bool</returns>
public bool Insert(Sys_Rec_RefDepend model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
/// <summary>
/// 根据单据模块获取配置
/// </summary>
/// <param name="hepler"></param>
/// <param name="itype"></param>
/// <returns></returns>
public static Sys_Rec_RefDepend Comm_Ref_Config(this HtmlHelper hepler, string itype)
{
Sys_Rec_RefDepend model = new Sys_Rec_RefDepend();
ADOSys_Rec_RefDepend instance = new ADOSys_Rec_RefDepend();
var list = instance.GetListByWhere(" and RefDepend_Code='" + itype + "' ");
if (list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
