/// <summary>
/// 修改网格信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Update(CFG_NETINFO info)
{
bool isSuccess = true;
StringBuilder pUpdateText = new StringBuilder();
pUpdateText.Append("UPDATE CFG_NETINFO SET NAME='" + info.NAME + "',POPULATIONINFO='" + info.POPULATIONINFO + "',HOUSEINFO='" + info.HOUSEINFO + "',UNITSTOREINFO='" + info.UNITSTOREINFO + "',BELONGAREA='" + info.BELONGAREA + "',");
pUpdateText.Append("BELONGDEPTID=" + info.BELONGDEPTID + ",REMARK='" + info.REMARK + "',NETCOLOR='" + info.NETCOLOR + "',LONANDLAT='" + info.LONANDLAT + "' ");
pUpdateText.Append("WHERE ID=" + info.ID);
try
{
OracleOperateBLL.ExecuteSql(pUpdateText.ToString());
}
catch
{
isSuccess = false;
}
return(isSuccess);
//DbBase<CFG_NETINFO> db = new DbBase<CFG_NETINFO>();
//db.Update(info);
//if (db.SaveChanges() >= 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}
/// <summary>
/// 添加网格信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Add(CFG_NETINFO info)
{
bool isSuccess = true;
StringBuilder pInsertText = new StringBuilder();
pInsertText.Append("INSERT INTO CFG_NETINFO(NAME,POPULATIONINFO,HOUSEINFO,UNITSTOREINFO,BELONGAREA,BELONGDEPTID,REMARK,ISDELETED,NETCOLOR,LONANDLAT) VALUES('");
pInsertText.Append(info.NAME + "','" + info.POPULATIONINFO + "','" + info.HOUSEINFO + "','" + info.UNITSTOREINFO + "','" + info.BELONGAREA + "'," + info.BELONGDEPTID + ",'" + info.REMARK + "',");
pInsertText.Append(info.ISDELETED + ",'" + info.NETCOLOR + "','" + info.LONANDLAT + "')");
try
{
OracleOperateBLL.ExecuteSql(pInsertText.ToString());
}
catch
{
isSuccess = false;
}
return(isSuccess);
//DbBase<CFG_NETINFO> db = new DbBase<CFG_NETINFO>();
//db.Insert(info);
//if (db.SaveChanges() >= 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}
public ActionResult btnSave_Click(FormCollection values)
{
CFG_NETINFO info = new CFG_NETINFO();
info.ID = Convert.ToInt32(values["Id"]);
info.NAME = values["Name"];
info.BELONGDEPTID = Convert.ToInt32(values["BelongDeptId"]);
info.POPULATIONINFO = values["PopulationInfo"];
info.HOUSEINFO = values["HouseInfo"];
info.BELONGAREA = values["BelongArea"];
info.UNITSTOREINFO = values["UnitStoreInfo"];
info.NETCOLOR = values["NetColor"];
info.LONANDLAT = values["LonAndLat"];
info.REMARK = values["Remark"];
var isSuccess = NetManageBLL.Update(info);
ActiveWindow.HidePostBack();
if (isSuccess)
{
ShowNotify("数据修改成功！");
}
else
{
ShowNotify("数据修改失败！");
}
return(UIHelper.Result());
}
/// <summary>
/// 获取网格信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CFG_NETINFO Get(int id)
{
CFG_NETINFO pNetInfo = new CFG_NETINFO();
OracleConnection pConn = null;
OracleCommand pComm = null;
OracleDataReader pReader = null;
pConn = new OracleConnection(ORACLE_CONNECTION_STRING);
pConn.Open();
string pCmdText = "SELECT ID,NAME,POPULATIONINFO,HOUSEINFO,UNITSTOREINFO,BELONGAREA,BELONGDEPTID,REMARK,ISDELETED,NETCOLOR,LONANDLAT FROM CFG_NETINFO WHERE ID = " + id + "";
pComm = new OracleCommand(pCmdText, pConn);
pReader = pComm.ExecuteReader();
while (pReader.Read())
{
pNetInfo.ID = Convert.ToInt32(pReader["ID"]);
pNetInfo.NAME = Convert.ToString(pReader["NAME"]);
pNetInfo.POPULATIONINFO = Convert.ToString(pReader["POPULATIONINFO"]);
pNetInfo.HOUSEINFO = Convert.ToString(pReader["HOUSEINFO"]);
pNetInfo.UNITSTOREINFO = Convert.ToString(pReader["UNITSTOREINFO"]);
pNetInfo.BELONGAREA = Convert.ToString(pReader["BELONGAREA"]);
pNetInfo.BELONGDEPTID = Convert.ToInt32(pReader["BELONGDEPTID"]);
pNetInfo.REMARK = Convert.ToString(pReader["REMARK"]);
pNetInfo.ISDELETED = Convert.ToInt32(pReader["ISDELETED"]);
pNetInfo.NETCOLOR = Convert.ToString(pReader["NETCOLOR"]);
pNetInfo.LONANDLAT = Convert.ToString(pReader["LONANDLAT"]);
}
if (pReader != null)
{
pReader.Close();
pReader.Dispose();
}
if (pComm != null)
{
pComm.Dispose();
}
if (pConn != null)
{
pConn.Close();
pConn.Dispose();
}
return(pNetInfo);
//DbBase<CFG_NETINFO> db = new DbBase<CFG_NETINFO>();
//return db.FirstOrDefault(p => p.ID == id);
}
