/// <summary> /// [ISingleGridPage]删除表格数据 /// </summary> public void DeleteSelectedRows() { int selectedCount = Grid1.SelectedRowIndexArray.Length; if (selectedCount == 0) { Alert.ShowInTop("请至少选择一项纪录!", MessageBoxIcon.Warning); return; } object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex]; Entity.Analysis entity = DAL.Analysis.GetAnalysisByID(int.Parse(HttpUtility.UrlEncode(keys[0].ToString()))); if (entity.Status == 2) { Alert.ShowInTop("审核通过的不能删除!", MessageBoxIcon.Information); return; } else { string BillNumber = entity.BillNumber; int BSuccess = DAL.Analysis.DeleteAnalysis(int.Parse(HttpUtility.UrlEncode(keys[0].ToString())), BillNumber); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } } }
public static int UpdateAnalysisStatus(Entity.Analysis 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("@AnalysisID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisID.GetType().ToString()),entity.AnalysisID,32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()),entity.Status,32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Analysis_UpdateStatus", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return iReturn; }
public static int PassAnalysis(Entity.Analysis entity,int StorageID) { 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("@AnalysisID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisID.GetType().ToString()),entity.AnalysisID,32), // dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()),entity.Status,32) //}; //iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Analysis_UpdateStatus", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Analysis] set Status='" + entity.Status + "',UpdateDate='" + entity.UpdateDate + "',UpdateUser='******'where AnalysisID='" + entity.AnalysisID + "'", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [WasteStorage] set Status='4' where StorageID='" + StorageID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return iReturn; }
/// <summary> /// /// </summary> /// <param name="AnalysisID"> </param> /// <returns></returns> public static Entity.Analysis GetAnalysisByID(int AnalysisID) { Entity.Analysis entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vAnalysis] where AnalysisID='" + AnalysisID + "'", null); while (dataReader.Read()) { entity = new Entity.Analysis(); entity.AnalysisID = DataHelper.ParseToInt(dataReader["AnalysisID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.AnalysisManID = DataHelper.ParseToInt(dataReader["AnalysisManID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return entity; }
public static int AddAnalysisEntity(Entity.Analysis entity,List<Entity.AnalysisResult> results) { 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("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()),entity.BillNumber,20), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()),entity.DateTime,0), dbFactory.MakeInParam("@AnalysisManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisManID.GetType().ToString()),entity.AnalysisManID,32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()),entity.Status,32), dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()),entity.CreateDate,0), dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()),entity.CreateUser,50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()),entity.UpdateDate,0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()),entity.UpdateUser,50), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Analysis_Add", prams); iReturn = int.Parse(prams[8].Value.ToString()); int AnalysisID = int.Parse(prams[8].Value.ToString()); foreach (Entity.AnalysisResult result in results) { IDbDataParameter[] pramse = { dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()),entity.BillNumber,20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(result.ItemCode.GetType().ToString()),result.ItemCode,20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(result.Result.GetType().ToString()),result.Result,10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Add", pramse); } thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return iReturn; }
protected void btn_Pass_Click(object sender, EventArgs e) { int selectedCount = Grid1.SelectedRowIndexArray.Length; if (selectedCount == 0) { Alert.ShowInTop("请至少选择一项纪录!", MessageBoxIcon.Warning); return; } object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex]; int AnalysisID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); Entity.Analysis entity = DAL.Analysis.GetAnalysisByID(AnalysisID); if (entity.Status == 2) { Alert.ShowInTop("该记录已经审核通过了!", MessageBoxIcon.Warning); return; } entity.Status = 2; entity.UpdateDate = DateTime.Now; entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); //entity.CreateDate = DateTime.Now; //entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); int StorageID = DAL.WasteStorage.GetWasteStorageIDByBillNumber(entity.BillNumber); int BSuccess = DAL.Analysis.PassAnalysis(entity, StorageID); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } }
private void LoadData(string thisGuid) { if (thisGuid != string.Empty) { //BindGrid(); Entity.Analysis entity = DAL.Analysis.GetAnalysisByID(int.Parse(sGuid)); txt_BillNumber.Text = entity.BillNumber; txt_Analysis.Text = entity.RealName; hf_AnalysisID.Text = entity.AnalysisManID.ToString(); if (!string.IsNullOrEmpty(entity.DateTime.ToString())) { Date.SelectedDate = entity.DateTime; } //BindGrid(); if (entity.Status == 2) { txt_BillNumber.Readonly = true; txt_Analysis.Readonly = true; Date.Readonly = true; Grid1.Enabled = false; btn_save.Enabled = false; } } }
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 }
public static int UpdateAnalysisEntity(Entity.Analysis entity, List<Entity.AnalysisResult> Adds,List<Entity.AnalysisResult> Deletes,List<Entity.AnalysisResult> Updates) { 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("@AnalysisID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisID.GetType().ToString()),entity.AnalysisID,32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()),entity.BillNumber,20), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()),entity.DateTime,0), dbFactory.MakeInParam("@AnalysisManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisManID.GetType().ToString()),entity.AnalysisManID,32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()),entity.Status,32), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()),entity.UpdateDate,0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()),entity.UpdateUser,50) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Analysis_Update", prams); foreach (Entity.AnalysisResult add in Adds) { IDbDataParameter[] pramse = { dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()),entity.BillNumber,20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(add.ItemCode.GetType().ToString()),add.ItemCode,20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(add.Result.GetType().ToString()),add.Result,10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Add", pramse); } foreach (Entity.AnalysisResult update in Updates) { IDbDataParameter[] pramsq = { dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(update.ResultID.GetType().ToString()),update.ResultID,32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()),entity.BillNumber,20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(update.ItemCode.GetType().ToString()),update.ItemCode,20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(update.Result.GetType().ToString()),update.Result,10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Update", pramsq); } foreach (Entity.AnalysisResult delete in Deletes) { //IDbDataParameter[] pramsw = { //dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(delete.ResultID.GetType().ToString()),delete.ResultID,32) //}; //iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Delete", pramsw); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Delete from [AnalysisResult] where ResultID='" + delete.ResultID + "'", null); } thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return iReturn; }