/// <summary> /// /// </summary> /// <param name="WTPID"> </param> /// <returns></returns> public static List <Entity.ProductDetail> GetProductDetailEx(int WTPID) { List <Entity.ProductDetail> list = new List <Entity.ProductDetail>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vProductDetail] where WTPID='" + WTPID + "'", null); while (dataReader.Read()) { Entity.ProductDetail entity = new Entity.ProductDetail(); entity.DetailID = DataHelper.ParseToInt(dataReader["DetailID"].ToString()); entity.WTPID = DataHelper.ParseToInt(dataReader["WTPID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); entity.Amount = decimal.Parse(dataReader["Amount"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="DateTime"> </param> /// <returns></returns> public static List <Entity.ProductDetail> GetSumProductDetail() { List <Entity.ProductDetail> list = new List <Entity.ProductDetail>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { string Start = string.Format("{0}-01-01", DateTime.Now.Year); string End = string.Format("{0}-12-31", DateTime.Now.Year); IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(Amount) as Total,WasteName from vProductDetail where Status=2 and DateTime>='" + Start + "' and DateTime<='" + End + "' group by WasteName", null); while (dataReader.Read()) { Entity.ProductDetail entity = new Entity.ProductDetail(); entity.Name = dataReader["WasteName"].ToString(); entity.Amount = decimal.Parse(dataReader["Total"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
public static int UpdateProductDetail(Entity.ProductDetail 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("@DetailID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DetailID.GetType().ToString()), entity.DetailID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductDetail_Update", 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 { int iReturn = 0; try { Entity.WasteToProduct entity = new Entity.WasteToProduct(); entity.CreateDate = DateTime.Now; entity.UpdateDate = DateTime.Now; entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.DateTime = FDate.SelectedDate; entity.FromPondID = int.Parse(drop_Pond.SelectedValue); entity.FromAmount = decimal.Parse(NB_Amount.Text); entity.FromWasteCode = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue)).Stores; entity.HanderManID = int.Parse(hf_HandelManID.Text); if (!string.IsNullOrEmpty(txt_Receiver.Text.Trim())) { entity.ReceiverID = int.Parse(hf_ReceiverID.Text); } else { entity.ReceiverID = 0; } entity.Status = 1; if (string.IsNullOrEmpty(sGuid)) { //Add List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); List <Entity.ProductDetail> Adds = new List <Entity.ProductDetail>(); for (int i = 0; i < newAddedList.Count; i++) { Entity.ProductDetail add = new Entity.ProductDetail(); add.Name = newAddedList[i]["Name"].ToString(); add.PondID = DAL.Pond.GetPondByName(add.Name).PondID; add.Amount = decimal.Parse(newAddedList[i]["Amount"].ToString()); add.ItemCode = DAL.Waste.GetWasteCodeByName(newAddedList[i]["WasteName"].ToString()); Adds.Add(add); } //List<Dictionary<string, object>> newAddedList2 = Grid2.GetNewAddedList(); //List<Entity.FinalWaste> Adds2 = new List<Entity.FinalWaste>(); //for (int i = 0; i < newAddedList2.Count; i++) //{ // Entity.FinalWaste add = new Entity.FinalWaste(); // add.Result = decimal.Parse(newAddedList2[i]["Result2"].ToString()); // add.ItemCode = DAL.Waste.GetWasteCodeByName(newAddedList2[i]["WasteName2"].ToString()); // Adds2.Add(add); //} iReturn = DAL.WasteToProduct.AddWasteToProductEntity(entity, Adds); } else { //Update entity.DealID = int.Parse(sGuid); List <int> deletedRows = Grid1.GetDeletedList(); List <Entity.ProductDetail> Deletes = new List <Entity.ProductDetail>(); foreach (int rowIndex in deletedRows) { Entity.ProductDetail delete = new Entity.ProductDetail(); delete.DetailID = Convert.ToInt32(Grid1.DataKeys[rowIndex][1]); Deletes.Add(delete); } Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); List <Entity.ProductDetail> Updates = new List <Entity.ProductDetail>(); foreach (int rowIndex in modifiedDict.Keys) { Entity.ProductDetail update = new Entity.ProductDetail(); update.DetailID = Convert.ToInt32(Grid1.DataKeys[rowIndex][1]); update.ItemCode = DAL.Waste.GetWasteCodeByName(Grid1.DataKeys[rowIndex][2].ToString()); update.Amount = decimal.Parse(Grid1.DataKeys[rowIndex][3].ToString()); update.PondID = 1; update.Status = 1; Updates.Add(update); } List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); List <Entity.ProductDetail> Adds = new List <Entity.ProductDetail>(); for (int i = 0; i < newAddedList.Count; i++) { Entity.ProductDetail add = new Entity.ProductDetail(); add.Name = newAddedList[i]["Name"].ToString(); add.PondID = DAL.Pond.GetPondByName(add.Name).PondID; add.Amount = decimal.Parse(newAddedList[i]["Amount"].ToString()); add.ItemCode = DAL.Waste.GetWasteCodeByName(newAddedList[i]["WasteName"].ToString()); Adds.Add(add); } //List<int> deletedRows2 = Grid2.GetDeletedList(); //List<Entity.FinalWaste> Deletes2 = new List<Entity.FinalWaste>(); //foreach (int rowIndex in deletedRows2) //{ // Entity.FinalWaste delete = new Entity.FinalWaste(); // delete.FWID = Convert.ToInt32(Grid2.DataKeys[rowIndex][1]); // Deletes2.Add(delete); //} //Dictionary<int, Dictionary<string, object>> modifiedDict2 = Grid2.GetModifiedDict(); //List<Entity.FinalWaste> Updates2 = new List<Entity.FinalWaste>(); //foreach (int rowIndex in modifiedDict2.Keys) //{ // Entity.FinalWaste update = new Entity.FinalWaste(); // update.FWID = Convert.ToInt32(Grid2.DataKeys[rowIndex][1]); // update.ItemCode = DAL.Waste.GetWasteCodeByName(Grid2.DataKeys[rowIndex][2].ToString()); // update.Result = decimal.Parse(Grid2.DataKeys[rowIndex][3].ToString()); // update.Status = 1; // Updates2.Add(update); //} //List<Dictionary<string, object>> newAddedList2 = Grid2.GetNewAddedList(); //List<Entity.FinalWaste> Adds2 = new List<Entity.FinalWaste>(); //for (int i = 0; i < newAddedList2.Count; i++) //{ // Entity.FinalWaste add = new Entity.FinalWaste(); // add.Result = decimal.Parse(newAddedList2[i]["Result2"].ToString()); // add.ItemCode = DAL.Waste.GetWasteCodeByName(newAddedList2[i]["WasteName2"].ToString()); // Adds2.Add(add); //} iReturn = DAL.WasteToProduct.UpdateWasteToProductEntity(entity, Adds, Updates, Deletes); } } catch (Exception ex) { } finally { } if (iReturn == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } #endregion }