public static int UpdateMonitorItem(Entity.MonitorItem 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("@ItemID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemID.GetType().ToString()),entity.ItemID,32), // dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()),entity.ItemCode,20), // dbFactory.MakeInParam("@ItemName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemName.GetType().ToString()),entity.ItemName,50), // 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_AnalysisItem_Update", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [MonitorItem] set ItemCode='"+ entity.ItemCode + "',ItemName='" + entity.ItemName + "',OrderID='" + entity.OrderID + "',IsShow='" + entity.IsShow + "',Unit='" + entity.Unit + "'where ItemID='" + entity.ItemID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="IsShow"> </param> /// <returns></returns> public static List <Entity.MonitorItem> GetMonitorItemList(int IsShow) { List <Entity.MonitorItem> list = new List <Entity.MonitorItem>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [MonitorItem] where IsShow='" + IsShow + "'", null); while (dataReader.Read()) { Entity.MonitorItem entity = new Entity.MonitorItem(); entity.ItemID = DataHelper.ParseToInt(dataReader["ItemID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.ItemName = dataReader["ItemName"].ToString(); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString()); entity.Unit = dataReader["Unit"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
protected void btn_save_Click(object sender, EventArgs e) { string msg = checkInput(); if (msg != "") { Alert.Show(msg); return; } else { Entity.MonitorItem entity = new Entity.MonitorItem(); entity.ItemCode = WasteCode.Text.Trim(); // = ds.Tables[0].Rows[0]["单位全称"].ToString(); entity.ItemName = WasteName.Text.Trim(); // = ds.Tables[0].Rows[0]["单位曾用名全称"].ToString(); entity.OrderID = int.Parse(Orderid.Text.ToString()); entity.IsShow = int.Parse(CheckStop.SelectedValue.ToString()); entity.Unit = Unit.Text.Trim(); if (string.IsNullOrEmpty(sGuid)) { //Add int success = DAL.MonitorItem.AddMonitorItem(entity); if (success == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } else { //Update entity.ItemID = int.Parse(sGuid); int success = DAL.MonitorItem.UpdateMonitorItem(entity); if (success == 1) { Alert.ShowInTop(" 修改成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 修改失败!", MessageBoxIcon.Warning); } } } }
private void LoadData(string sId) { if (sId != string.Empty) { Entity.MonitorItem entity = DAL.MonitorItem.GetMonitorItemByID(int.Parse(sId)); if (entity != null) { WasteCode.Text = entity.ItemCode; //txt_pwNO.Text = ds.Tables[0].Rows[0]["排污权证号"].ToString(); WasteName.Text = entity.ItemName; CheckStop.SelectedValue = entity.IsShow.ToString(); Orderid.Text = entity.OrderID.ToString(); Unit.Text = entity.Unit; } } }
protected void Page_Init(object sender, EventArgs e) { List <Entity.MonitorItem> items = DAL.MonitorItem.GetMonitorItemList(1); //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.MonitorItem item = items[i]; li.Text = item.ItemName; li.Value = item.ItemName; this.drop_Item.Items.Insert(i, li); } }