public bool DeleteByStatus(DataGrid DGrid, string DataTable, string DataFieldText, string CheckBoxID, string InputID, string SessionID) { try { System.Web.UI.WebControls.CheckBox chkExport; string sID = ""; bool result = false; foreach (DataGridItem oDataGridItem in DGrid.Items) { chkExport = (CheckBox)oDataGridItem.FindControl(CheckBoxID); if (chkExport.Checked) { sql = GetInfomationSql.DeleteBStatusSql(DataTable, DataFieldText, ((HtmlInputHidden)oDataGridItem.FindControl(InputID)).Value); db.executeDelete(sql); sID = ((HtmlInputHidden)oDataGridItem.FindControl(InputID)).Value; sID += sID; result = true; } } if (sID.Length < 1) { result = false; } return(result); } catch (Exception Err) { ErrorLog.LogInsert(Err.Message, "CS/GetInformation", SessionID); return(false); } }
/// <summary> /// 获取总数 /// </summary> /// <param name="DataTable"></param> /// <param name="MaxFieldText"></param> /// <param name="FieldText"></param> /// <param name="FieldValue"></param> /// <returns></returns> public int GetIntCount(string DataTable, string FieldText, string FieldValue, string StrCondition, string SessionID) { try { sql = GetInfomationSql.GetIntCountSql(DataTable, FieldText, FieldValue, StrCondition); StrCount = db.GetDataScalar(sql); return(Convert.ToInt32(StrCount)); } catch (Exception Err) { ErrorLog.LogInsert(Err.Message, "CS/GetInformation", SessionID); return(0); } }
/// <summary> /// 获取最大值序号 /// </summary> /// <param name="DataTable"></param> /// <param name="MaxFieldText"></param> /// <param name="FieldText"></param> /// <param name="FieldValue"></param> /// <returns></returns> public string GetMaxValue(string DataTable, string MaxFieldText, string FieldText, string FieldValue) { try { sql = GetInfomationSql.GetMaxValueSql(DataTable, MaxFieldText, FieldText, FieldValue); string StrMaxValue = db.GetDataScalar(sql).ToString(); if (StrMaxValue == null || StrMaxValue == "") { StrMaxValue = "-1"; } return(StrMaxValue); } catch (Exception Err) { //ErrorLog.LogInsert(Err.Message, "CS/GetInformation", StaffID); return(""); } }