/// <summary>
/// 获取指定的Prod_Doc对象集合
/// </summary>
public List<Prod_Doc> GetListByWhereExtend(string strCondition)
{
List<Prod_Doc> ret = new List<Prod_Doc>();
string sql = "SELECT PRDQ_ID,PRDQ_Code,PRDQ_CompNo,PRDQ_CompCode,PRDQ_CompName,PRDQ_Name,PRDQ_Type,PRDQ_iType,PRDQ_Date,PRDQ_Owner,PRDQ_Plant,PRDQ_Result,PRDQ_FCode,PRDQ_FReso,PRDQ_FOpi,PRDQ_FDeC,PRDQ_Bak,PRDQ_FDate,PRDQ_IsScan,PRDQ_IsNeed,Stat,Creator,CreateTime,UpdateTime,DeleteTime,isnull((select top 1 CCF_Directory from cc_file where isnull(stat,0)=0 and CCF_DCode=PRDQ_Code order by CCF_ID Desc),'') CCF_Directory FROM Prod_Doc 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())
{
Prod_Doc prod_Doc = new Prod_Doc();
if (dr["PRDQ_ID"] != DBNull.Value) prod_Doc.PRDQ_ID = Convert.ToDecimal(dr["PRDQ_ID"]);
if (dr["PRDQ_Code"] != DBNull.Value) prod_Doc.PRDQ_Code = Convert.ToString(dr["PRDQ_Code"]);
if (dr["PRDQ_CompNo"] != DBNull.Value) prod_Doc.PRDQ_CompNo = Convert.ToString(dr["PRDQ_CompNo"]);
if (dr["PRDQ_CompCode"] != DBNull.Value) prod_Doc.PRDQ_CompCode = Convert.ToString(dr["PRDQ_CompCode"]);
if (dr["PRDQ_CompName"] != DBNull.Value) prod_Doc.PRDQ_CompName = Convert.ToString(dr["PRDQ_CompName"]);
if (dr["PRDQ_Name"] != DBNull.Value) prod_Doc.PRDQ_Name = Convert.ToString(dr["PRDQ_Name"]);
if (dr["PRDQ_Type"] != DBNull.Value) prod_Doc.PRDQ_Type = Convert.ToString(dr["PRDQ_Type"]);
if (dr["PRDQ_iType"] != DBNull.Value) prod_Doc.PRDQ_iType = Convert.ToString(dr["PRDQ_iType"]);
if (dr["PRDQ_Date"] != DBNull.Value) prod_Doc.PRDQ_Date = Convert.ToString(dr["PRDQ_Date"]);
if (dr["PRDQ_Owner"] != DBNull.Value) prod_Doc.PRDQ_Owner = Convert.ToString(dr["PRDQ_Owner"]);
if (dr["PRDQ_Plant"] != DBNull.Value) prod_Doc.PRDQ_Plant = Convert.ToString(dr["PRDQ_Plant"]);
if (dr["PRDQ_Result"] != DBNull.Value) prod_Doc.PRDQ_Result = Convert.ToString(dr["PRDQ_Result"]);
if (dr["PRDQ_FCode"] != DBNull.Value) prod_Doc.PRDQ_FCode = Convert.ToString(dr["PRDQ_FCode"]);
if (dr["PRDQ_FReso"] != DBNull.Value) prod_Doc.PRDQ_FReso = Convert.ToString(dr["PRDQ_FReso"]);
if (dr["PRDQ_FOpi"] != DBNull.Value) prod_Doc.PRDQ_FOpi = Convert.ToString(dr["PRDQ_FOpi"]);
if (dr["PRDQ_FDeC"] != DBNull.Value) prod_Doc.PRDQ_FDeC = Convert.ToString(dr["PRDQ_FDeC"]);
if (dr["PRDQ_Bak"] != DBNull.Value) prod_Doc.PRDQ_Bak = Convert.ToString(dr["PRDQ_Bak"]);
if (dr["PRDQ_FDate"] != DBNull.Value) prod_Doc.PRDQ_FDate = Convert.ToString(dr["PRDQ_FDate"]);
if (dr["PRDQ_IsScan"] != DBNull.Value) prod_Doc.PRDQ_IsScan = Convert.ToInt32(dr["PRDQ_IsScan"]);
if (dr["PRDQ_IsNeed"] != DBNull.Value) prod_Doc.PRDQ_IsNeed = Convert.ToString(dr["PRDQ_IsNeed"]);
if (dr["Stat"] != DBNull.Value) prod_Doc.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["Creator"] != DBNull.Value) prod_Doc.Creator = Convert.ToDateTime(dr["Creator"]);
if (dr["CreateTime"] != DBNull.Value) prod_Doc.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
if (dr["UpdateTime"] != DBNull.Value) prod_Doc.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
if (dr["DeleteTime"] != DBNull.Value) prod_Doc.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
//扩展
if (dr["CCF_Directory"] != DBNull.Value) prod_Doc.CCF_Directory = dr["CCF_Directory"].ToString();
ret.Add(prod_Doc);
}
}
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>
/// 更新Prod_Doc对象(即:一条记录
/// </summary>
public int Update(Prod_Doc prod_Doc)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Prod_Doc SET ");
if(prod_Doc.PRDQ_Code_IsChanged){sbParameter.Append("PRDQ_Code=@PRDQ_Code, ");}
if(prod_Doc.PRDQ_CompNo_IsChanged){sbParameter.Append("PRDQ_CompNo=@PRDQ_CompNo, ");}
if(prod_Doc.PRDQ_CompCode_IsChanged){sbParameter.Append("PRDQ_CompCode=@PRDQ_CompCode, ");}
if(prod_Doc.PRDQ_CompName_IsChanged){sbParameter.Append("PRDQ_CompName=@PRDQ_CompName, ");}
if(prod_Doc.PRDQ_Name_IsChanged){sbParameter.Append("PRDQ_Name=@PRDQ_Name, ");}
if(prod_Doc.PRDQ_Type_IsChanged){sbParameter.Append("PRDQ_Type=@PRDQ_Type, ");}
if(prod_Doc.PRDQ_iType_IsChanged){sbParameter.Append("PRDQ_iType=@PRDQ_iType, ");}
if(prod_Doc.PRDQ_Date_IsChanged){sbParameter.Append("PRDQ_Date=@PRDQ_Date, ");}
if(prod_Doc.PRDQ_Owner_IsChanged){sbParameter.Append("PRDQ_Owner=@PRDQ_Owner, ");}
if(prod_Doc.PRDQ_Plant_IsChanged){sbParameter.Append("PRDQ_Plant=@PRDQ_Plant, ");}
if(prod_Doc.PRDQ_Result_IsChanged){sbParameter.Append("PRDQ_Result=@PRDQ_Result, ");}
if(prod_Doc.PRDQ_FCode_IsChanged){sbParameter.Append("PRDQ_FCode=@PRDQ_FCode, ");}
if(prod_Doc.PRDQ_FReso_IsChanged){sbParameter.Append("PRDQ_FReso=@PRDQ_FReso, ");}
if(prod_Doc.PRDQ_FOpi_IsChanged){sbParameter.Append("PRDQ_FOpi=@PRDQ_FOpi, ");}
if(prod_Doc.PRDQ_FDeC_IsChanged){sbParameter.Append("PRDQ_FDeC=@PRDQ_FDeC, ");}
if(prod_Doc.PRDQ_Bak_IsChanged){sbParameter.Append("PRDQ_Bak=@PRDQ_Bak, ");}
if(prod_Doc.PRDQ_FDate_IsChanged){sbParameter.Append("PRDQ_FDate=@PRDQ_FDate, ");}
if(prod_Doc.PRDQ_IsScan_IsChanged){sbParameter.Append("PRDQ_IsScan=@PRDQ_IsScan, ");}
if(prod_Doc.PRDQ_IsNeed_IsChanged){sbParameter.Append("PRDQ_IsNeed=@PRDQ_IsNeed, ");}
if(prod_Doc.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(prod_Doc.Creator_IsChanged){sbParameter.Append("Creator=@Creator, ");}
if(prod_Doc.CreateTime_IsChanged){sbParameter.Append("CreateTime=@CreateTime, ");}
if(prod_Doc.UpdateTime_IsChanged){sbParameter.Append("UpdateTime=@UpdateTime, ");}
if(prod_Doc.DeleteTime_IsChanged){sbParameter.Append("DeleteTime=@DeleteTime ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PRDQ_ID=@PRDQ_ID; " );
string sql=sb.ToString();
if(prod_Doc.PRDQ_Code_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Code))
{
idb.AddParameter("@PRDQ_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Code", prod_Doc.PRDQ_Code);
}
}
if(prod_Doc.PRDQ_CompNo_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompNo))
{
idb.AddParameter("@PRDQ_CompNo", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompNo", prod_Doc.PRDQ_CompNo);
}
}
if(prod_Doc.PRDQ_CompCode_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompCode))
{
idb.AddParameter("@PRDQ_CompCode", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompCode", prod_Doc.PRDQ_CompCode);
}
}
if(prod_Doc.PRDQ_CompName_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompName))
{
idb.AddParameter("@PRDQ_CompName", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompName", prod_Doc.PRDQ_CompName);
}
}
if(prod_Doc.PRDQ_Name_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Name))
{
idb.AddParameter("@PRDQ_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Name", prod_Doc.PRDQ_Name);
}
}
if(prod_Doc.PRDQ_Type_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Type))
{
idb.AddParameter("@PRDQ_Type", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Type", prod_Doc.PRDQ_Type);
}
}
if(prod_Doc.PRDQ_iType_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_iType))
{
idb.AddParameter("@PRDQ_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_iType", prod_Doc.PRDQ_iType);
}
}
if(prod_Doc.PRDQ_Date_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Date))
{
idb.AddParameter("@PRDQ_Date", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Date", prod_Doc.PRDQ_Date);
}
}
if(prod_Doc.PRDQ_Owner_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Owner))
{
idb.AddParameter("@PRDQ_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Owner", prod_Doc.PRDQ_Owner);
}
}
if(prod_Doc.PRDQ_Plant_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Plant))
{
idb.AddParameter("@PRDQ_Plant", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Plant", prod_Doc.PRDQ_Plant);
}
}
if(prod_Doc.PRDQ_Result_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Result))
{
idb.AddParameter("@PRDQ_Result", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Result", prod_Doc.PRDQ_Result);
}
}
if(prod_Doc.PRDQ_FCode_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FCode))
{
idb.AddParameter("@PRDQ_FCode", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FCode", prod_Doc.PRDQ_FCode);
}
}
if(prod_Doc.PRDQ_FReso_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FReso))
{
idb.AddParameter("@PRDQ_FReso", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FReso", prod_Doc.PRDQ_FReso);
}
}
if(prod_Doc.PRDQ_FOpi_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FOpi))
{
idb.AddParameter("@PRDQ_FOpi", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FOpi", prod_Doc.PRDQ_FOpi);
}
}
if(prod_Doc.PRDQ_FDeC_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FDeC))
{
idb.AddParameter("@PRDQ_FDeC", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FDeC", prod_Doc.PRDQ_FDeC);
}
}
if(prod_Doc.PRDQ_Bak_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Bak))
{
idb.AddParameter("@PRDQ_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Bak", prod_Doc.PRDQ_Bak);
}
}
if(prod_Doc.PRDQ_FDate_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FDate))
{
idb.AddParameter("@PRDQ_FDate", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FDate", prod_Doc.PRDQ_FDate);
}
}
if(prod_Doc.PRDQ_IsScan_IsChanged)
{
if (prod_Doc.PRDQ_IsScan == 0)
{
idb.AddParameter("@PRDQ_IsScan", 0);
}
else
{
idb.AddParameter("@PRDQ_IsScan", prod_Doc.PRDQ_IsScan);
}
}
if(prod_Doc.PRDQ_IsNeed_IsChanged)
{
if (string.IsNullOrEmpty(prod_Doc.PRDQ_IsNeed))
{
idb.AddParameter("@PRDQ_IsNeed", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_IsNeed", prod_Doc.PRDQ_IsNeed);
}
}
if(prod_Doc.Stat_IsChanged)
{
if (prod_Doc.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", prod_Doc.Stat);
}
}
if(prod_Doc.Creator_IsChanged)
{
if (prod_Doc.Creator == DateTime.MinValue)
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", prod_Doc.Creator);
}
}
if(prod_Doc.CreateTime_IsChanged)
{
if (prod_Doc.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", prod_Doc.CreateTime);
}
}
if(prod_Doc.UpdateTime_IsChanged)
{
if (prod_Doc.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", prod_Doc.UpdateTime);
}
}
if(prod_Doc.DeleteTime_IsChanged)
{
if (prod_Doc.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", prod_Doc.DeleteTime);
}
}
idb.AddParameter("@PRDQ_ID", prod_Doc.PRDQ_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>
/// 添加Prod_Doc对象(即:一条记录)
/// </summary>
public int Add(Prod_Doc prod_Doc)
{
string sql = "INSERT INTO Prod_Doc (PRDQ_Code,PRDQ_CompNo,PRDQ_CompCode,PRDQ_CompName,PRDQ_Name,PRDQ_Type,PRDQ_iType,PRDQ_Date,PRDQ_Owner,PRDQ_Plant,PRDQ_Result,PRDQ_FCode,PRDQ_FReso,PRDQ_FOpi,PRDQ_FDeC,PRDQ_Bak,PRDQ_FDate,PRDQ_IsScan,PRDQ_IsNeed,Stat,Creator,CreateTime,UpdateTime,DeleteTime) VALUES (@PRDQ_Code,@PRDQ_CompNo,@PRDQ_CompCode,@PRDQ_CompName,@PRDQ_Name,@PRDQ_Type,@PRDQ_iType,@PRDQ_Date,@PRDQ_Owner,@PRDQ_Plant,@PRDQ_Result,@PRDQ_FCode,@PRDQ_FReso,@PRDQ_FOpi,@PRDQ_FDeC,@PRDQ_Bak,@PRDQ_FDate,@PRDQ_IsScan,@PRDQ_IsNeed,@Stat,@Creator,@CreateTime,@UpdateTime,@DeleteTime)";
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Code))
{
idb.AddParameter("@PRDQ_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Code", prod_Doc.PRDQ_Code);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompNo))
{
idb.AddParameter("@PRDQ_CompNo", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompNo", prod_Doc.PRDQ_CompNo);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompCode))
{
idb.AddParameter("@PRDQ_CompCode", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompCode", prod_Doc.PRDQ_CompCode);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_CompName))
{
idb.AddParameter("@PRDQ_CompName", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_CompName", prod_Doc.PRDQ_CompName);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Name))
{
idb.AddParameter("@PRDQ_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Name", prod_Doc.PRDQ_Name);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Type))
{
idb.AddParameter("@PRDQ_Type", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Type", prod_Doc.PRDQ_Type);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_iType))
{
idb.AddParameter("@PRDQ_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_iType", prod_Doc.PRDQ_iType);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Date))
{
idb.AddParameter("@PRDQ_Date", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Date", prod_Doc.PRDQ_Date);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Owner))
{
idb.AddParameter("@PRDQ_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Owner", prod_Doc.PRDQ_Owner);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Plant))
{
idb.AddParameter("@PRDQ_Plant", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Plant", prod_Doc.PRDQ_Plant);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Result))
{
idb.AddParameter("@PRDQ_Result", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Result", prod_Doc.PRDQ_Result);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FCode))
{
idb.AddParameter("@PRDQ_FCode", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FCode", prod_Doc.PRDQ_FCode);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FReso))
{
idb.AddParameter("@PRDQ_FReso", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FReso", prod_Doc.PRDQ_FReso);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FOpi))
{
idb.AddParameter("@PRDQ_FOpi", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FOpi", prod_Doc.PRDQ_FOpi);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FDeC))
{
idb.AddParameter("@PRDQ_FDeC", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FDeC", prod_Doc.PRDQ_FDeC);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_Bak))
{
idb.AddParameter("@PRDQ_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_Bak", prod_Doc.PRDQ_Bak);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_FDate))
{
idb.AddParameter("@PRDQ_FDate", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_FDate", prod_Doc.PRDQ_FDate);
}
if (prod_Doc.PRDQ_IsScan == 0)
{
idb.AddParameter("@PRDQ_IsScan", 0);
}
else
{
idb.AddParameter("@PRDQ_IsScan", prod_Doc.PRDQ_IsScan);
}
if (string.IsNullOrEmpty(prod_Doc.PRDQ_IsNeed))
{
idb.AddParameter("@PRDQ_IsNeed", DBNull.Value);
}
else
{
idb.AddParameter("@PRDQ_IsNeed", prod_Doc.PRDQ_IsNeed);
}
if (prod_Doc.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", prod_Doc.Stat);
}
if (prod_Doc.Creator == DateTime.MinValue)
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", prod_Doc.Creator);
}
if (prod_Doc.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", prod_Doc.CreateTime);
}
if (prod_Doc.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", prod_Doc.UpdateTime);
}
if (prod_Doc.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", prod_Doc.DeleteTime);
}
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>
/// 获取指定的Prod_Doc对象(即:一条记录
/// </summary>
public Prod_Doc GetByKey(decimal pRDQ_ID)
{
Prod_Doc prod_Doc = new Prod_Doc();
string sql = "SELECT PRDQ_ID,PRDQ_Code,PRDQ_CompNo,PRDQ_CompCode,PRDQ_CompName,PRDQ_Name,PRDQ_Type,PRDQ_iType,PRDQ_Date,PRDQ_Owner,PRDQ_Plant,PRDQ_Result,PRDQ_FCode,PRDQ_FReso,PRDQ_FOpi,PRDQ_FDeC,PRDQ_Bak,PRDQ_FDate,PRDQ_IsScan,PRDQ_IsNeed,Stat,Creator,CreateTime,UpdateTime,DeleteTime FROM Prod_Doc WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PRDQ_ID=@PRDQ_ID ";
idb.AddParameter("@PRDQ_ID", pRDQ_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["PRDQ_ID"] != DBNull.Value) prod_Doc.PRDQ_ID = Convert.ToDecimal(dr["PRDQ_ID"]);
if (dr["PRDQ_Code"] != DBNull.Value) prod_Doc.PRDQ_Code = Convert.ToString(dr["PRDQ_Code"]);
if (dr["PRDQ_CompNo"] != DBNull.Value) prod_Doc.PRDQ_CompNo = Convert.ToString(dr["PRDQ_CompNo"]);
if (dr["PRDQ_CompCode"] != DBNull.Value) prod_Doc.PRDQ_CompCode = Convert.ToString(dr["PRDQ_CompCode"]);
if (dr["PRDQ_CompName"] != DBNull.Value) prod_Doc.PRDQ_CompName = Convert.ToString(dr["PRDQ_CompName"]);
if (dr["PRDQ_Name"] != DBNull.Value) prod_Doc.PRDQ_Name = Convert.ToString(dr["PRDQ_Name"]);
if (dr["PRDQ_Type"] != DBNull.Value) prod_Doc.PRDQ_Type = Convert.ToString(dr["PRDQ_Type"]);
if (dr["PRDQ_iType"] != DBNull.Value) prod_Doc.PRDQ_iType = Convert.ToString(dr["PRDQ_iType"]);
if (dr["PRDQ_Date"] != DBNull.Value) prod_Doc.PRDQ_Date = Convert.ToString(dr["PRDQ_Date"]);
if (dr["PRDQ_Owner"] != DBNull.Value) prod_Doc.PRDQ_Owner = Convert.ToString(dr["PRDQ_Owner"]);
if (dr["PRDQ_Plant"] != DBNull.Value) prod_Doc.PRDQ_Plant = Convert.ToString(dr["PRDQ_Plant"]);
if (dr["PRDQ_Result"] != DBNull.Value) prod_Doc.PRDQ_Result = Convert.ToString(dr["PRDQ_Result"]);
if (dr["PRDQ_FCode"] != DBNull.Value) prod_Doc.PRDQ_FCode = Convert.ToString(dr["PRDQ_FCode"]);
if (dr["PRDQ_FReso"] != DBNull.Value) prod_Doc.PRDQ_FReso = Convert.ToString(dr["PRDQ_FReso"]);
if (dr["PRDQ_FOpi"] != DBNull.Value) prod_Doc.PRDQ_FOpi = Convert.ToString(dr["PRDQ_FOpi"]);
if (dr["PRDQ_FDeC"] != DBNull.Value) prod_Doc.PRDQ_FDeC = Convert.ToString(dr["PRDQ_FDeC"]);
if (dr["PRDQ_Bak"] != DBNull.Value) prod_Doc.PRDQ_Bak = Convert.ToString(dr["PRDQ_Bak"]);
if (dr["PRDQ_FDate"] != DBNull.Value) prod_Doc.PRDQ_FDate = Convert.ToString(dr["PRDQ_FDate"]);
if (dr["PRDQ_IsScan"] != DBNull.Value) prod_Doc.PRDQ_IsScan = Convert.ToInt32(dr["PRDQ_IsScan"]);
if (dr["PRDQ_IsNeed"] != DBNull.Value) prod_Doc.PRDQ_IsNeed = Convert.ToString(dr["PRDQ_IsNeed"]);
if (dr["Stat"] != DBNull.Value) prod_Doc.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["Creator"] != DBNull.Value) prod_Doc.Creator = Convert.ToDateTime(dr["Creator"]);
if (dr["CreateTime"] != DBNull.Value) prod_Doc.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
if (dr["UpdateTime"] != DBNull.Value) prod_Doc.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
if (dr["DeleteTime"] != DBNull.Value) prod_Doc.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
}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 prod_Doc;
}
public bool PDocInsert(Prod_Doc model)
{
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
if (docInstance.Add(model) > 0)
{
return true;
}
return false;
}
public bool PDocUpdate(Prod_Doc model)
{
model.UpdateTime = DateTime.Now;
if (docInstance.Update(model) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 添加多零件文档关联
/// </summary>
/// <param name="doc"></param>
/// <param name="list"></param>
/// <param name="oldComponents"></param>
/// <returns></returns>
public bool AddOrUpdateCDocForRef(Prod_Doc doc, List<Prod_Components> list, List<Prod_Components> oldComponents)
{
bool flag = true;
///原零件与现关联零件比较
foreach (var d in oldComponents)
{
var temp = list.FirstOrDefault(o => o.PRDC_CompNo == d.PRDC_CompNo);
//如果不存在则表示已删除
if (temp == null)
{
List<Prod_Doc> oldSIList = GetPDocByComp(d.PRDC_CompNo);
var temp1 = oldSIList.FirstOrDefault(o => o.PRDQ_Code == doc.PRDQ_Code);
PDocDelete(temp1);
}
}
foreach (var c in list)
{
List<Prod_Doc> oldSIList = GetPDocByComp(c.PRDC_CompNo);
if (oldSIList.FirstOrDefault(o => o.PRDQ_Code == doc.PRDQ_Code) == null)
{
Prod_Doc d = new Prod_Doc();
d.PRDQ_Plant = doc.PRDQ_Plant;
d.PRDQ_Code = doc.PRDQ_Code;
d.PRDQ_Type = doc.PRDQ_Type;
d.PRDQ_iType = doc.PRDQ_iType;
d.PRDQ_IsScan = 1;
d.CreateTime = DateTime.Now;
d.UpdateTime = DateTime.Now;
d.PRDQ_CompNo = c.PRDC_CompNo;
d.PRDQ_CompCode = c.PRDC_CompCode;
d.PRDQ_CompName = c.PRDC_CompName;
d.PRDQ_Name = doc.PRDQ_Name;
//如果零件原文档列表已存在该文档类型的数据则进行更新操作,否则插入
if (oldSIList.FirstOrDefault(o => o.PRDQ_Type == doc.PRDQ_Type) != null)
{
var templist = oldSIList.Where(o => o.PRDQ_Type == doc.PRDQ_Type && string.IsNullOrEmpty(o.PRDQ_Code));
foreach (var dc in templist)
{
PDocDelete(dc);
}
}
PDocInsert(d);
}
else
{
var temp = oldSIList.FirstOrDefault(o => o.PRDQ_Code == doc.PRDQ_Code);
var temp1 = new Prod_Doc();
temp1.PRDQ_Plant = doc.PRDQ_Plant;
temp1.PRDQ_Type = doc.PRDQ_Type;
temp1.PRDQ_ID = temp.PRDQ_ID;
temp1.PRDQ_iType = temp.PRDQ_iType;
temp1.PRDQ_CompNo = c.PRDC_CompNo;
PDocUpdate(temp1);
}
}
return flag;
}
public bool DeleteDoc(Prod_Doc doc, Prod_Components model)
{
List<Prod_Doc> oldSIList = GetPDocByComp(model.PRDC_CompNo);
var temp = oldSIList.FirstOrDefault(o => o.PRDQ_Code == doc.PRDQ_Code);
return PDocDelete(temp);
}
public void InsertDocument(List<string> list)
{
List<Tpl_ReqDoc> dlist = new List<Tpl_ReqDoc>();
if (!string.IsNullOrEmpty(GModel.PRDC_CompCode))
{
dlist = compInstance.GetReqDocByComp(GModel.PRDC_CompCode);
}
foreach (var c in list)
{
foreach (var d in dlist)
{
Prod_Doc doc = new Prod_Doc();
doc.PRDQ_CompNo = c;
doc.PRDQ_CompCode = GModel.PRDC_CompCode;
doc.PRDQ_CompName = GModel.PRDC_CompName;
doc.PRDQ_Type = d.TPRD_Type;
doc.PRDQ_IsNeed = d.TPRD_IsReq;
doc.PRDQ_iType = iTypeEnum.Comp.ToString();
var dict = DictList.FirstOrDefault(o => o.Dict_Code == d.TPRD_Type);
doc.PRDQ_Name = dict.Dict_Name + "报告";
compInstance.PDocInsert(doc);
}
}
}
public bool PDocDelete(Prod_Doc model)
{
model.Stat = 1;
model.DeleteTime = DateTime.Now;
if (pdInstance.Update(model) > 0)
{
return true;
}
return false;
}
public List<Prod_Doc> GetDocByRepair(string code)
{
Prod_Doc d = new Prod_Doc();
string where = string.Format(" AND PRDQ_iType='Repair' AND PRDQ_CompNo='{0}'", code);
return pdInstance.GetListByWhere(where);
}
public List<Prod_Doc> GetDocByProdCode(string code)
{
Prod_Doc d = new Prod_Doc();
string where = string.Format(" AND PRDQ_iType='Prod' AND PRDQ_CompNo='{0}'", code);
return pdInstance.GetListByWhereExtend(where);
}
public void BindData()
{
//bmHelper.BindModelToControl<Prod_Components>(GModel, this.gpBse.Controls, "");
BLL.Bll_Bse_Dict dictInstance = new QX.BLL.Bll_Bse_Dict();
List<Bse_Dict> list1 = dictInstance.GetDictByKey("DocType");
List<Prod_Doc> list = new List<Prod_Doc>();
foreach (var d in list1)
{
Prod_Doc doc = new Prod_Doc();
doc.PRDQ_Type = d.Dict_Code;
doc.PRDQ_iType = iTypeEnum.Comp.ToString();
doc.PRDQ_Name = d.Dict_Name + "报告";
doc.PRDQ_IsNeed = "Yes";
list.Add(doc);
}
//List<Prod_Doc> list = compInstance.getpd(GModel.PRDC_CompNo);
List<CC_File> fileList = new List<CC_File>();
CurrentDataSource = fileList.ToList();
BindingSource dataSource = new BindingSource();
dataSource.DataSource = list;
comGrid.DataSource = dataSource;
BindingSource data11 = new BindingSource();
data11.DataSource = CompSource;
otherCompGrid.DataSource = data11;
InitRefCompList = new Dictionary<string, List<Prod_Components>>();
RefCompList = new Dictionary<string, List<Prod_Components>>();
}
