/// <summary>
/// 获取表数据
/// </summary>
/// /// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType)
{
DataTable table;
ow_articletypeControl ow_articletypeControl = new DataBaseControl.ow_articletypeControl();
table = ow_articletypeControl.GetTable(1, " TypeName ='关于我们'");
string sql = "";
if (table != null && table.Rows.Count > 0)
{
sql = SQLGeneration.MySQLGeneration(tablename, " ArticleType=" + table.Rows[0]["ID"].ToString(), SQLType);
}
else
{
return null;
}
table=DBHelper.GetTable(sql, DBHelper.connStr);
if (table != null)
{
table.TableName = "ow_article";
return table;
}
else
{
return null;
}
}
/// <summary>
/// 获取表数据
/// </summary>
/// /// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType)
{
DataTable table;
ow_articletypeControl ow_articletypeControl = new DataBaseControl.ow_articletypeControl();
table = ow_articletypeControl.GetTable(1, " TypeName ='关于我们'");
string sql = "";
if (table != null && table.Rows.Count > 0)
{
sql = SQLGeneration.MySQLGeneration(tablename, " ArticleType=" + table.Rows[0]["ID"].ToString(), SQLType);
}
else
{
return(null);
}
table = DBHelper.GetTable(sql, DBHelper.connStr);
if (table != null)
{
table.TableName = "ow_article";
return(table);
}
else
{
return(null);
}
}
public void ProcessRequest(HttpContext context)
{
DataTable table = null;
string jsondata = "";
DataBaseControl.ow_articleControl ow_articleControl = new DataBaseControl.ow_articleControl();
try
{
table = ow_articleControl.GetTable(1);
}
catch (Exception ex)
{
jsondata = ex.Message;
}
if (table != null && table.Rows.Count > 0)
{
//更新
table.Rows[0]["Content"] = context.Request["Content"];
table.Columns["ID"].Prefix = "where";
ow_articleControl.Update("ID", table, 1);
}
else
{
DataBaseControl.ow_articletypeControl ow_articletypeControl = new DataBaseControl.ow_articletypeControl();
DataTable table1 = ow_articletypeControl.GetTable(1, " TypeName ='关于我们'");
DataRow dr = table.NewRow();
dr["Title"] = "关于我们";
dr["Content"] = context.Request["Content"].ToString();
dr["ArticleType"] = table1.Rows[0]["ID"];
dr["CreateDate"] = DateTime.Now.ToString("f");
dr["UpdateDate"] = DateTime.Now.ToString("f");
dr["IsDisplay"] = 0;
table.Rows.Add(dr);
ow_articleControl.Update("ID", table, 0);
//新增
}
context.Response.ContentType = "text/plain";
context.Response.Write("{\"Result\":\"" + jsondata + "\"}");
}
public void ProcessRequest(HttpContext context)
{
DataTable table = null;
string jsondata="";
DataBaseControl.ow_articleControl ow_articleControl = new DataBaseControl.ow_articleControl();
try
{
table = ow_articleControl.GetTable(1);
}
catch (Exception ex)
{
jsondata=ex.Message;
}
if (table != null && table.Rows.Count > 0)
{
//更新
table.Rows[0]["Content"] = context.Request["Content"];
table.Columns["ID"].Prefix = "where";
ow_articleControl.Update("ID", table, 1);
}
else
{
DataBaseControl.ow_articletypeControl ow_articletypeControl = new DataBaseControl.ow_articletypeControl();
DataTable table1 = ow_articletypeControl.GetTable(1, " TypeName ='关于我们'");
DataRow dr = table.NewRow();
dr["Title"] = "关于我们";
dr["Content"] = context.Request["Content"].ToString();
dr["ArticleType"] = table1.Rows[0]["ID"];
dr["CreateDate"] = DateTime.Now.ToString("f");
dr["UpdateDate"] = DateTime.Now.ToString("f");
dr["IsDisplay"] = 0;
table.Rows.Add(dr);
ow_articleControl.Update("ID", table,0);
//新增
}
context.Response.ContentType = "text/plain";
context.Response.Write("{\"Result\":\""+jsondata+"\"}");
}
