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