/// <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);
}
}
