/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(DEV_STANDARD_SDS model, string p_strWhere) { string strUpdateSQL = ""; if (model.Changed("SEARCH_CONDITION") == true && model.SEARCH_CONDITION != null) { strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'"; } if (model.Changed("ZXMC") == true && model.ZXMC != null) { strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSCOXZ") == true && model.GDSCOXZ != null) { strUpdateSQL += ",GDSCOXZ='" + model.GDSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSHCXZ") == true && model.GDSHCXZ != null) { strUpdateSQL += ",GDSHCXZ='" + model.GDSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null) { strUpdateSQL += ",DSCOXZ='" + model.DSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null) { strUpdateSQL += ",DSHCXZ='" + model.DSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSSX") == true && model.GLKQXSSX != null) { strUpdateSQL += ",GLKQXSSX='" + model.GLKQXSSX.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSXX") == true && model.GLKQXSXX != null) { strUpdateSQL += ",GLKQXSXX='" + model.GLKQXSXX.ToString().Replace("'", "''") + "'"; } if (model.Changed("IS_SHOW") == true && model.IS_SHOW != null) { strUpdateSQL += ",IS_SHOW=" + model.IS_SHOW + ""; } if (model.Changed("AREA_NAME") == true && model.AREA_NAME != null) { strUpdateSQL += ",AREA_NAME='" + model.AREA_NAME.ToString().Replace("'", "''") + "'"; } if (model.Changed("UTYPE") == true && model.UTYPE != null) { strUpdateSQL += ",UTYPE=" + model.UTYPE + ""; } string strSql = ""; strSql += "update DEV_STANDARD_SDS set "; strSql += strUpdateSQL.Substring(1); strSql += " where " + p_strWhere; return(strSql); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(DEV_STANDARD_SDS model) { string strFieldSQL = ""; string strValueSQL = ""; if (model.Changed("SEARCH_CONDITION") == true && model.SEARCH_CONDITION != null) { strFieldSQL += ",SEARCH_CONDITION"; strValueSQL += ",'" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'"; } if (model.Changed("ZXMC") == true && model.ZXMC != null) { strFieldSQL += ",ZXMC"; strValueSQL += ",'" + model.ZXMC.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSCOXZ") == true && model.GDSCOXZ != null) { strFieldSQL += ",GDSCOXZ"; strValueSQL += ",'" + model.GDSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSHCXZ") == true && model.GDSHCXZ != null) { strFieldSQL += ",GDSHCXZ"; strValueSQL += ",'" + model.GDSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null) { strFieldSQL += ",DSCOXZ"; strValueSQL += ",'" + model.DSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null) { strFieldSQL += ",DSHCXZ"; strValueSQL += ",'" + model.DSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSSX") == true && model.GLKQXSSX != null) { strFieldSQL += ",GLKQXSSX"; strValueSQL += ",'" + model.GLKQXSSX.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSXX") == true && model.GLKQXSXX != null) { strFieldSQL += ",GLKQXSXX"; strValueSQL += ",'" + model.GLKQXSXX.ToString().Replace("'", "''") + "'"; } if (model.Changed("IS_SHOW") == true && model.IS_SHOW != null) { strFieldSQL += ",IS_SHOW"; strValueSQL += "," + model.IS_SHOW + ""; } if (model.Changed("AREA_NAME") == true && model.AREA_NAME != null) { strFieldSQL += ",AREA_NAME"; strValueSQL += ",'" + model.AREA_NAME.ToString().Replace("'", "''") + "'"; } if (model.Changed("UTYPE") == true && model.UTYPE != null) { strFieldSQL += ",UTYPE"; strValueSQL += "," + model.UTYPE + ""; } string strSql = ""; strSql += "insert into DEV_STANDARD_SDS"; strSql += "("; strSql += strFieldSQL.Substring(1); strSql += ")"; strSql += " values"; strSql += "("; strSql += strValueSQL.Substring(1); strSql += ")"; return(strSql); }