public int UpdateScreenWarn(ScreenWarnModel model)
{
string strSql = @"update ScreenWarn set amDosageTime='" + model.amDosageTime + "',amDosageNumber=" + model.amDosageNumber + ",pmDosageTime='" + model.pmDosageTime + "',pmDosageNumber=" + model.pmDosageNumber + ",amTisaneTime='" + model.amTisaneTime + "',amTisaneNumber=" + model.amTisaneNumber + ",pmTisaneTime='" + model.pmTisaneTime + "',pmTisaneNumber=" + model.pmTisaneNumber + ",warnDate='" + model.warnDate + "' where hospitalID=" + model.hospitalID + "";
int n = db.cmd_Execute(strSql);
return(n);
}
public int AddScreenWarn(ScreenWarnModel model)
{
string strSql = @"INSERT INTO ScreenWarn
([hospitalID]
,[amDosageTime]
,[amDosageNumber]
,[pmDosageTime]
,[pmDosageNumber]
,[amTisaneTime]
,[amTisaneNumber]
,[pmTisaneTime]
,[pmTisaneNumber]
,[warnDate])
VALUES(" + model.hospitalID + ",'" + model.amDosageTime + "'," + model.amDosageNumber + ",'" + model.pmDosageTime + "'," + model.pmDosageNumber + ",'" + model.amTisaneTime + "'," + model.amTisaneNumber + ",'" + model.pmTisaneTime + "'," + model.pmTisaneNumber + ",'" + model.warnDate + "')";
int n = db.cmd_Execute(strSql);
return(n);
}
