/// <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);
}