public static string deleteData(string strDelIDs)
{
if (strDelIDs.Length == 0)
{
return("0");
}
string[] arrDelIDs = strDelIDs.Split(',');
bool isSuccess = true;
for (int i = 0; i < arrDelIDs.Length; i++)
{
TOaPartInfoVo objPart = new TOaPartInfoVo();
objPart.ID = arrDelIDs[i];
objPart.IS_DEL = "1";
isSuccess = new TOaPartInfoLogic().Edit(objPart);
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 加载数据
/// </summary>
/// <returns></returns>
public string frmLoadData_PART_NAME()
{
if (strPartId.Length == 0)
{
return("");
}
TOaPartInfoVo objPart = new TOaPartInfoLogic().Details(strPartId);
return(objPart.PART_NAME);
}
/// <summary>
/// 加载数据
/// </summary>
/// <returns></returns>
public string frmLoadData()
{
if (strPartId.Length == 0)
{
return("");
}
TOaPartInfoVo objPart = new TOaPartInfoLogic().Details(strPartId);
return(objPart.INVENTORY);
}
public static string EditData(string strID, string strPART_CODE, string strPART_NAME, string strPART_TYPE, string strUNIT, string strMODELS, string strINVENTORY,
string strMEDIUM, string strPURE, string strALARM, string strUSEING, string strREQUEST, string strNARURE, string isCheck)
{
bool isSuccess = true;
string Msg = "0";
if (isCheck == "true")
{
TOaPartInfoVo obj = new TOaPartInfoVo();
obj.PART_CODE = strPART_CODE;
obj.PART_NAME = strPART_NAME;
obj.MODELS = strMODELS;
obj.IS_DEL = "0";
obj = new TOaPartInfoLogic().SelectByObject(obj);
if (obj.ID != "")
{
Msg = "存在相同的物料信息，请检查";
}
}
if (Msg == "0")
{
TOaPartInfoVo objPart = new TOaPartInfoVo();
objPart.ID = strID;
objPart.IS_DEL = "0";
objPart.PART_CODE = strPART_CODE;
objPart.PART_NAME = strPART_NAME;
objPart.PART_TYPE = strPART_TYPE;
objPart.UNIT = strUNIT;
objPart.MODELS = strMODELS;
objPart.INVENTORY = strINVENTORY;
objPart.MEDIUM = strMEDIUM;
objPart.PURE = strPURE;
objPart.ALARM = strALARM;
objPart.USEING = strUSEING;
objPart.REQUEST = strREQUEST;
objPart.NARURE = strNARURE;
isSuccess = new TOaPartInfoLogic().Edit(objPart);
if (isSuccess)
{
Msg = "1";
}
else
{
Msg = "0";
}
}
return(Msg);
}
public static string AddData(string strPART_CODE, string strPART_NAME, string strPART_TYPE, string strUNIT, string strMODELS, string strINVENTORY,
string strMEDIUM, string strPURE, string strALARM, string strUSEING, string strREQUEST, string strNARURE)
{
bool isSuccess = true;
string Msg = "0";
TOaPartInfoVo obj = new TOaPartInfoVo();
obj.PART_CODE = strPART_CODE;
obj.PART_NAME = strPART_NAME;
obj.MODELS = strMODELS;
obj.IS_DEL = "0";
obj = new TOaPartInfoLogic().SelectByObject(obj);
if (obj.ID == "")
{
TOaPartInfoVo objPart = new TOaPartInfoVo();
objPart.ID = GetSerialNumber("t_oa_part_info_id");
objPart.IS_DEL = "0";
objPart.PART_CODE = strPART_CODE;
objPart.PART_NAME = strPART_NAME;
objPart.MODELS = strMODELS;
objPart.PART_TYPE = strPART_TYPE;
objPart.UNIT = strUNIT;
objPart.INVENTORY = strINVENTORY;
objPart.MEDIUM = strMEDIUM;
objPart.PURE = strPURE;
objPart.ALARM = strALARM;
objPart.USEING = strUSEING;
objPart.REQUEST = strREQUEST;
objPart.NARURE = strNARURE;
isSuccess = new TOaPartInfoLogic().Create(objPart);
if (isSuccess)
{
Msg = "1";
}
else
{
Msg = "0";
}
}
else
{
Msg = "存在相同的物料信息，请检查";
}
return(Msg);
}
//获取数据
private void GetData()
{
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 strSrhPART_CODE = (Request.Params["SrhPART_CODE"] != null) ? Request.Params["SrhPART_CODE"] : "";
string strSrhPART_NAME = (Request.Params["SrhPART_NAME"] != null) ? Request.Params["SrhPART_NAME"] : "";
string strSrhPART_TYPE = (Request.Params["SrhPART_TYPE"] != null) ? Request.Params["SrhPART_TYPE"] : "";
if (strSrhPART_TYPE == "" && Request.Params["type"] != null)
{
if (Request.Params["type"].ToString() == "other")
{
strSrhPART_TYPE = "03,04,05,07";
}
else if (Request.Params["type"].ToString() == "drugs")
{
strSrhPART_TYPE = "01,02";
}
else if (Request.Params["type"].ToString() == "office")
{
strSrhPART_TYPE = "06";
}
}
TOaPartInfoVo objPart = new TOaPartInfoVo();
objPart.IS_DEL = "0";
objPart.PART_CODE = strSrhPART_CODE;
objPart.PART_NAME = strSrhPART_NAME;
objPart.PART_TYPE = strSrhPART_TYPE;
objPart.SORT_FIELD = "PART_NAME asc,MODELS";
objPart.SORT_TYPE = "asc";
objPart.REMARK1 = "query";//huangjinjun add
TOaPartInfoLogic logicPart = new TOaPartInfoLogic();
int intTotalCount = logicPart.GetSelectResultCount(objPart);;//总计的数据条数
DataTable dt = logicPart.SelectByTable_ByJoin(objPart, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
protected void btnImport_Click(object sender, EventArgs e)
{
bool isSuccess = false;
if (this.importFiles.PostedFile.ContentLength <= 0)
{
this.lable.Text = "请选择文件!";
this.lable.Visible = true;
return;
}
Stream stream = this.importFiles.FileContent;
HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
sheet.Autobreaks = true;
int rowNumber = sheet.LastRowNum;
for (int i = 1; i <= rowNumber; i++)
{
string strPART_CODE = sheet.GetRow(i).GetCell(2).ToString();
string strPART_NAME = sheet.GetRow(i).GetCell(3).ToString();
string strMODELS = sheet.GetRow(i).GetCell(6).ToString();
if (string.IsNullOrEmpty(strPART_CODE) && string.IsNullOrEmpty(strPART_NAME) && string.IsNullOrEmpty(strMODELS))
{
break;
}
TOaPartInfoVo obj = new TOaPartInfoVo();
obj.PART_CODE = strPART_CODE;
obj.PART_NAME = strPART_NAME;
obj.MODELS = strMODELS;
obj.IS_DEL = "0";
obj = new TOaPartInfoLogic().SelectByObject(obj);
if (obj.ID == "")
{
TOaPartInfoVo objPart = new TOaPartInfoVo();
objPart.ID = GetSerialNumber("t_oa_part_info_id");
objPart.IS_DEL = "0";
objPart.PART_CODE = strPART_CODE;
objPart.PART_NAME = strPART_NAME;
objPart.MODELS = strMODELS;
objPart.PART_TYPE = GetDict(sheet.GetRow(i).GetCell(5).ToString());
objPart.UNIT = sheet.GetRow(i).GetCell(7).ToString();
objPart.INVENTORY = sheet.GetRow(i).GetCell(10).ToString();
objPart.MEDIUM = "";
objPart.PURE = "";
objPart.ALARM = sheet.GetRow(i).GetCell(11).ToString();
objPart.USEING = "";
objPart.REQUEST = "";
objPart.NARURE = "";
objPart.REMARK1 = sheet.GetRow(i).GetCell(4).ToString();
objPart.REMARK2 = sheet.GetRow(i).GetCell(8).ToString();
objPart.REMARK3 = sheet.GetRow(i).GetCell(9).ToString();
isSuccess = new TOaPartInfoLogic().Create(objPart);
}
else
{
continue;
}
}
if (isSuccess)
{
this.lable.Text = "导入成功！";
this.lable.Visible = true;
}
else
{
this.lable.Text = "导入失败！";
this.lable.Visible = true;
}
}
