//确定
private void btnOK_Click(object sender, EventArgs e)
{
try
{
string tname = this.txtTemplateName.Text.Trim();
if (tname != "")
{
string sql = "update t_follow_tempplate set tname='" + tname + "' where tid='" + current_id + "'";
int num = App.ExecuteSQL(sql);
if (num > 0)
{
App.Msg("更新成功！");
//对模板界面设置
ucFollowTemplateManagement temp = (ucFollowTemplateManagement)templateManage;
temp.trvModel.SelectedNode.Text = tname;
}
else
{
App.Msg("更新失败！");
}
this.Close();
}
else
{
App.Msg("模板名称不能为空！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
TreeNode parentNode;
ucFollowTemplateManagement temp = (ucFollowTemplateManagement)templateManage;
parentNode = temp.trvModel.SelectedNode;
ArrayList Sqls = new ArrayList();
Sqls.Add("delete from t_follow_tempplate_section where TEMPLATE_ID=" + current_id + "");
for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
{
DataGridViewCheckBoxCell sc = dataGridViewX1["科室", i] as DataGridViewCheckBoxCell;
if (sc.Value != null)
{
if (sc.Value.ToString() == "true")
{
DataGridViewCheckBoxCell sc2 = dataGridViewX1["默认科室", i] as DataGridViewCheckBoxCell;
if (sc2.Value != null)
{
if (sc2.Value.ToString() == "true")
{
ucFollowTemplateManagement.isSecDefault = "true";
Sqls.Add("update t_follow_tempplate_section set ISDEFAULT='N' where template_id in (select tid from t_follow_tempplate where text_type=" + text_kind + " and tempplate_level='S') and section_id=" + dataGridViewX1["科室主键", i].Value.ToString() + "");
Sqls.Add("insert into t_follow_tempplate_section(TEMPLATE_ID,SECTION_ID,ISDEFAULT)values(" + current_id + "," + dataGridViewX1["科室主键", i].Value.ToString() + ",'Y')");
Sqls.Add("update t_follow_tempplate set TEMPPLATE_LEVEL='S', ISDEFAULT='Y' where TID=" + current_id + "");
}
else
{
Sqls.Add("insert into t_follow_tempplate_section(TEMPLATE_ID,SECTION_ID,ISDEFAULT)values(" + current_id + "," + dataGridViewX1["科室主键", i].Value.ToString() + ",'N')");
}
}
else
{
Sqls.Add("insert into t_follow_tempplate_section(TEMPLATE_ID,SECTION_ID,ISDEFAULT)values(" + current_id + "," + dataGridViewX1["科室主键", i].Value.ToString() + ",'N')");
}
}
}
}
if (ucFollowTemplateManagement.isSecDefault == "false")
{
Sqls.Add("update t_follow_tempplate set ISDEFAULT='N' where tid=" + current_id + "");
}
string[] strSqls = new string[Sqls.Count];
for (int i = 0; i < Sqls.Count; i++)
{
strSqls[i] = Sqls[i].ToString();
}
if (App.ExecuteBatch(strSqls) > 0)
{
ucFollowTemplateManagement.Temp_Sections = App.GetDataSet("select * from T_FOLLOW_TEMPPLATE_SECTION");
App.Msg("设置成功!");
}
this.Close();
}
