/// <summary>
/// 得到一个对象实体
/// </summary>
public DHMSClass.Model.DHMS_Miss DataRowToModel(DataRow row)
{
DHMSClass.Model.DHMS_Miss model = new DHMSClass.Model.DHMS_Miss();
if (row != null)
{
if (row["Miss_ID"] != null)
{
model.Miss_ID = row["Miss_ID"].ToString();
}
if (row["Student_Sno"] != null)
{
model.Student_Sno = row["Student_Sno"].ToString();
}
if (row["Miss_Fever"] != null)
{
model.Miss_Fever = row["Miss_Fever"].ToString();
}
if (row["Symptom_Number"] != null)
{
model.Symptom_Number = row["Symptom_Number"].ToString();
}
if (row["Diagnosis_Number"] != null)
{
model.Diagnosis_Number = row["Diagnosis_Number"].ToString();
}
if (row["Miss_MState"] != null)
{
model.Miss_MState = row["Miss_MState"].ToString();
}
if (row["Miss_MHospital"] != null)
{
model.Miss_MHospital = row["Miss_MHospital"].ToString();
}
if (row["Miss_Days"] != null && row["Miss_Days"].ToString() != "")
{
model.Miss_Days = int.Parse(row["Miss_Days"].ToString());
}
if (row["Miss_ClassHour"] != null && row["Miss_ClassHour"].ToString() != "")
{
model.Miss_ClassHour = int.Parse(row["Miss_ClassHour"].ToString());
}
if (row["Miss_Type"] != null)
{
model.Miss_Type = row["Miss_Type"].ToString();
}
if (row["Epidemic_Number"] != null)
{
model.Epidemic_Number = row["Epidemic_Number"].ToString();
}
if (row["Teacher_Tno"] != null)
{
model.Teacher_Tno = row["Teacher_Tno"].ToString();
}
if (row["Miss_RDateTime"] != null && row["Miss_RDateTime"].ToString() != "")
{
model.Miss_RDateTime = DateTime.Parse(row["Miss_RDateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DHMSClass.Model.DHMS_Miss GetModel(string Miss_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Miss_ID,Student_Sno,Miss_Fever,Symptom_Number,Diagnosis_Number,Miss_MState,Miss_MHospital,Miss_Days,Miss_ClassHour,Miss_Type,Epidemic_Number,Teacher_Tno,Miss_RDateTime ");
strSql.Append(" from DHMS_Miss ");
strSql.Append(" where Miss_ID='" + Miss_ID + "' ");
DHMSClass.Model.DHMS_Miss model = new DHMSClass.Model.DHMS_Miss();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DHMSClass.Model.DHMS_Miss model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.Miss_ID != null)
{
strSql1.Append("Miss_ID,");
strSql2.Append("'" + model.Miss_ID + "',");
}
if (model.Student_Sno != null)
{
strSql1.Append("Student_Sno,");
strSql2.Append("'" + model.Student_Sno + "',");
}
if (model.Miss_Fever != null)
{
strSql1.Append("Miss_Fever,");
strSql2.Append("'" + model.Miss_Fever + "',");
}
if (model.Symptom_Number != null)
{
strSql1.Append("Symptom_Number,");
strSql2.Append("'" + model.Symptom_Number + "',");
}
if (model.Diagnosis_Number != null)
{
strSql1.Append("Diagnosis_Number,");
strSql2.Append("'" + model.Diagnosis_Number + "',");
}
if (model.Miss_MState != null)
{
strSql1.Append("Miss_MState,");
strSql2.Append("'" + model.Miss_MState + "',");
}
if (model.Miss_MHospital != null)
{
strSql1.Append("Miss_MHospital,");
strSql2.Append("'" + model.Miss_MHospital + "',");
}
if (model.Miss_Days != null)
{
strSql1.Append("Miss_Days,");
strSql2.Append("" + model.Miss_Days + ",");
}
if (model.Miss_ClassHour != null)
{
strSql1.Append("Miss_ClassHour,");
strSql2.Append("" + model.Miss_ClassHour + ",");
}
if (model.Miss_Type != null)
{
strSql1.Append("Miss_Type,");
strSql2.Append("'" + model.Miss_Type + "',");
}
if (model.Epidemic_Number != null)
{
strSql1.Append("Epidemic_Number,");
strSql2.Append("'" + model.Epidemic_Number + "',");
}
if (model.Teacher_Tno != null)
{
strSql1.Append("Teacher_Tno,");
strSql2.Append("'" + model.Teacher_Tno + "',");
}
if (model.Miss_RDateTime != null)
{
strSql1.Append("Miss_RDateTime,");
strSql2.Append("'" + model.Miss_RDateTime + "',");
}
strSql.Append("insert into DHMS_Miss(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DHMSClass.Model.DHMS_Miss model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DHMS_Miss set ");
if (model.Student_Sno != null)
{
strSql.Append("Student_Sno='" + model.Student_Sno + "',");
}
if (model.Miss_Fever != null)
{
strSql.Append("Miss_Fever='" + model.Miss_Fever + "',");
}
if (model.Symptom_Number != null)
{
strSql.Append("Symptom_Number='" + model.Symptom_Number + "',");
}
if (model.Diagnosis_Number != null)
{
strSql.Append("Diagnosis_Number='" + model.Diagnosis_Number + "',");
}
if (model.Miss_MState != null)
{
strSql.Append("Miss_MState='" + model.Miss_MState + "',");
}
if (model.Miss_MHospital != null)
{
strSql.Append("Miss_MHospital='" + model.Miss_MHospital + "',");
}
if (model.Miss_Days != null)
{
strSql.Append("Miss_Days=" + model.Miss_Days + ",");
}
if (model.Miss_ClassHour != null)
{
strSql.Append("Miss_ClassHour=" + model.Miss_ClassHour + ",");
}
if (model.Miss_Type != null)
{
strSql.Append("Miss_Type='" + model.Miss_Type + "',");
}
if (model.Epidemic_Number != null)
{
strSql.Append("Epidemic_Number='" + model.Epidemic_Number + "',");
}
else
{
strSql.Append("Epidemic_Number= null ,");
}
if (model.Teacher_Tno != null)
{
strSql.Append("Teacher_Tno='" + model.Teacher_Tno + "',");
}
if (model.Miss_RDateTime != null)
{
strSql.Append("Miss_RDateTime='" + model.Miss_RDateTime + "',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where Miss_ID='" + model.Miss_ID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}