/// <summary>
/// 获取一条Asses类信息
/// </summary>
/// <param name="AssesID">登录编号</param>
/// <returns>一条Asses类记录</returns>
public Asses GetAsses(string AssesID)
{
Asses asses = new Asses();
GuideMgr gMgr = new GuideMgr();
Guide2Mgr g2Mgr = new Guide2Mgr();
PersonMgr pMgr = new PersonMgr();
string strSQL = "SELECT Top 1 * FROM Sys_Asses WHERE AssesID = " + AssesID;
DataTable dt = CMMgr.GetDataTable(strSQL);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
asses.AssesID = int.Parse(row["AssesID"].ToString());
asses.Person = pMgr.GetPerson(row["PersonID"].ToString());
asses.Guide = gMgr.GetGuide(row["GuideID"].ToString());
asses.Guide2 = g2Mgr.GetGuide2(row["Guide2ID"].ToString());
asses.Scale1 = int.Parse(row["Scale1"].ToString());
asses.Scale2 = int.Parse(row["Scale2"].ToString());
asses.Scale3 = int.Parse(row["Scale3"].ToString());
asses.Scale1Name = row["Scale1Name"].ToString();
asses.Scale2Name = row["Scale2Name"].ToString();
asses.Scale3Name = row["Scale3Name"].ToString();
asses.CountNumber = int.Parse(row["CountNumber"].ToString());
asses.Memo = row["Memo"].ToString();
return(asses);
}
else
{
return(asses);
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
AssesMgr sMgr = new AssesMgr();
Asses asses = new Asses();
GuideMgr gMgr = new GuideMgr();
if (this.hidAssesID.Value != "")
{
asses = sMgr.GetAsses(this.hidAssesID.Value);
}
asses.Person.PersonID = this.lstPersonID.SelectedValue;
asses.Guide.GuideID = int.Parse(this.lstGuideID.SelectedValue);
asses.Guide2.Guide2ID = int.Parse(this.lstGuide2ID.SelectedValue);
asses.Scale1 = int.Parse(this.txtScale1.Text.Trim());
asses.Scale1Name = this.txtScale1Name.Text.Trim();
asses.Memo = this.txtMemo.Text;
sMgr.UpdateAsses(asses);
this.SendMessage("信息编辑成功");
if (this.hidAssesID.Value == "")
{
this.ClearTextData(this);
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
AddNumberMgr sMgr = new AddNumberMgr();
AddNumber addNumber = sMgr.GetAddNumber(this.hidAddNumberID.Value);
int AddInt = 0;
if (this.chkIsAudi.Checked)
{
if (this.txtAddInt.Text.Trim() == "")
{
this.SendMessage("通过审核必须填写增加的分数");
}
else if (!int.TryParse(this.txtAddInt.Text.Trim(), out AddInt))
{
this.SendMessage("增加的分数必须为一个整数");
}
else
{
addNumber.IsAudi = "是";
addNumber.AddInt = AddInt;
sMgr.UpdateAddNumber(addNumber);
AssesMgr mgr = new AssesMgr();
Asses asses = new Asses();
asses.Guide.GuideID = addNumber.Guide.GuideID;
switch (asses.Guide.GuideID)
{
case 1:
asses.Guide2.Guide2ID = 4;
break;
case 2:
asses.Guide2.Guide2ID = 9;
break;
case 3:
asses.Guide2.Guide2ID = 14;
break;
}
asses.Memo = "";
asses.Person.PersonID = addNumber.Person.PersonID;
asses.Scale1 = addNumber.AddInt;
mgr.UpdateAsses(asses);
this.btnOK.Enabled = false;
}
}
else
{
addNumber.IsAudi = "否";
addNumber.AddInt = 0;
sMgr.UpdateAddNumber(addNumber);
}
this.SendMessage("信息编辑成功");
}
public void Collect(AssemblyDefinition ass)
{
if (Asses.Contains(ass))
{
return;
}
Asses.Add(ass);
foreach (var mod in ass.Modules)
{
Collect(mod);
}
}
/// <summary>
/// 初始化窗体信息
/// </summary>
private void initForm()
{
if (this.hidAssesID.Value != "")
{
this.lstPersonID.Enabled = false;
AssesMgr aMgr = new AssesMgr();
Asses asses = aMgr.GetAsses(this.hidAssesID.Value);
if (asses.AssesID != 0)
{
this.lstPersonID.ClearSelection();
if (this.lstPersonID.Items.FindByValue(asses.Person.PersonID) != null)
{
this.lstPersonID.Items.FindByValue(asses.Person.PersonID).Selected = true;
}
this.lstGuideID.ClearSelection();
if (this.lstGuideID.Items.FindByValue(asses.Guide.GuideID.ToString()) != null)
{
this.lstGuideID.Items.FindByValue(asses.Guide.GuideID.ToString()).Selected = true;
}
this.initGuide2();
this.lstGuide2ID.ClearSelection();
if (this.lstGuide2ID.Items.FindByValue(asses.Guide2.Guide2ID.ToString()) != null)
{
this.lstGuide2ID.Items.FindByValue(asses.Guide2.Guide2ID.ToString()).Selected = true;
}
this.txtScale1.Text = asses.Scale1.ToString();
this.txtScale1Name.Text = asses.Scale1Name;
this.txtMemo.Text = asses.Memo;
}
else
{
this.btnOK.Enabled = false;
this.SendMessage("没有找到该信息");
}
}
}
/// <summary>
/// 更新Asses类信息
/// </summary>
/// <param name="asses">评定指标管理类参数</param>
/// <returns>更新成功返回true 否则返回false</returns>
public bool UpdateAsses(Asses asses)
{
string strSQL = "";
SqlDataAdapter sa = null;
SqlCommandBuilder builder = null;
DataRow row = null;
DataTable dt = null;
bool returnValue = false;
if (asses != null)
{
if (asses.AssesID == 0)
{
strSQL = "SELECT Top 0 * FROM Sys_Asses";
}
else
{
strSQL = "SELECT Top 1 * FROM Sys_Asses WHERE AssesID = " + asses.AssesID.ToString();
}
dt = CMMgr.GetDataTable(strSQL);
if (dt.Rows.Count > 0)
{
row = dt.Rows[0];
}
else
{
row = dt.NewRow();
}
row["PersonID"] = asses.Person.PersonID;
row["GuideID"] = asses.Guide.GuideID;
row["Guide2ID"] = asses.Guide2.Guide2ID;
row["Scale1"] = asses.Scale1;
row["Scale2"] = asses.Scale2;
row["Scale3"] = asses.Scale3;
row["Scale1Name"] = asses.Scale1Name;
row["Scale2Name"] = asses.Scale2Name;
row["Scale3Name"] = asses.Scale3Name;
row["CountNumber"] = asses.CountNumber;
row["Memo"] = asses.Memo;
if (dt.Rows.Count == 0)
{
dt.Rows.Add(row);
}
SqlConnection conn = CMMgr.GetConnection();
using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Asses", conn))
{
try
{
builder = new SqlCommandBuilder(sa);
sa.Update(dt);
returnValue = true;
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
return(returnValue);
}
