public List <FormObject> GetFormObjectsByUser(User user)
{
List <FormObject> elements = new List <FormObject>();
string sql = "select * from TF_FormObject where Owner=" + user.ID;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FormTypeLogic ftl = FormTypeLogic.GetInstance();
FormItemLogic fil = FormItemLogic.GetInstance();
UserLogic ul = UserLogic.GetInstance();
for (int i = 0; i < dt.Rows.Count; i++)
{
FormObject element = new FormObject();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.FormName = dt.Rows[i]["FormName"].ToString();
element.FormType = ftl.GetFormType(Convert.ToInt32(dt.Rows[i]["FormType"]));
element.FormItems = fil.GetFormItemsByIds(dt.Rows[i]["FormItems"].ToString());
element.Owner = ul.GetUser(Convert.ToInt32(dt.Rows[i]["Owner"]));
element.Remark = dt.Rows[i]["Remark"].ToString();
elements.Add(element);
}
}
return(elements);
}
public static FormTypeLogic GetInstance()
{
if (instance == null)
{
instance = new FormTypeLogic();
}
return(instance);
}
private void LoadFormTypes()
{
comboBox1.Items.Clear();
List <FormType> types = FormTypeLogic.GetInstance().GetAllFormTypes();
foreach (FormType type in types)
{
comboBox1.Items.Add(type);
}
}
private void LoadFormTypes()
{
List <FormType> elements = FormTypeLogic.GetInstance().GetAllFormTypes();
comboBox1.Items.Clear();
foreach (FormType element in elements)
{
comboBox1.Items.Add(element);
}
dataGridView1.DataSource = FormTypeLogic.GetInstance().GetFormTypes(string.Empty);
}
private DataTable Search(string name)
{
string nm = "";
if (!string.IsNullOrEmpty(name) && name.Trim() != "")
{
nm = " and TypeName like '%" + name + "%'";
}
string where = "(1=1)" + nm;
return(FormTypeLogic.GetInstance().GetFormTypes(where));
}
private void LoadFormTypes()
{
List <FormType> elements = FormTypeLogic.GetInstance().GetAllFormTypes();
comboBox2.Items.Clear();
comboBox2.Items.Add("--不限--");
foreach (FormType element in elements)
{
comboBox2.Items.Add(element);
}
comboBox2.SelectedIndex = 0;
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
FormType formType = (FormType)comboBox1.SelectedItem;
formType.TypeName = textBox1.Text.Trim();
formType.Remark = textBox2.Text;
FormTypeLogic al = FormTypeLogic.GetInstance();
if (al.ExistsNameOther(formType.TypeName, formType.ID))
{
if (MessageBox.Show("系统中已经存在该表单类型，确定还要继续保存么？", "重名提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
if (al.UpdateFormType(formType, this.User))
{
LoadFormTypes();
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("修改失败或者您不是管理员！");
}
}
else
{
textBox1.Focus();
textBox1.SelectAll();
}
}
else
{
if (al.UpdateFormType(formType, this.User))
{
LoadFormTypes();
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("修改失败或者您不是管理员！");
}
}
}
else
{
MessageBox.Show("先选定要修改的表单类型！");
}
}
public FormObject GetFormObject(int id)
{
string sql = "select * from TF_FormObject where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FormObject element = new FormObject();
element.ID = id;
element.FormName = dt.Rows[0]["FormName"].ToString();
element.FormType = FormTypeLogic.GetInstance().GetFormType(Convert.ToInt32(dt.Rows[0]["FormType"]));
element.FormItems = FormItemLogic.GetInstance().GetFormItemsByIds(dt.Rows[0]["FormItems"].ToString());
element.Owner = UserLogic.GetInstance().GetUser(Convert.ToInt32(dt.Rows[0]["Owner"]));
element.Remark = dt.Rows[0]["Remark"].ToString();
return(element);
}
return(null);
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
if (MessageBox.Show("确定要删除该表单类型？", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
FormType formType = (FormType)comboBox1.SelectedItem;
if (FormTypeLogic.GetInstance().DeleteFormType(formType, this.User))
{
LoadFormTypes();
}
else
{
MessageBox.Show("删除失败或者您不是管理员！");
}
}
}
else
{
MessageBox.Show("先选定要删除的表单类型！");
}
}
private void button1_Click(object sender, EventArgs e)
{
FormType formType = new FormType();
formType.TypeName = textBox1.Text.Trim();
formType.Remark = textBox2.Text;
FormTypeLogic al = FormTypeLogic.GetInstance();
if (al.ExistsName(formType.TypeName))
{
if (MessageBox.Show("系统中已经存在该表单类型，确定还要继续保存么？", "重名提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
int id = al.AddFormType(formType);
if (id > 0)
{
formType.ID = id;
LoadFormTypes();
MessageBox.Show("添加成功！");
}
}
else
{
textBox1.Focus();
textBox1.SelectAll();
}
}
else
{
int id = al.AddFormType(formType);
if (id > 0)
{
formType.ID = id;
LoadFormTypes();
MessageBox.Show("添加成功！");
}
}
}
