public ActionResult btnSave_Click(FormCollection values)
{
CFG_CARINFO info = new CFG_CARINFO();
info.ID = Convert.ToInt32(values["Id"]);
info.VEHICLENO = values["VehicleNo"];
info.VEHICLETYPE = Convert.ToInt32(values["VehicleType"]);
info.VEHICLEBRAND = values["VehicleBrand"];
info.BELONGDEPTID = Convert.ToInt32(values["BelongDeptId"]);
info.BELONGNETID = Convert.ToInt32(values["BelongNetId"]);
info.OWNERTYPE = Convert.ToInt32(values["OwnerType"]);
info.REMARK = values["Remark"];
info.OWNER = values["Owner"];
info.CLDWZDSBH = values["Cldwzdsbh"];
info.WLWKHM = values["Wlwkhm"];
var isSuccess = CarBLL.Update(info);
ActiveWindow.HidePostBack();
if (isSuccess)
{
ShowNotify("数据修改成功！");
}
else
{
ShowNotify("数据修改失败！");
}
return(UIHelper.Result());
}
/// <summary>
/// 添加车辆信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Add(CFG_CARINFO info)
{
bool isSuccess = true;
StringBuilder pInsertText = new StringBuilder();
pInsertText.Append("INSERT INTO CFG_CARINFO(VEHICLENO,VEHICLETYPE,VEHICLEBRAND,BELONGDEPTID,BELONGNETID,REMARK,ISDELETED,OWNER,OWNERTYPE,CLDWZDSBH,WLWKHM) VALUES('");
pInsertText.Append(info.VEHICLENO + "'," + info.VEHICLETYPE + ",'" + info.VEHICLEBRAND + "'," + info.BELONGDEPTID + "," + info.BELONGNETID + ",'" + info.REMARK + "'," + info.ISDELETED + ",'");
pInsertText.Append(info.OWNER + "'," + info.OWNERTYPE + ",'" + info.CLDWZDSBH + "','" + info.WLWKHM + "')");
try
{
OracleOperateBLL.ExecuteSql(pInsertText.ToString());
}
catch
{
isSuccess = false;
}
return(isSuccess);
//DbBase<CFG_CARINFO> db = new DbBase<CFG_CARINFO>();
//db.Insert(info);
//if (db.SaveChanges() >= 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}
/// <summary>
/// 修改车辆信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Update(CFG_CARINFO info)
{
bool isSuccess = true;
StringBuilder pUpdateText = new StringBuilder();
pUpdateText.Append("UPDATE CFG_CARINFO SET VEHICLENO='" + info.VEHICLENO + "',VEHICLETYPE=" + info.VEHICLETYPE + ",VEHICLEBRAND='" + info.VEHICLEBRAND + "',BELONGDEPTID=" + info.BELONGDEPTID + ",BELONGNETID=" + info.BELONGNETID + ",");
pUpdateText.Append("REMARK='" + info.REMARK + "',OWNER='" + info.OWNER + "',OWNERTYPE=" + info.OWNERTYPE + ",CLDWZDSBH='" + info.CLDWZDSBH + "',WLWKHM='" + info.WLWKHM + "' ");
pUpdateText.Append("WHERE ID=" + info.ID);
try
{
OracleOperateBLL.ExecuteSql(pUpdateText.ToString());
}
catch
{
isSuccess = false;
}
return(isSuccess);
//DbBase<CFG_CARINFO> db = new DbBase<CFG_CARINFO>();
//db.Update(info);
//if (db.SaveChanges() >= 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}
/// <summary>
/// 获取车辆信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CFG_CARINFO Get(int id)
{
CFG_CARINFO pCarInfo = new CFG_CARINFO();
OracleConnection pConn = null;
OracleCommand pComm = null;
OracleDataReader pReader = null;
pConn = new OracleConnection(ORACLE_CONNECTION_STRING);
pConn.Open();
string pCmdText = "SELECT ID,VEHICLENO,VEHICLETYPE,VEHICLEBRAND,BELONGDEPTID,BELONGNETID,REMARK,ISDELETED,OWNER,OWNERTYPE,CLDWZDSBH,WLWKHM FROM CFG_CARINFO WHERE ID = " + id + "";
pComm = new OracleCommand(pCmdText, pConn);
pReader = pComm.ExecuteReader();
while (pReader.Read())
{
pCarInfo.ID = Convert.ToInt32(pReader["ID"]);
pCarInfo.VEHICLENO = Convert.ToString(pReader["VEHICLENO"]);
pCarInfo.VEHICLETYPE = Convert.ToInt32(pReader["VEHICLETYPE"]);
pCarInfo.VEHICLEBRAND = Convert.ToString(pReader["VEHICLEBRAND"]);
pCarInfo.BELONGDEPTID = Convert.ToInt32(pReader["BELONGDEPTID"]);
pCarInfo.BELONGNETID = Convert.ToInt32(pReader["BELONGNETID"]);
pCarInfo.REMARK = Convert.ToString(pReader["REMARK"]);
pCarInfo.ISDELETED = Convert.ToInt32(pReader["ISDELETED"]);
pCarInfo.OWNER = Convert.ToString(pReader["OWNER"]);
pCarInfo.OWNERTYPE = Convert.ToInt32(pReader["OWNERTYPE"]);
pCarInfo.CLDWZDSBH = Convert.ToString(pReader["CLDWZDSBH"]);
pCarInfo.WLWKHM = Convert.ToString(pReader["WLWKHM"]);
}
if (pReader != null)
{
pReader.Close();
pReader.Dispose();
}
if (pComm != null)
{
pComm.Dispose();
}
if (pConn != null)
{
pConn.Close();
pConn.Dispose();
}
return(pCarInfo);
//DbBase<CFG_CARINFO> db = new DbBase<CFG_CARINFO>();
//return db.FirstOrDefault(p => p.ID == id);
}
