/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_CityCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_CityCode set ");
strSql.Append("Name=@Name,");
strSql.Append("Code=@Code");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 100),
new SqlParameter("@Code", SqlDbType.VarChar, 100),
new SqlParameter("@ID", SqlDbType.Int)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Code;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <lgk.Model.tb_CityCode> DataTableToList(DataTable dt)
{
List <lgk.Model.tb_CityCode> modelList = new List <lgk.Model.tb_CityCode>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
lgk.Model.tb_CityCode model;
for (int n = 0; n < rowsCount; n++)
{
model = new lgk.Model.tb_CityCode();
if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["Name"] != null && dt.Rows[n]["Name"].ToString() != "")
{
model.Name = dt.Rows[n]["Name"].ToString();
}
if (dt.Rows[n]["Code"] != null && dt.Rows[n]["Code"].ToString() != "")
{
model.Code = dt.Rows[n]["Code"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_CityCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_CityCode(");
strSql.Append("Name,Code)");
strSql.Append(" values (");
strSql.Append("@Name,@Code)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 100),
new SqlParameter("@Code", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Code;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public lgk.Model.tb_CityCode GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Code from tb_CityCode ");
strSql.Append(" where " + where);
lgk.Model.tb_CityCode model = new lgk.Model.tb_CityCode();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Code"] != null && ds.Tables[0].Rows[0]["Code"].ToString() != "")
{
model.Code = ds.Tables[0].Rows[0]["Code"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 站点简码查询处理
/// </summary>
/// <param name="dic1"></param>
/// <param name="dic2"></param>
/// <param name="act"></param>
/// <returns></returns>
private string CityCode(Dictionary <string, string> dic1, Dictionary <string, string> dic2, string act)
{
string respon = RequestSumit(dic2, dic1["RequestUrl"].ToString(), act);
string reslit = "";
if (respon != "error")
{
var Result = JsonConvert.DeserializeObject <ListRespondResult>(respon);
if (Result.result.Count > 0)
{
for (int i = 0; i < Result.result.Count; i++)
{
lgk.Model.tb_CityCode city = bllcity.GetModel("Name='" + Result.result[i].name + "'");
if (city == null)
{
lgk.Model.tb_CityCode model = new lgk.Model.tb_CityCode();
model.Name = Result.result[i].name;
model.Code = Result.result[i].code;
bllcity.Add(model);
}
else
{
city.Name = Result.result[i].name;
city.Code = Result.result[i].code;
bllcity.Update(city);
}
}
reslit = "已成功更新站点简码";
}
else
{
reslit = "查询站点失败";
}
}
else
{
reslit = "请求异常";
}
return("{\"reason\":\"成功的返回\",\"result\":\"" + reslit + "\",\"error_code\":0}");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_CityCode model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_CityCode model)
{
return(dal.Add(model));
}
