/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(OD_HANDOVER_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE OD_HANDOVER");
sb.AppendFormat(" set ");
sb.AppendFormat(" OPTIME='{0}'", PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now));
if (string.IsNullOrEmpty(m.ONDUTYDATE) == false)
{
sb.AppendFormat(",ONDUTYDATE='{0}'", ClsSql.EncodeSql(m.ONDUTYDATE));
}
if (string.IsNullOrEmpty(m.BYORGNO) == false)
{
sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO));
}
if (string.IsNullOrEmpty(m.ONDUTYUSERTYPE) == false)
{
sb.AppendFormat(",ONDUTYUSERTYPE='{0}'", ClsSql.EncodeSql(m.ONDUTYUSERTYPE));
}
if (string.IsNullOrEmpty(m.ONDUTYTYPE) == false)
{
sb.AppendFormat(",ONDUTYTYPE='{0}'", ClsSql.EncodeSql(m.ONDUTYTYPE));
}
if (string.IsNullOrEmpty(m.ONDUTYUSERID) == false)
{
sb.AppendFormat(",ONDUTYUSERID='{0}'", ClsSql.EncodeSql(m.ONDUTYUSERID));
}
if (string.IsNullOrEmpty(m.OPCONTENT) == false)
{
sb.AppendFormat(",OPCONTENT='{0}'", ClsSql.EncodeSql(m.OPCONTENT));
}
sb.AppendFormat(" where ODHID='{0}'", ClsSql.EncodeSql(m.ODHID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(OD_HANDOVER_Model m)
{
if (m.ONDUTYTYPE == "-3")//如果是填写日志
{
if (isExists(new OD_HANDOVER_SW {
ONDUTYTYPE = "-3", ONDUTYDATE = m.ONDUTYDATE
}) == true) //先删除当天日志
{
DelDayLog(new OD_HANDOVER_Model {
ONDUTYTYPE = "-3", ONDUTYDATE = m.ONDUTYDATE
});
}
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("insert OD_HANDOVER(ONDUTYDATE, BYORGNO, ONDUTYUSERTYPE, ONDUTYTYPE, ONDUTYUSERID, OPTIME, OPCONTENT)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ONDUTYDATE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ONDUTYUSERTYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ONDUTYTYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ONDUTYUSERID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPCONTENT));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
