/// <summary>
/// 获取仪器信息
/// </summary>
/// <returns></returns>
private string getApparatusInfo()
{
int intTotalCount = 0;
DataTable dt = new DataTable();
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo.SORT_FIELD = strSortname;
TBaseApparatusInfoVo.SORT_TYPE = strSortorder;
//自定义查询使用
TBaseApparatusInfoVo.APPARATUS_CODE = !String.IsNullOrEmpty(Request.Params["srhApparatus_Code"]) ? Request.Params["srhApparatus_Code"].ToString() : "";
TBaseApparatusInfoVo.NAME = !String.IsNullOrEmpty(Request.Params["srh_Name"]) ? Request.Params["srh_Name"].ToString() : "";;
TBaseApparatusInfoVo.MODEL = !String.IsNullOrEmpty(Request.Params["srh_Model"]) ? Request.Params["srh_Model"].ToString() : "";;
TBaseApparatusInfoVo.FITTINGS_PROVIDER = !String.IsNullOrEmpty(Request.Params["srhProvider"]) ? Request.Params["srhProvider"].ToString() : "";;
intTotalCount = new TBaseApparatusInfoLogic().GetSelecDefinedtResultCount(TBaseApparatusInfoVo);
dt = new TBaseApparatusInfoLogic().SelectDefinedTadble(TBaseApparatusInfoVo, intPageIndex, intPageSize);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 获取仪器信息
/// </summary>
/// <returns></returns>
private string getApparatusWarn()
{
int intTotalCount = 0;
DataTable dt = new DataTable();
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo.SORT_FIELD = strSortname;
TBaseApparatusInfoVo.SORT_TYPE = strSortorder;
string strAction = Request.Params["action"];
if (strAction == "ident")
{
//检定报警
dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2, 1);
intTotalCount = new TBaseApparatusInfoLogic().GetSelectResultCount(TBaseApparatusInfoVo, 2, 1);
}
else
{
//报废报警
dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2);
intTotalCount = dt.Rows.Count;
}
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 增加数据
/// </summary>
/// <returns></returns>
public string frmAdd()
{
bool isSuccess = false;
TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo());
TBaseApparatusInfoVo.ID = GetSerialNumber("Apparatus_Id");
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo iApparatusInfoVo = new TBaseApparatusInfoVo();
iApparatusInfoVo.APPARATUS_CODE = TBaseApparatusInfoVo.APPARATUS_CODE;
iApparatusInfoVo.IS_DEL = "0";
iApparatusInfoVo = new TBaseApparatusInfoLogic().Details(iApparatusInfoVo);
if (iApparatusInfoVo.ID.Length > 0)
{
isSuccess = false;
}
else
{
isSuccess = new TBaseApparatusInfoLogic().Create(TBaseApparatusInfoVo);
if (isSuccess)
{
WriteLog(i3.ValueObject.ObjectBase.LogType.AddApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "添加仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 加载数据
/// </summary>
/// <returns></returns>
public string frmLoadData()
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.ID = Request["id"].ToString();
TBaseApparatusInfoVo.IS_DEL = "0";
TBaseApparatusInfoVo TBaseApparatusInfoVoTemp = new TBaseApparatusInfoLogic().Details(TBaseApparatusInfoVo);
return(ToJson(TBaseApparatusInfoVoTemp));
}
public static string deleteApparatusInfo(string strValue)
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo();
TBaseApparatusInfoVo.ID = strValue;
TBaseApparatusInfoVo.IS_DEL = "1";
bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo);
if (isSuccess)
{
new i3.View.PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.DelApparatusInfo, "", new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "删除仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 修改数据
/// </summary>
/// <returns></returns>
public string frmUpdate()
{
TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo());
TBaseApparatusInfoVo.ID = Request["id"].ToString();
TBaseApparatusInfoVo.IS_DEL = "0";
bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo);
if (isSuccess)
{
WriteLog(i3.ValueObject.ObjectBase.LogType.EditApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "修改仪器信息" + TBaseApparatusInfoVo.ID + "成功！");
}
return(isSuccess == true ? "1" : "0");
}
//获取仪器，仅为下拉框 弹出grid使用
private void GetApparatus()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
string strSrhApparatus_CODE = (Request.Params["strSrhApparatus_CODE"] != null) ? Request.Params["strSrhApparatus_CODE"] : "";
string strSrhName = (Request.Params["strSrhName"] != null) ? Request.Params["strSrhName"] : "";
TBaseApparatusInfoLogic logicApparatus = new TBaseApparatusInfoLogic();
int intTotalCount = logicApparatus.GetSelectResultCount_ForSelectApparatus_inItem(strSrhName, strSrhApparatus_CODE);;//总计的数据条数
DataTable dt = logicApparatus.SelectByTable_ForSelectApparatus_inItem(strSrhName, strSrhApparatus_CODE, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
