/// <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>>(); }