/// <summary> /// /// </summary> /// <param name="ResultID"> </param> /// <returns></returns> public static Entity.AnalysisResult GetAnalysisResultByID(int ResultID) { Entity.AnalysisResult entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [AnalysisResult] where ResultID='" + ResultID + "'", null); while (dataReader.Read()) { entity = new Entity.AnalysisResult(); entity.ResultID = DataHelper.ParseToInt(dataReader["ResultID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.Result = decimal.Parse(dataReader["Result"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
public static int UpdateAnalysisResult(Entity.AnalysisResult 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("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ResultID.GetType().ToString()), entity.ResultID, 32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()), entity.BillNumber, 20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Result.GetType().ToString()), entity.Result, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="BillNumber"> </param> /// <returns></returns> public static List <Entity.AnalysisResult> GetAnalysisResultEx(string BillNumber) { List <Entity.AnalysisResult> list = new List <Entity.AnalysisResult>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vAnalysisResult] where BillNumber='" + BillNumber + "'", null); while (dataReader.Read()) { Entity.AnalysisResult entity = new Entity.AnalysisResult(); entity.ResultID = DataHelper.ParseToInt(dataReader["ResultID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.ItemName = dataReader["ItemName"].ToString(); entity.Result = decimal.Parse(dataReader["Result"].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 { int iReturn = 0; try { Entity.Analysis entity = new Entity.Analysis(); entity.BillNumber = txt_BillNumber.Text.Trim(); 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 = Date.SelectedDate; entity.AnalysisManID = int.Parse(hf_AnalysisID.Text.Trim()); entity.Status = 1; if (string.IsNullOrEmpty(sGuid)) { //Add //List<Entity.AnalysisResult> results = new List<Entity.AnalysisResult>(); //foreach (GridRow gr in Grid1.Rows) //{ // Entity.AnalysisResult result = new Entity.AnalysisResult(); // result.ItemCode = DAL.AnalysisItem.GetItemCodeByName(gr.DataKeys[2].ToString()); // result.Result = decimal.Parse(gr.DataKeys[3].ToString()); // results.Add(result); //} List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); List <Entity.AnalysisResult> Adds = new List <Entity.AnalysisResult>(); for (int i = 0; i < newAddedList.Count; i++) { Entity.AnalysisResult add = new Entity.AnalysisResult(); add.Result = decimal.Parse(newAddedList[i]["Result"].ToString()); add.ItemCode = DAL.AnalysisItem.GetItemCodeByName(newAddedList[i]["ItemName"].ToString()); Adds.Add(add); } iReturn = DAL.Analysis.AddAnalysisEntity(entity, Adds); //iReturn = DAL.Analysis.AddAnalysisEntity(entity, results); } else { //Update entity.AnalysisID = int.Parse(sGuid); List <int> deletedRows = Grid1.GetDeletedList(); List <Entity.AnalysisResult> Deletes = new List <Entity.AnalysisResult>(); foreach (int rowIndex in deletedRows) { Entity.AnalysisResult delete = new Entity.AnalysisResult(); delete.ResultID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); Deletes.Add(delete); } Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); List <Entity.AnalysisResult> Updates = new List <Entity.AnalysisResult>(); foreach (int rowIndex in modifiedDict.Keys) { Entity.AnalysisResult update = new Entity.AnalysisResult(); update.ResultID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); update.ItemCode = DAL.AnalysisItem.GetItemCodeByName(Grid1.DataKeys[rowIndex][1].ToString()); update.Result = decimal.Parse(Grid1.DataKeys[rowIndex][2].ToString()); Updates.Add(update); } List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); List <Entity.AnalysisResult> Adds = new List <Entity.AnalysisResult>(); for (int i = 0; i < newAddedList.Count; i++) { Entity.AnalysisResult add = new Entity.AnalysisResult(); add.Result = decimal.Parse(newAddedList[i]["Result"].ToString()); add.ItemCode = DAL.AnalysisItem.GetItemCodeByName(newAddedList[i]["ItemName"].ToString()); Adds.Add(add); } iReturn = DAL.Analysis.UpdateAnalysisEntity(entity, Adds, Deletes, Updates); } } catch (Exception ex) { } finally { } if (iReturn == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } #endregion }