/// <summary> ///无分页获取列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public DataTable GetList(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_Scrap_ListSelect", parms)); }
/// <summary> /// 录入新报废理由 /// </summary> void ScrapAdd() { MLMGC.Security.PersonalPage pp = new MLMGC.Security.PersonalPage(true); string name = nv["name"]; E_Scrap data = new E_Scrap(); data.PersonalID = pp.PersonalID; data.ScrapID = 0; data.ScrapName = name; int scrapid = new T_Scrap().Add(data); HttpContext.Current.Response.Write(scrapid); }
/// <summary> /// 删除一条数据 /// </summary> public int Delete(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ScrapID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ScrapID; int ReturnValue = 0, irowsAffected = 0; irowsAffected = DbHelperSQL.RunProcedures("ProcEP_B_Scrap_Delete", parms, out ReturnValue); return(ReturnValue); }
/// <summary> /// 删除一条数据 /// </summary> /// <remarks>tianzhenyun 2011-10-19</remarks> public bool Delete(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@ScrapID", SqlDbType.Int) }; parms[0].Value = data.PersonalID; parms[1].Value = data.ScrapID; int ReturnValue = 0, irowsAffected = 0; irowsAffected = DbHelperSQL.RunProcedures("ProcPI_B_Scrap_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 删除报废理由 /// </summary> void ScrapDelete() { MLMGC.Security.PersonalPage pp = new MLMGC.Security.PersonalPage(true); int scrapid = 0; int.TryParse(nv["scrapid"], out scrapid); E_Scrap data = new E_Scrap(); data.PersonalID = pp.PersonalID; data.ScrapID = scrapid; bool b = new T_Scrap().Delete(data); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/// <summary> /// 报废理由是否存在 /// </summary> void ScrapExists() { MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true); int scrapid = 0; int.TryParse(nv["scrapid"], out scrapid); string name = nv["name"]; E_Scrap data = new E_Scrap(); data.EnterpriseID = ep.EnterpriceID; data.ScrapID = scrapid; data.ScrapName = name; bool b = new T_Scrap().Exists(data); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ScrapName", SqlDbType.NVarChar, 128) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ScrapName; int ReturnValue = 0; DbHelperSQL.RunProcedures("ProcEP_B_Scrap_Insert", parms, out ReturnValue); data.ScrapID = ReturnValue; return(ReturnValue); }
/// <summary> /// 录入新报废理由 /// </summary> void ScrapAdd() { MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true); string name = nv["name"]; E_Scrap data = new E_Scrap(); data.EnterpriseID = ep.EnterpriceID; data.ScrapID = 0; data.ScrapName = name; int scrapid = new T_Scrap().Add(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "添加报废理由", IP = MLMGC.COMP.Requests.GetRealIP() }); HttpContext.Current.Response.Write(scrapid); }
/// <summary> /// 是否存在该记录 /// </summary> /// <remarks>tianzhenyun 2011-10-19</remarks> public bool Exists(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@ScrapID", SqlDbType.Int), new SqlParameter("@ScrapName", SqlDbType.NVarChar, 128) }; parms[0].Value = data.PersonalID; parms[1].Value = data.ScrapID; parms[2].Value = data.ScrapName; int ReturnValue = 0; DbHelperSQL.RunProcedures("ProcPI_B_Scrap_Exists", parms, out ReturnValue); return(ReturnValue == 1); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ScrapID", SqlDbType.Int), new SqlParameter("@ScrapName", SqlDbType.NVarChar, 128) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ScrapID; parms[2].Value = data.ScrapName; int ReturnValue = 0, irowsAffected = 0; irowsAffected = DbHelperSQL.RunProcedures("ProcEP_B_Scrap_Update", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_Scrap GetModel(E_Scrap data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ScrapID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ScrapID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_Scrap_Select", parms); if (dt != null && dt.Rows.Count == 1) { data.ScrapName = dt.Rows[0]["ScrapName"].ToString(); } return(data); }
/// <summary> /// 删除报废理由 /// </summary> void ScrapDelete() { MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true); int scrapid = 0; int.TryParse(nv["scrapid"], out scrapid); E_Scrap data = new E_Scrap(); data.EnterpriseID = ep.EnterpriceID; data.ScrapID = scrapid; int result = new T_Scrap().Delete(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "删除报废理由", IP = MLMGC.COMP.Requests.GetRealIP() }); HttpContext.Current.Response.Write(result.ToString()); }
/// <summary> /// 修改报废理由 /// </summary> void ScrapUpdate() { MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true); int scrapid = 0; int.TryParse(nv["scrapid"], out scrapid); string name = nv["name"]; E_Scrap data = new E_Scrap(); data.EnterpriseID = ep.EnterpriceID; data.ScrapID = scrapid; data.ScrapName = name; bool b = new T_Scrap().Update(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "修改报废理由", IP = MLMGC.COMP.Requests.GetRealIP() }); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/// <summary> /// 获取显示报废理由 /// </summary> void ScrapShow() { MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true); int scrapid = 0; int.TryParse(nv["scrapid"], out scrapid); E_Scrap data = new E_Scrap(); data.EnterpriseID = ep.EnterpriceID; data.ScrapID = scrapid; data = new T_Scrap().GetModel(data); if (data == null) { data = new E_Scrap(); data.ScrapID = 0; } JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("id", data.ScrapID.ToString())); colDR.Add(new JsonStringValue("name", data.ScrapName)); HttpContext.Current.Response.Write(colDR.ToString()); }
/// <summary> ///无分页获取列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public DataTable GetList(E_Scrap data) { return(dal.GetList(data)); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_Scrap GetModel(E_Scrap data) { return(dal.GetModel(data)); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(E_Scrap data) { return(dal.Delete(data)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_Scrap data) { return(dal.Update(data)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_Scrap data) { return(dal.Add(data)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(E_Scrap data) { return(dal.Exists(data)); }
/// <summary> /// 删除一条数据 /// </summary> public int Delete(E_Scrap data) { return(dal.Delete(data)); }