/// <summary> /// /// </summary> /// <param name="Type"> </param> /// <returns></returns> public static List <Entity.Waste> GetPartWasteEx(int Type) { List <Entity.Waste> list = new List <Entity.Waste>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Waste] where Type='" + Type + "'", null); while (dataReader.Read()) { Entity.Waste entity = new Entity.Waste(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.List = dataReader["List"].ToString(); entity.Type = DataHelper.ParseToInt(dataReader["Type"].ToString()); entity.Unit = dataReader["Unit"].ToString(); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
public static int AddWaste(Entity.Waste entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 20), dbFactory.MakeInParam("@WasteName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteName.GetType().ToString()), entity.WasteName, 50), dbFactory.MakeInParam("@List", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.List.GetType().ToString()), entity.List, 50), dbFactory.MakeInParam("@Type", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Type.GetType().ToString()), entity.Type, 32), dbFactory.MakeInParam("@Unit", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Unit.GetType().ToString()), entity.Unit, 20), dbFactory.MakeInParam("@OrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OrderID.GetType().ToString()), entity.OrderID, 32), dbFactory.MakeInParam("@IsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsShow.GetType().ToString()), entity.IsShow, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Waste_Add", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
protected void btn_save_Click(object sender, EventArgs e) { string msg = checkInput(); if (msg != "") { Alert.Show(msg); return; } else { Entity.Waste entity = new Entity.Waste(); entity.WasteCode = WasteCode.Text.Trim(); // = ds.Tables[0].Rows[0]["单位全称"].ToString(); entity.WasteName = WasteName.Text.Trim(); // = ds.Tables[0].Rows[0]["单位曾用名全称"].ToString(); entity.List = List.Text.Trim(); entity.OrderID = int.Parse(Orderid.Text.ToString()); entity.Unit = Unit.Text.Trim();// = ds.Tables[0].Rows[0]["单位法人代码"].ToString(); entity.IsShow = int.Parse(CheckStop.SelectedValue.ToString()); entity.Type = int.Parse(drop_Type.SelectedValue.ToString()); if (string.IsNullOrEmpty(sGuid)) { //Add int success = DAL.Waste.AddWaste(entity); if (success == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } else { //Update entity.ID = int.Parse(sGuid); int success = DAL.Waste.UpdateWaste(entity); if (success == 1) { Alert.ShowInTop(" 修改成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 修改失败!", MessageBoxIcon.Warning); } } } }
protected void Page_Init(object sender, EventArgs e) { List <Entity.Waste> items = DAL.Waste.GetPartWasteEx(2); //this.ddlGrade.DataSource = grade; //this.ddlGrade.DataTextField = "Name"; //this.ddlGrade.DataValueField = "ID"; //this.ddlGrade.DataBind(); for (int i = 0; i < items.Count; i++) { FineUI.ListItem li = new FineUI.ListItem(); Entity.Waste item = items[i]; li.Text = item.WasteName; li.Value = item.WasteName; this.drop_Product.Items.Insert(i, li); } //List<Entity.Waste> items2 = DAL.Waste.GetPartWasteEx(3); //for (int i = 0; i < items2.Count; i++) //{ // FineUI.ListItem li = new FineUI.ListItem(); // Entity.Waste item = items2[i]; // li.Text = item.WasteName; // li.Value = item.WasteName; // this.drop_NewWaste.Items.Insert(i, li); //} //List<Entity.Pond> items3 = DAL.Pond.GetAllPondEx(); List <Entity.Pond> items3 = DAL.Pond.GetAllPondEx2(2); for (int i = 0; i < items3.Count; i++) { FineUI.ListItem li = new FineUI.ListItem(); Entity.Pond item = items3[i]; li.Text = item.Name; li.Value = item.Name; this.drop_Pond2.Items.Insert(i, li); } //DataTable table2 = DAL.Pond.GetAllPond(); DataTable table2 = DAL.Pond.GetPartPond(1); drop_Pond.DataSource = table2; drop_Pond.DataTextField = "Name"; drop_Pond.DataValueField = "PondID"; drop_Pond.DataBind(); }
protected void Page_Init(object sender, EventArgs e) { List <Entity.Waste> items2 = DAL.Waste.GetPartWasteEx(3); for (int i = 0; i < items2.Count; i++) { FineUI.ListItem li = new FineUI.ListItem(); Entity.Waste item = items2[i]; li.Text = item.WasteName; li.Value = item.WasteName; this.drop_NewWaste.Items.Insert(i, li); } //DataTable table2 = DAL.Pond.GetAllPond(); }
private void LoadData(string sId) { if (sId != string.Empty) { Entity.Waste entity = DAL.Waste.GetWaste(int.Parse(sId)); if (entity != null) { WasteCode.Text = entity.WasteCode; //txt_pwNO.Text = ds.Tables[0].Rows[0]["排污权证号"].ToString(); WasteName.Text = entity.WasteName; List.Text = entity.List; Unit.Text = entity.Unit; drop_Type.SelectedValue = entity.Type.ToString(); CheckStop.SelectedValue = entity.IsShow.ToString(); Orderid.Text = entity.OrderID.ToString(); } } }