/// <summary> /// 根据选中CheckBox来删除记录,获取true/false /// </summary> /// <param name="DGrid"></param> /// <param name="DataTable"></param> /// <param name="DataFieldText"></param> /// <param name="CheckBoxID"></param> /// <param name="InputID"></param> public bool DeleteBCheckBox(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.DeleteBCheckBoxSql(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="sender"></param> /// <param name="e"></param> protected void btnDelete_Click(object sender, EventArgs e) { ArrayList list = GetSelectedKeyValues(); //循环删除数据 if (list != null) { string sql = "DELETE FROM SExmQuestion WHERE Question_Guid in ("; string strIndex = ""; for (int i = 0; i < list.Count; i++) { strIndex += "'" + list[i].ToString() + "',"; } sql = sql + strIndex.TrimEnd(',') + ")"; //数据操作 try { db = new MDataBase(config.DBConn); db.executeDelete(sql); Response.Write("<script type='text/javascript'>alert('删除成功!');window.location.href=window.location.href;</script>"); } catch (Exception exc) { throw exc; } finally { Response.Write("<script type='text/javascript'>alert('删除失败!');window.location.href=window.location.href;</script>"); } } }
protected void btnDelete_Click(object sender, EventArgs e) { ArrayList list = GetSelectedKeyValues(out isDelete); //循环删除数据 if (list.Count != 0) { string sql = "UPDATE SSysStaff SET StatusId=-1 WHERE Staff_Id in ("; string strIndex = ""; for (int i = 0; i < list.Count; i++) { strIndex += "'" + list[i].ToString() + "',"; } sql = sql + strIndex.TrimEnd(',') + ")"; try { db = new MDataBase(ConfigurationManager.ConnectionStrings["OA"].ToString()); db.executeDelete(sql); Response.Write("<script type='text/javascript'>alert('删除成功!');window.location.href=window.location.href;</script>"); } catch (Exception exc) { } finally { Response.Write("<script type='text/javascript'>alert('删除失败!');window.location.href=window.location.href;</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请选择要删除的部门!');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { //得到要插入的新的角色编号 string strId = Guid.NewGuid().ToString().Substring(0, 8); string supId = cblFunctionSelect.SelectedValue; string name = txtRoleName.Text; string comment = txtRoleNote.Text; if (name == "") { //当没有输入角色名称时,弹出警告窗口 Response.Write("<script type='text/javascript'>alert('请输入角色名称!')</script>"); } else { db = new MDataBase(config.DBConn); //向数据库中插入新角色 if (hfIsUpdate.Value == "Insert") { //向数据库中插入新角色 string strRoleSql = "INSERT INTO SSysRole (Role_Id,Project_Id, Name, CreatedDate, StatusId) values('" + strId + "','" + config.ProjectId + "','" + name + "','" + DateTime.Now + "','0')"; db.executeInsert(strRoleSql); //向数据库中插入角色功能关系 for (int i = 0; i < cblFunctionSelect.Items.Count; i++) { if (cblFunctionSelect.Items[i].Selected) { string strRoleFuncSql = "Insert Into SSysRoleFunction values('" + strId + "','" + cblFunctionSelect.Items[i].Value + "')"; db.executeInsert(strRoleFuncSql); } } } else { //更新角色数据 string sqlUpdate = "UPDATE SSysRole SET Project_Id='" + config.ProjectId + "',Name='" + name + "',ModifiedDate='" + DateTime.Now + "' WHERE Role_Id='" + hfIsUpdate.Value + "'"; db.executeUpdate(sqlUpdate); //先删除相关角色功能关系 string sqlDelete = "Delete from SSysRoleFunction Where Role_Id='" + hfIsUpdate.Value + "'"; db.executeDelete(sqlDelete); //向数据库中插入角色功能关系 for (int i = 0; i < cblFunctionSelect.Items.Count; i++) { if (cblFunctionSelect.Items[i].Selected) { string strRoleFuncSql = "Insert Into SSysRoleFunction values('" + hfIsUpdate.Value + "','" + cblFunctionSelect.Items[i].Value + "')"; db.executeInsert(strRoleFuncSql); } } Response.Write("<script>window.dialogArguments.reload();</script>"); } } }
protected void btnDelete_Click(object sender, EventArgs e) { db = new MDataBase(config.DBConn); ArrayList list = GetSelectedKeyValues(out isDelete); //判断能否删除 if (isDelete) { //删除选中的部门 if (list.Count != 0) { string sql = "UPDATE SpsnWorkTime SET StatusId=-1 WHERE WorkTime_Guid in ('"; string strIndex = ""; for (int i = 0; i < list.Count; i++) { if (Convert.ToDateTime(list[i + 1]) > DateTime.Now) { strIndex += list[i].ToString() + "','"; } else { Response.Write("<script type='text/javascript'>alert('不能删除已过时的日程,删除失败!');window.location.href=window.location.href;</script>"); } i++; } sql = sql + strIndex.Trim('\'').TrimEnd(',') + ")"; try { db = new MDataBase(config.DBConn); db.executeDelete(sql); Response.Write("<script type='text/javascript'>alert('删除成功!');window.location.href=window.location.href;</script>"); BindData(""); } catch (Exception exc) { } finally { Response.Write("<script type='text/javascript'>alert('删除失败!');window.location.href=window.location.href;</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请选择要删除的工作日程!');</script>"); } } else { Response.Write("<script type='text/javascript'>alert('无法删除!');</script>"); } }
/// <summary> /// SC_QuestionType对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SC_QuestionType where "; // (QuestionType_Id)字段 if (_blnQuestionType_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "QuestionType_Id = '" + _QuestionType_Id + "'"; } // (QuestionTypeName)字段 if (_blnQuestionTypeNameChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "QuestionTypeName = '" + _QuestionTypeName + "'"; } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// 角色删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelete_Click(object sender, EventArgs e) { ArrayList list = GetSelectedKeyValues(out isDelete); //循环删除数据 if (list.Count != 0) { //将角色表中的对应记录,标记为不可用 string sql = "UPDATE SSysRole SET StatusId=-1 WHERE Role_Id in ("; //将与该Role_Id对应的SSysRoleFunction表中的记录删除 string sqlDelete = "Delete from SSysRoleFunction Where Role_Id in("; string strIndex = ""; for (int i = 0; i < list.Count; i++) { strIndex += "'" + list[i].ToString() + "',"; } sql = sql + strIndex.TrimEnd(',') + ")"; sqlDelete = sqlDelete + strIndex.TrimEnd(',') + ")"; try { db = new MDataBase(config.DBConn); db.executeUpdate(sql); db.executeDelete(sqlDelete); Response.Write("<script type='text/javascript'>alert('删除成功!');window.location.href=window.location.href;</script>"); } catch (Exception exc) { } finally { Response.Write("<script type='text/javascript'>window.location.href=window.location.href;</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请选择要删除的部门!');</script>"); } }
/// <summary> /// SExmExam对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SExmExam where "; // (Exam_Id)字段 if (_blnExam_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Exam_Id = '" + _Exam_Id + "'"; } // (ExamName)字段 if (_blnExamNameChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ExamName = '" + _ExamName + "'"; } // (ScoreType)字段 if (_blnScoreTypeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ScoreType = " + _ScoreType.ToString(); } // (BeginTime)字段 if (_blnBeginTimeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "BeginTime = '" + _BeginTime.ToString() + "'"; } // (EndTime)字段 if (_blnEndTimeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "EndTime = '" + _EndTime.ToString() + "'"; } // (Times)字段 if (_blnTimesChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Times = " + _Times.ToString(); } // (Count)字段 if (_blnCountChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Count = " + _Count.ToString(); } // (ExamEmploees)字段 if (_blnExamEmploeesChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ExamEmploees = " + _ExamEmploees.ToString(); } // (Average)字段 if (_blnAverageChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Average = " + _Average.ToString(); } // (CreatedBy)字段 if (_blnCreatedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedBy = '" + _CreatedBy + "'"; } // (CreatedDate)字段 if (_blnCreatedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedDate = '" + _CreatedDate.ToString() + "'"; } // (ModifiedBy)字段 if (_blnModifiedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedBy = '" + _ModifiedBy + "'"; } // (ModifiedDate)字段 if (_blnModifiedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedDate = '" + _ModifiedDate.ToString() + "'"; } // (StatusId)字段 if (_blnStatusIdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "StatusId = " + _StatusId.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// SPsnWorkTime对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SPsnWorkTime where "; // (WorkTime_Guid)字段 if (_blnWorkTime_GuidChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "WorkTime_Guid = '" + _WorkTime_Guid + "'"; } // (Staff_Id)字段 if (_blnStaff_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Staff_Id = '" + _Staff_Id + "'"; } // (Day)字段 if (_blnDayChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Day = '" + _Day.ToString() + "'"; } // (WorkStatusId)字段 if (_blnWorkStatusIdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "WorkStatusId = " + _WorkStatusId.ToString(); } // (Job)字段 if (_blnJobChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Job = '" + _Job + "'"; } // (Address)字段 if (_blnAddressChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Address = '" + _Address + "'"; } // (Remark)字段 if (_blnRemarkChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Remark = '" + _Remark + "'"; } // (CreatedBy)字段 if (_blnCreatedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedBy = '" + _CreatedBy + "'"; } // (CreatedDate)字段 if (_blnCreatedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedDate = '" + _CreatedDate.ToString() + "'"; } // (ModifiedBy)字段 if (_blnModifiedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedBy = '" + _ModifiedBy + "'"; } // (ModifiedDate)字段 if (_blnModifiedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedDate = '" + _ModifiedDate.ToString() + "'"; } // (StatusId)字段 if (_blnStatusIdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "StatusId = " + _StatusId.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// SSysRunParameter对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SSysRunParameter where "; // (Parameter_Guid)字段 if (_blnParameter_GuidChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Parameter_Guid = '" + _Parameter_Guid + "'"; } // (ParameterName)字段 if (_blnParameterNameChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ParameterName = '" + _ParameterName + "'"; } // (ParameterValue)字段 if (_blnParameterValueChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ParameterValue = '" + _ParameterValue + "'"; } // (Detail)字段 if (_blnDetailChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Detail = '" + _Detail + "'"; } // (IsUser)字段 if (_blnIsUserChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "IsUser = " + _IsUser.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// SExmScore对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SExmScore where "; // (Score_Guid)字段 if (_blnScore_GuidChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Score_Guid = '" + _Score_Guid + "'"; } // (Exam_Id)字段 if (_blnExam_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Exam_Id = '" + _Exam_Id + "'"; } // (Staff_Id)字段 if (_blnStaff_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Staff_Id = '" + _Staff_Id + "'"; } // (StartTime)字段 if (_blnStartTimeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "StartTime = '" + _StartTime.ToString() + "'"; } // (EndTime)字段 if (_blnEndTimeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "EndTime = '" + _EndTime.ToString() + "'"; } // (RightCount)字段 if (_blnRightCountChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "RightCount = " + _RightCount.ToString(); } // (WrongCount)字段 if (_blnWrongCountChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "WrongCount = " + _WrongCount.ToString(); } // (UnfinishCount)字段 if (_blnUnfinishCountChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "UnfinishCount = " + _UnfinishCount.ToString(); } // (Score)字段 if (_blnScoreChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Score = " + _Score.ToString(); } // (Gradation)字段 if (_blnGradationChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Gradation = " + _Gradation.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// SSysStaffProjectRole对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SSysStaffProjectRole where "; // (Staff_Id)字段 if (_blnStaff_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Staff_Id = '" + _Staff_Id + "'"; } // (Project_Id)字段 if (_blnProject_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Project_Id = '" + _Project_Id + "'"; } // (Role_Id)字段 if (_blnRole_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Role_Id = '" + _Role_Id + "'"; } // (IsDefault)字段 if (_blnIsDefaultChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "IsDefault = " + _IsDefault.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// SExmQuestion对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from SExmQuestion where "; // (Question_Guid)字段 if (_blnQuestion_GuidChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Question_Guid = '" + _Question_Guid + "'"; } // (QuestionType_Id)字段 if (_blnQuestionType_IdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "QuestionType_Id = '" + _QuestionType_Id + "'"; } // (Question)字段 if (_blnQuestionChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Question = '" + _Question + "'"; } // (AnswerA)字段 if (_blnAnswerAChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "AnswerA = '" + _AnswerA + "'"; } // (AnswerB)字段 if (_blnAnswerBChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "AnswerB = '" + _AnswerB + "'"; } // (AnswerC)字段 if (_blnAnswerCChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "AnswerC = '" + _AnswerC + "'"; } // (AnswerD)字段 if (_blnAnswerDChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "AnswerD = '" + _AnswerD + "'"; } // (AnswerE)字段 if (_blnAnswerEChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "AnswerE = '" + _AnswerE + "'"; } // (Answer)字段 if (_blnAnswerChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Answer = '" + _Answer + "'"; } // (Times)字段 if (_blnTimesChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Times = " + _Times.ToString(); } // (CreatedBy)字段 if (_blnCreatedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedBy = '" + _CreatedBy + "'"; } // (CreatedDate)字段 if (_blnCreatedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedDate = '" + _CreatedDate.ToString() + "'"; } // (ModifiedBy)字段 if (_blnModifiedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedBy = '" + _ModifiedBy + "'"; } // (ModifiedDate)字段 if (_blnModifiedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedDate = '" + _ModifiedDate.ToString() + "'"; } // (StatusId)字段 if (_blnStatusIdChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "StatusId = " + _StatusId.ToString(); } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }
/// <summary> /// CustomerSensitive对象Delete方法 /// </summary> private bool executeDelete() { bool blnFirstField = true; string sql = "delete from CustomerSensitive where "; // (SenCustomer_Guid)字段 if (_blnSenCustomer_GuidChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "SenCustomer_Guid = '" + _SenCustomer_Guid + "'"; } // (Mobile)字段 if (_blnMobileChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "Mobile = '" + _Mobile + "'"; } // (SenPeriod)字段 if (_blnSenPeriodChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "SenPeriod = " + _SenPeriod.ToString(); } // (SenEndTime)字段 if (_blnSenEndTimeChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "SenEndTime = '" + _SenEndTime.ToString() + "'"; } // (CreatedBy)字段 if (_blnCreatedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedBy = '" + _CreatedBy + "'"; } // (CreatedDate)字段 if (_blnCreatedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "CreatedDate = '" + _CreatedDate.ToString() + "'"; } // (ModifiedBy)字段 if (_blnModifiedByChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedBy = '" + _ModifiedBy + "'"; } // (ModifiedDate)字段 if (_blnModifiedDateChanged == true) { if (blnFirstField == true) { blnFirstField = false; } else { sql += " AND "; } sql += "ModifiedDate = '" + _ModifiedDate.ToString() + "'"; } try { MDataBase db = new MDataBase(_DBConn); db.executeDelete(sql); return(true); } catch (Exception err) { throw; return(false); } }