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);
}
}
