/// <summary>
/// 更新零件图号信息 Road_Components对象(即:一条记录
/// </summary>
public int Update(Road_Components road_Components)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Road_Components SET ");
if(road_Components.Comp_Code_IsChanged){sbParameter.Append("Comp_Code=@Comp_Code, ");}
if(road_Components.Comp_Name_IsChanged){sbParameter.Append("Comp_Name=@Comp_Name, ");}
if(road_Components.Comp_Design_IsChanged){sbParameter.Append("Comp_Design=@Comp_Design, ");}
if(road_Components.Comp_Bak_IsChanged){sbParameter.Append("Comp_Bak=@Comp_Bak, ");}
if(road_Components.Comp_Stat_IsChanged){sbParameter.Append("Comp_Stat=@Comp_Stat, ");}
if(road_Components.Comp_CatCode_IsChanged){sbParameter.Append("Comp_CatCode=@Comp_CatCode, ");}
if(road_Components.Comp_CatName_IsChanged){sbParameter.Append("Comp_CatName=@Comp_CatName, ");}
if(road_Components.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(road_Components.Comp_Order_IsChanged){sbParameter.Append("Comp_Order=@Comp_Order, ");}
if(road_Components.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");}
if(road_Components.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit, ");}
if(road_Components.Comp_CurNode_IsChanged){sbParameter.Append("Comp_CurNode=@Comp_CurNode, ");}
if(road_Components.Comp_Creator_IsChanged){sbParameter.Append("Comp_Creator=@Comp_Creator, ");}
if(road_Components.Comp_CreatTime_IsChanged){sbParameter.Append("Comp_CreatTime=@Comp_CreatTime, ");}
if(road_Components.Comp_IsBusy_IsChanged){sbParameter.Append("Comp_IsBusy=@Comp_IsBusy, ");}
if(road_Components.Comp_Udef1_IsChanged){sbParameter.Append("Comp_Udef1=@Comp_Udef1, ");}
if(road_Components.Comp_Udef2_IsChanged){sbParameter.Append("Comp_Udef2=@Comp_Udef2 ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Comp_ID=@Comp_ID; " );
string sql=sb.ToString();
if(road_Components.Comp_Code_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Code))
{
idb.AddParameter("@Comp_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Code", road_Components.Comp_Code);
}
}
if(road_Components.Comp_Name_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Name))
{
idb.AddParameter("@Comp_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Name", road_Components.Comp_Name);
}
}
if(road_Components.Comp_Design_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Design))
{
idb.AddParameter("@Comp_Design", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Design", road_Components.Comp_Design);
}
}
if(road_Components.Comp_Bak_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Bak))
{
idb.AddParameter("@Comp_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Bak", road_Components.Comp_Bak);
}
}
if(road_Components.Comp_Stat_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Stat))
{
idb.AddParameter("@Comp_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Stat", road_Components.Comp_Stat);
}
}
if(road_Components.Comp_CatCode_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_CatCode))
{
idb.AddParameter("@Comp_CatCode", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CatCode", road_Components.Comp_CatCode);
}
}
if(road_Components.Comp_CatName_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_CatName))
{
idb.AddParameter("@Comp_CatName", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CatName", road_Components.Comp_CatName);
}
}
if(road_Components.Stat_IsChanged)
{
if (road_Components.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", road_Components.Stat);
}
}
if(road_Components.Comp_Order_IsChanged)
{
if (road_Components.Comp_Order == 0)
{
idb.AddParameter("@Comp_Order", 0);
}
else
{
idb.AddParameter("@Comp_Order", road_Components.Comp_Order);
}
}
if(road_Components.AuditStat_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", road_Components.AuditStat);
}
}
if(road_Components.AuditCurAudit_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", road_Components.AuditCurAudit);
}
}
if(road_Components.Comp_CurNode_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_CurNode))
{
idb.AddParameter("@Comp_CurNode", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CurNode", road_Components.Comp_CurNode);
}
}
if(road_Components.Comp_Creator_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Creator))
{
idb.AddParameter("@Comp_Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Creator", road_Components.Comp_Creator);
}
}
if(road_Components.Comp_CreatTime_IsChanged)
{
if (road_Components.Comp_CreatTime == DateTime.MinValue)
{
idb.AddParameter("@Comp_CreatTime", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CreatTime", road_Components.Comp_CreatTime);
}
}
if(road_Components.Comp_IsBusy_IsChanged)
{
if (road_Components.Comp_IsBusy == 0)
{
idb.AddParameter("@Comp_IsBusy", 0);
}
else
{
idb.AddParameter("@Comp_IsBusy", road_Components.Comp_IsBusy);
}
}
if(road_Components.Comp_Udef1_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Udef1))
{
idb.AddParameter("@Comp_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Udef1", road_Components.Comp_Udef1);
}
}
if(road_Components.Comp_Udef2_IsChanged)
{
if (string.IsNullOrEmpty(road_Components.Comp_Udef2))
{
idb.AddParameter("@Comp_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Udef2", road_Components.Comp_Udef2);
}
}
idb.AddParameter("@Comp_ID", road_Components.Comp_ID);
return idb.ExeCmd(sql);
/// <summary>
/// 获取指定的零件图号信息 Road_Components对象集合
/// </summary>
public List<Road_Components> GetListByWhere(string strCondition)
{
List<Road_Components> ret = new List<Road_Components>();
string sql = "SELECT Comp_ID,Comp_Code,Comp_Name,Comp_Design,Comp_Bak,Comp_Stat,Comp_CatCode,Comp_CatName,Stat,Comp_Order,AuditStat,AuditCurAudit,Comp_CurNode,Comp_Creator,Comp_CreatTime,Comp_IsBusy,Comp_Udef1,Comp_Udef2 FROM Road_Components WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
sql += " ORDER BY Comp_ID DESC ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Road_Components road_Components = new Road_Components();
if (dr["Comp_ID"] != DBNull.Value) road_Components.Comp_ID = Convert.ToInt64(dr["Comp_ID"]);
if (dr["Comp_Code"] != DBNull.Value) road_Components.Comp_Code = Convert.ToString(dr["Comp_Code"]);
if (dr["Comp_Name"] != DBNull.Value) road_Components.Comp_Name = Convert.ToString(dr["Comp_Name"]);
if (dr["Comp_Design"] != DBNull.Value) road_Components.Comp_Design = Convert.ToString(dr["Comp_Design"]);
if (dr["Comp_Bak"] != DBNull.Value) road_Components.Comp_Bak = Convert.ToString(dr["Comp_Bak"]);
if (dr["Comp_Stat"] != DBNull.Value) road_Components.Comp_Stat = Convert.ToString(dr["Comp_Stat"]);
if (dr["Comp_CatCode"] != DBNull.Value) road_Components.Comp_CatCode = Convert.ToString(dr["Comp_CatCode"]);
if (dr["Comp_CatName"] != DBNull.Value) road_Components.Comp_CatName = Convert.ToString(dr["Comp_CatName"]);
if (dr["Stat"] != DBNull.Value) road_Components.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["Comp_Order"] != DBNull.Value) road_Components.Comp_Order = Convert.ToInt32(dr["Comp_Order"]);
if (dr["AuditStat"] != DBNull.Value) road_Components.AuditStat = Convert.ToString(dr["AuditStat"]);
if (dr["AuditCurAudit"] != DBNull.Value) road_Components.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
if (dr["Comp_CurNode"] != DBNull.Value) road_Components.Comp_CurNode = Convert.ToString(dr["Comp_CurNode"]);
if (dr["Comp_Creator"] != DBNull.Value) road_Components.Comp_Creator = Convert.ToString(dr["Comp_Creator"]);
if (dr["Comp_CreatTime"] != DBNull.Value) road_Components.Comp_CreatTime = Convert.ToDateTime(dr["Comp_CreatTime"]);
if (dr["Comp_IsBusy"] != DBNull.Value) road_Components.Comp_IsBusy = Convert.ToInt32(dr["Comp_IsBusy"]);
if (dr["Comp_Udef1"] != DBNull.Value) road_Components.Comp_Udef1 = Convert.ToString(dr["Comp_Udef1"]);
if (dr["Comp_Udef2"] != DBNull.Value) road_Components.Comp_Udef2 = Convert.ToString(dr["Comp_Udef2"]);
ret.Add(road_Components);
}
}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>
/// 获取所有的零件图号信息 Road_Components对象(即:一条记录
/// </summary>
public List<Road_Components> GetAll()
{
List<Road_Components> ret = new List<Road_Components>();
string sql = "SELECT Comp_ID,Comp_Code,Comp_Name,Comp_Design,Comp_Bak,Comp_Stat,Comp_CatCode,Comp_CatName,Stat,Comp_Order,AuditStat,AuditCurAudit,Comp_CurNode,Comp_Creator,Comp_CreatTime,Comp_IsBusy,Comp_Udef1,Comp_Udef2 FROM Road_Components where 1=1 AND ((Stat is null) or (Stat=0) ) order by Comp_ID desc ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Road_Components road_Components = new Road_Components();
if (dr["Comp_ID"] != DBNull.Value) road_Components.Comp_ID = Convert.ToInt64(dr["Comp_ID"]);
if (dr["Comp_Code"] != DBNull.Value) road_Components.Comp_Code = Convert.ToString(dr["Comp_Code"]);
if (dr["Comp_Name"] != DBNull.Value) road_Components.Comp_Name = Convert.ToString(dr["Comp_Name"]);
if (dr["Comp_Design"] != DBNull.Value) road_Components.Comp_Design = Convert.ToString(dr["Comp_Design"]);
if (dr["Comp_Bak"] != DBNull.Value) road_Components.Comp_Bak = Convert.ToString(dr["Comp_Bak"]);
if (dr["Comp_Stat"] != DBNull.Value) road_Components.Comp_Stat = Convert.ToString(dr["Comp_Stat"]);
if (dr["Comp_CatCode"] != DBNull.Value) road_Components.Comp_CatCode = Convert.ToString(dr["Comp_CatCode"]);
if (dr["Comp_CatName"] != DBNull.Value) road_Components.Comp_CatName = Convert.ToString(dr["Comp_CatName"]);
if (dr["Stat"] != DBNull.Value) road_Components.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["Comp_Order"] != DBNull.Value) road_Components.Comp_Order = Convert.ToInt32(dr["Comp_Order"]);
if (dr["AuditStat"] != DBNull.Value) road_Components.AuditStat = Convert.ToString(dr["AuditStat"]);
if (dr["AuditCurAudit"] != DBNull.Value) road_Components.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
if (dr["Comp_CurNode"] != DBNull.Value) road_Components.Comp_CurNode = Convert.ToString(dr["Comp_CurNode"]);
if (dr["Comp_Creator"] != DBNull.Value) road_Components.Comp_Creator = Convert.ToString(dr["Comp_Creator"]);
if (dr["Comp_CreatTime"] != DBNull.Value) road_Components.Comp_CreatTime = Convert.ToDateTime(dr["Comp_CreatTime"]);
if (dr["Comp_IsBusy"] != DBNull.Value) road_Components.Comp_IsBusy = Convert.ToInt32(dr["Comp_IsBusy"]);
if (dr["Comp_Udef1"] != DBNull.Value) road_Components.Comp_Udef1 = Convert.ToString(dr["Comp_Udef1"]);
if (dr["Comp_Udef2"] != DBNull.Value) road_Components.Comp_Udef2 = Convert.ToString(dr["Comp_Udef2"]);
ret.Add(road_Components);
}
}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>
/// 获取指定的零件图号信息 Road_Components对象(即:一条记录
/// </summary>
public Road_Components GetByKey(Int64 comp_ID)
{
Road_Components road_Components = new Road_Components();
string sql = "SELECT Comp_ID,Comp_Code,Comp_Name,Comp_Design,Comp_Bak,Comp_Stat,Comp_CatCode,Comp_CatName,Stat,Comp_Order,AuditStat,AuditCurAudit,Comp_CurNode,Comp_Creator,Comp_CreatTime,Comp_IsBusy,Comp_Udef1,Comp_Udef2 FROM Road_Components WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Comp_ID=@Comp_ID ";
idb.AddParameter("@Comp_ID", comp_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["Comp_ID"] != DBNull.Value) road_Components.Comp_ID = Convert.ToInt64(dr["Comp_ID"]);
if (dr["Comp_Code"] != DBNull.Value) road_Components.Comp_Code = Convert.ToString(dr["Comp_Code"]);
if (dr["Comp_Name"] != DBNull.Value) road_Components.Comp_Name = Convert.ToString(dr["Comp_Name"]);
if (dr["Comp_Design"] != DBNull.Value) road_Components.Comp_Design = Convert.ToString(dr["Comp_Design"]);
if (dr["Comp_Bak"] != DBNull.Value) road_Components.Comp_Bak = Convert.ToString(dr["Comp_Bak"]);
if (dr["Comp_Stat"] != DBNull.Value) road_Components.Comp_Stat = Convert.ToString(dr["Comp_Stat"]);
if (dr["Comp_CatCode"] != DBNull.Value) road_Components.Comp_CatCode = Convert.ToString(dr["Comp_CatCode"]);
if (dr["Comp_CatName"] != DBNull.Value) road_Components.Comp_CatName = Convert.ToString(dr["Comp_CatName"]);
if (dr["Stat"] != DBNull.Value) road_Components.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["Comp_Order"] != DBNull.Value) road_Components.Comp_Order = Convert.ToInt32(dr["Comp_Order"]);
if (dr["AuditStat"] != DBNull.Value) road_Components.AuditStat = Convert.ToString(dr["AuditStat"]);
if (dr["AuditCurAudit"] != DBNull.Value) road_Components.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
if (dr["Comp_CurNode"] != DBNull.Value) road_Components.Comp_CurNode = Convert.ToString(dr["Comp_CurNode"]);
if (dr["Comp_Creator"] != DBNull.Value) road_Components.Comp_Creator = Convert.ToString(dr["Comp_Creator"]);
if (dr["Comp_CreatTime"] != DBNull.Value) road_Components.Comp_CreatTime = Convert.ToDateTime(dr["Comp_CreatTime"]);
if (dr["Comp_IsBusy"] != DBNull.Value) road_Components.Comp_IsBusy = Convert.ToInt32(dr["Comp_IsBusy"]);
if (dr["Comp_Udef1"] != DBNull.Value) road_Components.Comp_Udef1 = Convert.ToString(dr["Comp_Udef1"]);
if (dr["Comp_Udef2"] != DBNull.Value) road_Components.Comp_Udef2 = Convert.ToString(dr["Comp_Udef2"]);
}
}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 road_Components;
}
/// <summary>
/// 添加零件图号信息 Road_Components对象(即:一条记录)
/// </summary>
public int Add(Road_Components road_Components)
{
string sql = "INSERT INTO Road_Components (Comp_Code,Comp_Name,Comp_Design,Comp_Bak,Comp_Stat,Comp_CatCode,Comp_CatName,Stat,Comp_Order,AuditStat,AuditCurAudit,Comp_CurNode,Comp_Creator,Comp_CreatTime,Comp_IsBusy,Comp_Udef1,Comp_Udef2) VALUES (@Comp_Code,@Comp_Name,@Comp_Design,@Comp_Bak,@Comp_Stat,@Comp_CatCode,@Comp_CatName,@Stat,@Comp_Order,@AuditStat,@AuditCurAudit,@Comp_CurNode,@Comp_Creator,@Comp_CreatTime,@Comp_IsBusy,@Comp_Udef1,@Comp_Udef2)";
if (string.IsNullOrEmpty(road_Components.Comp_Code))
{
idb.AddParameter("@Comp_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Code", road_Components.Comp_Code);
}
if (string.IsNullOrEmpty(road_Components.Comp_Name))
{
idb.AddParameter("@Comp_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Name", road_Components.Comp_Name);
}
if (string.IsNullOrEmpty(road_Components.Comp_Design))
{
idb.AddParameter("@Comp_Design", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Design", road_Components.Comp_Design);
}
if (string.IsNullOrEmpty(road_Components.Comp_Bak))
{
idb.AddParameter("@Comp_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Bak", road_Components.Comp_Bak);
}
if (string.IsNullOrEmpty(road_Components.Comp_Stat))
{
idb.AddParameter("@Comp_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Stat", road_Components.Comp_Stat);
}
if (string.IsNullOrEmpty(road_Components.Comp_CatCode))
{
idb.AddParameter("@Comp_CatCode", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CatCode", road_Components.Comp_CatCode);
}
if (string.IsNullOrEmpty(road_Components.Comp_CatName))
{
idb.AddParameter("@Comp_CatName", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CatName", road_Components.Comp_CatName);
}
if (road_Components.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", road_Components.Stat);
}
if (road_Components.Comp_Order == 0)
{
idb.AddParameter("@Comp_Order", 0);
}
else
{
idb.AddParameter("@Comp_Order", road_Components.Comp_Order);
}
if (string.IsNullOrEmpty(road_Components.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", road_Components.AuditStat);
}
if (string.IsNullOrEmpty(road_Components.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", road_Components.AuditCurAudit);
}
if (string.IsNullOrEmpty(road_Components.Comp_CurNode))
{
idb.AddParameter("@Comp_CurNode", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CurNode", road_Components.Comp_CurNode);
}
if (string.IsNullOrEmpty(road_Components.Comp_Creator))
{
idb.AddParameter("@Comp_Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Creator", road_Components.Comp_Creator);
}
if (road_Components.Comp_CreatTime == DateTime.MinValue)
{
idb.AddParameter("@Comp_CreatTime", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_CreatTime", road_Components.Comp_CreatTime);
}
if (road_Components.Comp_IsBusy == 0)
{
idb.AddParameter("@Comp_IsBusy", 0);
}
else
{
idb.AddParameter("@Comp_IsBusy", road_Components.Comp_IsBusy);
}
if (string.IsNullOrEmpty(road_Components.Comp_Udef1))
{
idb.AddParameter("@Comp_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Udef1", road_Components.Comp_Udef1);
}
if (string.IsNullOrEmpty(road_Components.Comp_Udef2))
{
idb.AddParameter("@Comp_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@Comp_Udef2", road_Components.Comp_Udef2);
}
return idb.ExeCmd(sql);
}
