public void getList_Solutions(Int64 SolutionID=0)
{
try
{
this.dvgSolutions.AutoGenerateColumns = false;
DataTable myDataTable_Solutions = new DataTable();// = new JobStatusHeadDAL().getList(1000, 1, "Id", "asc");
if (SolutionID == 0)
{
myDataTable_Solutions = new SolutionsDAL().getList(1000, 1, "ID", "asc");
}
else
{
myDataTable_Solutions = new SolutionsDAL().getInfo(SolutionID);
}
this.Solutions_bindingSource.DataSource = myDataTable_Solutions;
//this.bnMain.BindingSource = this.Solutions_bindingSource;
this.dvgSolutions.DataSource = null;
this.txtSolutionID.DataBindings.Clear();
this.txtSolutionID.DataBindings.Add("Text", this.Solutions_bindingSource, "ID", false, DataSourceUpdateMode.Never, "new");
this.dvgSolutions.DataSource = this.Solutions_bindingSource;
this.dvgSolutions.Columns["clmSolutionName"].DataPropertyName = "SolutionName";
this.dvgSolutions.Refresh();
this.dvgSolutions.Update();
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions");
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
lblResult.Visible = false;
// 查询解决方案
string typeCode = txtTypeNo.Text;
if (typeCode.Length >= 10)
{
typeCode = typeCode.Substring(0, 10);
}
lblTitle.Text = "解决方案： " + typeCode;
string content = SolutionsDAL.GetSolutionByID(typeCode);
content = content.Replace("\n", "");
this.result.Visible = true;
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "setContent", "setEditor('" + content + "');", true);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string typeCode = lblTitle.Text.Substring(6);
string content = Convert.ToString(Request.Form["ctl00$myContent$hid"]);
// 后期加入 操作写入log
if (SolutionsDAL.UpdateSolution(typeCode, content) != 0)
{
lblResult.Text = "修改成功！";
lblResult.CssClass = "ok";
}
else
{
lblResult.Text = "修改失败！";
lblResult.CssClass = "fail";
}
this.result.Visible = false;
lblResult.Visible = true;
}
void getList_Solutions()
{
try
{
DataTable myDataTable_Solutions = new DataTable();// = new JobStatusHeadDAL().getList(1000, 1, "Id", "asc");
myDataTable_Solutions = new SolutionsDAL().getList(1000, 1, "ID", "asc");
this.Solutions_bindingSource.DataSource = myDataTable_Solutions;
//this.bnMain.BindingSource = this.Solutions_bindingSource;
this.cmbSolutions.DataSource = null;
this.cmbSolutions.DataSource = this.Solutions_bindingSource;
this.cmbSolutions.DisplayMember = "SolutionName";
this.cmbSolutions.ValueMember = "ID";
this.cmbSolutions.Refresh();
this.cmbSolutions.Update();
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions");
}
}
void ViewAll_Solutions(Boolean isSearch = false, string SearchText = "")
{
try
{
DataTable myDataTable_JobStatusHead = new DataTable();// = new JobStatusHeadDAL().getList(1000, 1, "Id", "asc");
if (isSearch == true)
{
myDataTable_JobStatusHead = new SolutionsDAL().getList_Search(1000, 1, " (SolutionName like '" + SearchText + "%' or Methodology like '" + SearchText + "%')", "ID", "asc");
}
else
{
myDataTable_JobStatusHead = new SolutionsDAL().getList(1000, 1, "ID", "asc");
}
this.Solutions_bindingSource.DataSource = myDataTable_JobStatusHead;
this.bnMain.BindingSource = this.Solutions_bindingSource;
if (this.isMapped_Solutions == false)
{
this.Binding_Solutions();
this.isMapped_Solutions = true;
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions");
}
}
void Update_Solutions()
{
try
{
SolutionsDAL = new SolutionsDAL();
clsActionStatus = new clsActionStatus();
SolutionsDAL.ID = this.txtID.Text == CommonVariables.New_IntialValue ? 0 : int.Parse(this.txtID.Text);
SolutionsDAL.SolutionName = this.txtSolutionName.Text;
SolutionsDAL.SNameSpace = this.txtSNameSpace.Text;
SolutionsDAL.SDescription = this.txtSDescription.Text;
SolutionsDAL.Methodology = this.cmbMethodology.SelectedValue.ToString();
SolutionsDAL.UserId = CommonClasses.Security.UserID;
SolutionsDAL.isActive = this.cbkisActive.Checked;
if (isNew_Solutions== false && isNew_Solutions == false)
{
Messages.Edit_New_error("Solution");
return;
}
if (SolutionsDAL.ID > 0)
{
clsActionStatus = SolutionsDAL.Update();
}
else
{
clsActionStatus = SolutionsDAL.Insert();
}
if (clsActionStatus.is_Error == false)
{
isNew_Solutions = isEdit_Solutions = false;
Messages.SuccessMessage(clsActionStatus.Action_SuccessStatus, "Solutions");
this.txtID.Text = clsActionStatus.Return_Id;
this.Solutions_bindingSource.EndEdit();
if (SolutionsDAL.ID <= 0)
{
if (Messages.myAddMore("Solutions") == System.Windows.Forms.DialogResult.Yes)
{
this.txtID.Focus();
this.New_Solutions ();
}
}
}
else
{
Messages.GeneralError(clsActionStatus.Action_FailureStatus, "Solutions");
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions");
}
}
void Delete_Solutions()
{
try
{
if (Messages.myDeleteMsgBox("Job Status", this.txtSolutionName.Text) == System.Windows.Forms.DialogResult.Yes)
{
SolutionsDAL = new SolutionsDAL();
clsActionStatus = new clsActionStatus();
SolutionsDAL.ID = int.Parse(this.txtID.Text);
clsActionStatus = SolutionsDAL.Delete();
if (clsActionStatus.is_Error == false)
{
isNew_Solutions = false;
isEdit_Solutions = false;
Messages.DeletionMessage(clsActionStatus.Action_SuccessStatus, "Solutions");
this.Solutions_bindingSource.RemoveCurrent();
}
else
{
Messages.DeletionMessage(clsActionStatus.Action_FailureStatus, "Solutions");
}
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions");
}
}
