public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string result = string.Empty;
if (context.Request.Params["namecontent"] == null)
{
result = "{success:false,msg:'名称不能为空'}";
}
else
{
try
{
string namecontent = context.Request.Params["namecontent"].ToString();
CY.CSTS.Core.Business.CountryCode countryCode = new CY.CSTS.Core.Business.CountryCode();
countryCode.Name= namecontent;
countryCode.Save();
result = "{success:true}";
}
catch (Exception ex)
{
result = "{success:false,msg:'" + ex.Message + "'}";
}
}
context.Response.Write(result);
}
public static void ImportCountry()
{
try
{
ImportSqlServerUtility isql = new ImportSqlServerUtility();
RelationSqlServerUtility rsql = new RelationSqlServerUtility();
string strselectsql = "select * from COUNTRYCODE";
string insertsql = "insert into RCountry(old,new) values('{0}','{1}')";
DataSet ds = isql.ExecuteSqlDataSet(strselectsql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CY.CSTS.Core.Business.CountryCode country = new CY.CSTS.Core.Business.CountryCode();
country.Name = ds.Tables[0].Rows[i][1].ToString();
country.Save();
rsql.ExecuteSql(string.Format(insertsql, ds.Tables[0].Rows[i][0], country.Id));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
