/// <summary> /// 增加一条数据 /// </summary> public int Add(Contract_Model model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.MESS_NAME != null) { strSql1.Append("MESS_NAME,"); strSql2.Append("'" + model.MESS_NAME + "',"); } if (model.MESS_TEL != null) { strSql1.Append("MESS_TEL,"); strSql2.Append("'" + model.MESS_TEL + "',"); } if (model.MESS_EMAIL != null) { strSql1.Append("MESS_EMAIL,"); strSql2.Append("'" + model.MESS_EMAIL + "',"); } if (model.MESS_CONTENT != null) { strSql1.Append("MESS_CONTENT,"); strSql2.Append("'" + model.MESS_CONTENT + "',"); } if (model.MESS_ADDRESS != null) { strSql1.Append("MESS_ADDRESS,"); strSql2.Append("'" + model.MESS_ADDRESS + "',"); } if (model.CREATE_TIME != null) { strSql1.Append("CREATE_TIME,"); strSql2.Append("'" + model.CREATE_TIME + "',"); } strSql.Append("insert into COM_MESSAGE("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Contract_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update COM_MESSAGE set "); if (model.MESS_NAME != null) { strSql.Append("MESS_NAME='" + model.MESS_NAME + "',"); } else { strSql.Append("MESS_NAME= null ,"); } if (model.MESS_TEL != null) { strSql.Append("MESS_TEL='" + model.MESS_TEL + "',"); } else { strSql.Append("MESS_TEL= null ,"); } if (model.MESS_EMAIL != null) { strSql.Append("MESS_EMAIL='" + model.MESS_EMAIL + "',"); } else { strSql.Append("MESS_EMAIL= null ,"); } if (model.MESS_CONTENT != null) { strSql.Append("MESS_CONTENT='" + model.MESS_CONTENT + "',"); } else { strSql.Append("MESS_CONTENT= null ,"); } if (model.MESS_ADDRESS != null) { strSql.Append("MESS_ADDRESS='" + model.MESS_ADDRESS + "',"); } else { strSql.Append("MESS_ADDRESS= null ,"); } if (model.CREATE_TIME != null) { strSql.Append("CREATE_TIME='" + model.CREATE_TIME + "',"); } else { strSql.Append("CREATE_TIME= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where MESS_ID=" + model.MESS_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Contract_Model model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Contract_Model model) { return(dal.Add(model)); }