/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public KPS.Model.ProcessLoggingInfo DataRowToModel(DataRow row)
{
KPS.Model.ProcessLoggingInfo model=new KPS.Model.ProcessLoggingInfo();
if (row != null)
{
if(row["ProcessID"]!=null && row["ProcessID"].ToString()!="")
{
model.ProcessID=int.Parse(row["ProcessID"].ToString());
}
if(row["ProcessDate"]!=null && row["ProcessDate"].ToString()!="")
{
model.ProcessDate=DateTime.Parse(row["ProcessDate"].ToString());
}
if(row["ProcessCustomerUnit"]!=null)
{
model.ProcessCustomerUnit=row["ProcessCustomerUnit"].ToString();
}
if(row["Processlinkman"]!=null)
{
model.Processlinkman=row["Processlinkman"].ToString();
}
if(row["Processtel"]!=null)
{
model.Processtel=row["Processtel"].ToString();
}
if(row["ProcessProductName"]!=null)
{
model.ProcessProductName=row["ProcessProductName"].ToString();
}
if(row["ProcessStandard"]!=null)
{
model.ProcessStandard=row["ProcessStandard"].ToString();
}
if(row["ProcessPurchasingDate"]!=null && row["ProcessPurchasingDate"].ToString()!="")
{
model.ProcessPurchasingDate=DateTime.Parse(row["ProcessPurchasingDate"].ToString());
}
if(row["ProcessContentInquired"]!=null)
{
model.ProcessContentInquired=row["ProcessContentInquired"].ToString();
}
if(row["ProcessHandlingSuggestion"]!=null)
{
model.ProcessHandlingSuggestion=row["ProcessHandlingSuggestion"].ToString();
}
if(row["ProcessServiceUser"]!=null)
{
model.ProcessServiceUser=row["ProcessServiceUser"].ToString();
}
if (row["DataType"] != null)
{
model.DataType =Convert.ToInt32(row["DataType"]);
}
}
return model;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public KPS.Model.ProcessLoggingInfo GetModel(int ProcessID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ProcessID,ProcessDate,ProcessCustomerUnit,Processlinkman,Processtel,ProcessProductName,ProcessStandard,ProcessPurchasingDate,ProcessContentInquired,ProcessHandlingSuggestion,ProcessServiceUser from PSI_ProcessLogging,DataType ");
strSql.Append(" where ProcessID=@ProcessID");
OleDbParameter[] parameters = {
new OleDbParameter("@ProcessID", OleDbType.Integer,4)
};
parameters[0].Value = ProcessID;
KPS.Model.ProcessLoggingInfo model=new KPS.Model.ProcessLoggingInfo();
DataSet ds=DbHelperOleDb.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
