private void ShowFrmProfile(Framework.Entity.Model model, System.Reflection.Assembly ass)
{
FrmInsertText win = new FrmInsertText(chapter, ass.CreateInstance(model.Class));
win.CreateModuleIntance += new Framework.Interface.Workbench.FrmInsertText.CreateModuleHandle(CreateModule);
win.ShowDialog();
}
public FrmProperty(Framework.Entity.Chapter chapter)
{
InitializeComponent();
Framework.Entity.Model model = (Framework.Entity.Model)utilService.FindById(new Framework.Entity.Model(), chapter.Model);
System.Reflection.Assembly ass = System.Reflection.Assembly.LoadFrom(System.Windows.Forms.Application.ExecutablePath.Replace("\\" + System.Windows.Forms.Application.StartupPath, ""));
PropertyGrid.SelectedObject = ass.CreateInstance(model.Class);
System.Collections.ArrayList templateList = contentService.GetContentTemplateByTitle(chapter.Title);
foreach (Framework.Entity.Template template in templateList)
{
Framework.Class.ComboItem item = new Framework.Class.ComboItem();
item.Text = template.Title;
item.Value = template;
CbxType.Items.Add(item);
}
if (model.Name == "模板工程专项概况")
{
CbxType.SelectedIndex = 2;
CbxType.Visible = false;
LbType.Visible = false;
}
else
{
CbxType.Items.RemoveAt(2);
CbxType.SelectedIndex = 0;
}
}
private void BtnRedo_Click(object sender, System.EventArgs e)
{
Framework.Entity.Model model = (Framework.Entity.Model)utilService.FindById(new Framework.Entity.Model(), chapter.Model);
System.Reflection.Assembly ass = System.Reflection.Assembly.LoadFrom(System.Windows.Forms.Application.ExecutablePath.Replace("\\" + System.Windows.Forms.Application.StartupPath, ""));
ShowFrmProfile(model, ass);
}
private void MnModify_Click(object sender, System.EventArgs e)
{
Framework.Entity.Model model = (Framework.Entity.Model)AdvTree.SelectedNode.Tag;
FrmModel win = new FrmModel(true, model);
win.RefreshIntance += new Framework.Interface.Content.FrmModel.RefreshHandle(RefreshList);
win.ShowDialog();
}
private void UclInsertText_Load(object sender, System.EventArgs e)
{
chapter = (Framework.Entity.Chapter) this.Tag;
System.Xml.XmlElement element = Framework.Class.XmlTool.FindChapterByCid(chapter.Id);
if (!element.GetAttribute("DOC").Equals(""))
{
path = WinWordControlEx.RandomPath;
WinWordControlEx.SetWordString(element.GetAttribute("DOC"), path);
}
else
{
Framework.Entity.Model model = (Framework.Entity.Model)utilService.FindById(new Framework.Entity.Model(), chapter.Model);
System.Reflection.Assembly ass = System.Reflection.Assembly.LoadFrom(System.Windows.Forms.Application.ExecutablePath.Replace("\\" + System.Windows.Forms.Application.StartupPath, ""));
ShowFrmProfile(model, ass);
}
}
public void Delete(object entity)
{
using (this.getConnection)
{
this.getConnection.Open();
System.Data.IDbCommand cmd = this.getConnection.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
switch (Framework.Class.PackageEntity.Dispatcher(entity))
{
case 1:
Framework.Entity.Module module = (Framework.Entity.Module)entity;
cmd.CommandText = "DELETE FROM FW_Module WHERE M_Id = " + module.Id;
break;
case 2:
Framework.Entity.Role role = (Framework.Entity.Role)entity;
cmd.CommandText = "DELETE FROM FW_Role WHERE R_Id = " + role.Id;
break;
case 3:
Framework.Entity.User user = (Framework.Entity.User)entity;
cmd.CommandText = "DELETE FROM FW_User WHERE U_Id = " + user.Id;
break;
case 4:
Framework.Entity.Chapter chapter = (Framework.Entity.Chapter)entity;
cmd.CommandText = "DELETE FROM CB_Chapter WHERE C_Id = " + chapter.Id;
break;
case 5:
Framework.Entity.Template template = (Framework.Entity.Template)entity;
cmd.CommandText = "DELETE FROM CB_Template WHERE T_Id = " + template.Id;
break;
case 6:
Framework.Entity.Model model = (Framework.Entity.Model)entity;
cmd.CommandText = "DELETE FROM CB_Model WHERE D_Id = " + model.Id;
break;
}
cmd.ExecuteReader();
this.getConnection.Close();
}
}
private void MnDelete_Click(object sender, System.EventArgs e)
{
Framework.Entity.Model model = (Framework.Entity.Model)AdvTree.SelectedNode.Tag;
utilService.Delete(model);
RefreshList();
}
public FrmModel(bool _flag, Framework.Entity.Model _model)
{
InitializeComponent();
flag = _flag;
model = _model;
}
public static System.Collections.ArrayList Package(object entity, System.Data.DataTable dt)
{
System.Collections.ArrayList result = new System.Collections.ArrayList();
switch (Dispatcher(entity))
{
case 1:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Module module = new Framework.Entity.Module();
module.Id = System.Convert.ToInt32(dt.Rows[i][0]);
module.Title = System.Convert.ToString(dt.Rows[i][1]);
module.Class = System.Convert.ToString(dt.Rows[i][2]);
module.Pid = System.Convert.ToInt32(dt.Rows[i][3]);
module.Level = System.Convert.ToInt32(dt.Rows[i][4]);
module.Order = System.Convert.ToInt32(dt.Rows[i][5]);
module.Image = System.Convert.ToInt32(dt.Rows[i][6]);
module.Position = System.Convert.ToInt32(dt.Rows[i][7]);
result.Add(module);
}
break;
case 2:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Role role = new Framework.Entity.Role();
role.Id = System.Convert.ToInt32(dt.Rows[i][0]);
role.Name = System.Convert.ToString(dt.Rows[i][1]);
role.Mark = System.Convert.ToString(dt.Rows[i][2]);
role.Modules = System.Convert.ToString(dt.Rows[i][3]);
result.Add(role);
}
break;
case 3:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.User user = new Framework.Entity.User();
user.Id = System.Convert.ToInt32(dt.Rows[i][0]);
user.Name = System.Convert.ToString(dt.Rows[i][1]);
user.Password = System.Convert.ToString(dt.Rows[i][2]);
user.Roles = System.Convert.ToString(dt.Rows[i][3]);
result.Add(user);
}
break;
case 4:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Chapter chapter = new Framework.Entity.Chapter();
chapter.Id = System.Convert.ToInt32(dt.Rows[i][0]);
chapter.Pid = System.Convert.ToInt32(dt.Rows[i][1]);
chapter.Title = System.Convert.ToString(dt.Rows[i][2]);
chapter.Description = System.Convert.ToString(dt.Rows[i][3]);
chapter.State = System.Convert.ToInt32(dt.Rows[i][4]);
chapter.Module = System.Convert.ToInt32(dt.Rows[i][5]);
chapter.Model = System.Convert.ToInt32(dt.Rows[i][6]);
chapter.Type = System.Convert.ToInt32(dt.Rows[i][7]);
result.Add(chapter);
}
break;
case 5:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Template template = new Framework.Entity.Template();
template.Id = System.Convert.ToInt32(dt.Rows[i][0]);
template.Title = System.Convert.ToString(dt.Rows[i][1]);
template.Key = System.Convert.ToString(dt.Rows[i][2]);
template.Chapter = System.Convert.ToInt32(dt.Rows[i][3]);
template.Content = (byte[])dt.Rows[i][4];
template.State = System.Convert.ToInt32(dt.Rows[i][5]);
template.Type = System.Convert.ToInt32(dt.Rows[i][6]);
result.Add(template);
}
break;
case 6:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Model model = new Framework.Entity.Model();
model.Id = System.Convert.ToInt32(dt.Rows[i][0]);
model.Name = System.Convert.ToString(dt.Rows[i][1]);
model.Class = System.Convert.ToString(dt.Rows[i][2]);
model.Description = System.Convert.ToString(dt.Rows[i][3]);
model.State = System.Convert.ToInt32(dt.Rows[i][4]);
result.Add(model);
}
break;
}
return result;
}
public FrmModel(bool _flag, Framework.Entity.Model _model)
{
InitializeComponent();
flag = _flag;
model = _model;
}
public static System.Collections.ArrayList Package(object entity, System.Data.DataTable dt)
{
System.Collections.ArrayList result = new System.Collections.ArrayList();
switch (Dispatcher(entity))
{
case 1:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Module module = new Framework.Entity.Module();
module.Id = System.Convert.ToInt32(dt.Rows[i][0]);
module.Title = System.Convert.ToString(dt.Rows[i][1]);
module.Class = System.Convert.ToString(dt.Rows[i][2]);
module.Pid = System.Convert.ToInt32(dt.Rows[i][3]);
module.Level = System.Convert.ToInt32(dt.Rows[i][4]);
module.Order = System.Convert.ToInt32(dt.Rows[i][5]);
module.Image = System.Convert.ToInt32(dt.Rows[i][6]);
module.Position = System.Convert.ToInt32(dt.Rows[i][7]);
result.Add(module);
}
break;
case 2:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Role role = new Framework.Entity.Role();
role.Id = System.Convert.ToInt32(dt.Rows[i][0]);
role.Name = System.Convert.ToString(dt.Rows[i][1]);
role.Mark = System.Convert.ToString(dt.Rows[i][2]);
role.Modules = System.Convert.ToString(dt.Rows[i][3]);
result.Add(role);
}
break;
case 3:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.User user = new Framework.Entity.User();
user.Id = System.Convert.ToInt32(dt.Rows[i][0]);
user.Name = System.Convert.ToString(dt.Rows[i][1]);
user.Password = System.Convert.ToString(dt.Rows[i][2]);
user.Roles = System.Convert.ToString(dt.Rows[i][3]);
result.Add(user);
}
break;
case 4:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Chapter chapter = new Framework.Entity.Chapter();
chapter.Id = System.Convert.ToInt32(dt.Rows[i][0]);
chapter.Pid = System.Convert.ToInt32(dt.Rows[i][1]);
chapter.Title = System.Convert.ToString(dt.Rows[i][2]);
chapter.Description = System.Convert.ToString(dt.Rows[i][3]);
chapter.State = System.Convert.ToInt32(dt.Rows[i][4]);
chapter.Module = System.Convert.ToInt32(dt.Rows[i][5]);
chapter.Model = System.Convert.ToInt32(dt.Rows[i][6]);
chapter.Type = System.Convert.ToInt32(dt.Rows[i][7]);
result.Add(chapter);
}
break;
case 5:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Template template = new Framework.Entity.Template();
template.Id = System.Convert.ToInt32(dt.Rows[i][0]);
template.Title = System.Convert.ToString(dt.Rows[i][1]);
template.Key = System.Convert.ToString(dt.Rows[i][2]);
template.Chapter = System.Convert.ToInt32(dt.Rows[i][3]);
template.Content = (byte[])dt.Rows[i][4];
template.State = System.Convert.ToInt32(dt.Rows[i][5]);
template.Type = System.Convert.ToInt32(dt.Rows[i][6]);
result.Add(template);
}
break;
case 6:
for (int i = 0; i < dt.Rows.Count; i++)
{
Framework.Entity.Model model = new Framework.Entity.Model();
model.Id = System.Convert.ToInt32(dt.Rows[i][0]);
model.Name = System.Convert.ToString(dt.Rows[i][1]);
model.Class = System.Convert.ToString(dt.Rows[i][2]);
model.Description = System.Convert.ToString(dt.Rows[i][3]);
model.State = System.Convert.ToInt32(dt.Rows[i][4]);
result.Add(model);
}
break;
}
return(result);
}
public void Insert(object entity)
{
using (this.getConnection)
{
this.getConnection.Open();
System.Data.IDbCommand cmd = this.getConnection.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
object obj;
switch (Framework.Class.PackageEntity.Dispatcher(entity))
{
case 1:
cmd.CommandText = "SELECT MAX(M_Id) + 1 FROM FW_Module";
obj = cmd.ExecuteScalar();
Framework.Entity.Module module = (Framework.Entity.Module)entity;
module.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO FW_Module (M_Id,M_Title,M_Class,M_Pid,M_Level,M_Order,M_Image,M_Position) VALUES (@Id,@Title,@Class,@Pid,@Level,@Order,@Image,@Position)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", module.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", module.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Class", module.Class));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Pid", module.Pid));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Level", module.Level));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Order", module.Order));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Image", module.Image));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Position", module.Position));
break;
case 2:
cmd.CommandText = "SELECT MAX(R_Id) + 1 FROM FW_Role";
obj = cmd.ExecuteScalar();
Framework.Entity.Role role = (Framework.Entity.Role)entity;
role.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO FW_Role (R_Id,R_Name,R_Mark,R_Modules) VALUES (@Id,@Name,@Mark,@Modules)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", role.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", role.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Mark", role.Mark));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Modules", role.Modules));
break;
case 3:
cmd.CommandText = "SELECT MAX(U_Id) + 1 FROM FW_User";
obj = cmd.ExecuteScalar();
Framework.Entity.User user = (Framework.Entity.User)entity;
user.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO FW_User (U_Id,U_Name,U_Password,U_Roles) VALUES (@Id,@Name,@Password,@Roles)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", user.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", user.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Password", user.Password));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Roles", user.Roles));
break;
case 4:
cmd.CommandText = "SELECT MAX(C_Id) + 1 FROM CB_Chapter";
obj = cmd.ExecuteScalar();
Framework.Entity.Chapter chapter = (Framework.Entity.Chapter)entity;
chapter.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO CB_Chapter (C_Id,C_Pid,C_Title,C_Description,C_State,M_Id,D_Id,C_Type) VALUES (@Id,@Pid,@Title,@Description,@State,@Module,@Model,@Type)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", chapter.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Pid", chapter.Pid));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", chapter.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Description", chapter.Description));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", chapter.State));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Module", chapter.Module));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Model", chapter.Model));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Type", chapter.Type));
break;
case 5:
cmd.CommandText = "SELECT MAX(T_Id) + 1 FROM CB_Template";
obj = cmd.ExecuteScalar();
Framework.Entity.Template template = (Framework.Entity.Template)entity;
template.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO CB_Template (T_Id,T_Title,T_Key,C_Id,T_Content,T_State,T_Type) VALUES (@Id,@Title,@Key,@Chapter,@Content,@State,@Type)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", template.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", template.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Key", template.Key));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Chapter", template.Chapter));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Content", template.Content));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", template.State));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Type", template.Type));
break;
case 6:
cmd.CommandText = "SELECT MAX(D_Id) + 1 FROM CB_Model";
obj = cmd.ExecuteScalar();
Framework.Entity.Model model = (Framework.Entity.Model)entity;
model.Id = System.Convert.ToInt32(obj == System.DBNull.Value ? 1 : obj);
cmd.CommandText = @"INSERT INTO CB_Model (D_Id,D_Name,D_Class,D_Description,D_State) VALUES (@Id,@Name,@Class,@Description,@State)";
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Id", model.Id));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", model.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Class", model.Class));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Description", model.Description));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", model.State));
break;
}
cmd.ExecuteNonQuery();
this.getConnection.Close();
}
}
public void Update(object entity)
{
using (this.getConnection)
{
this.getConnection.Open();
System.Data.IDbCommand cmd = this.getConnection.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
switch (Framework.Class.PackageEntity.Dispatcher(entity))
{
case 1:
Framework.Entity.Module module = (Framework.Entity.Module)entity;
cmd.CommandText = @"UPDATE FW_Module SET M_Title = @Title, M_Class = @Class, M_Pid = @Pid, M_Level = @Level, M_Order = @Order, M_Image = @Image, M_Position = @Position WHERE M_Id = " + module.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", module.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Class", module.Class));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Pid", module.Pid));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Level", module.Level));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Order", module.Order));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Image", module.Image));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Position", module.Position));
break;
case 2:
Framework.Entity.Role role = (Framework.Entity.Role)entity;
cmd.CommandText = @"UPDATE FW_Role SET R_Name = @Name, R_Mark = @Mark, R_Modules = @Modules WHERE R_Id = " + role.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", role.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Mark", role.Mark));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Modules", role.Modules));
break;
case 3:
Framework.Entity.User user = (Framework.Entity.User)entity;
cmd.CommandText = @"UPDATE FW_User SET U_Name = @Name, U_Password = @Password, U_Roles = @Roles WHERE U_Id = " + user.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", user.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Password", user.Password));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Roles", user.Roles));
break;
case 4:
Framework.Entity.Chapter chapter = (Framework.Entity.Chapter)entity;
cmd.CommandText = "UPDATE CB_Chapter SET C_Pid = @Pid, C_Title = @Title, C_Description = @Description, C_State = @State, M_Id = @Module, D_Id = @Model ,C_Type= @Type WHERE C_Id = " + chapter.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Pid", chapter.Pid));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", chapter.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Description", chapter.Description));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", chapter.State));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Module", chapter.Module));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Model", chapter.Model));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Type", chapter.Type));
break;
case 5:
Framework.Entity.Template template = (Framework.Entity.Template)entity;
cmd.CommandText = "UPDATE CB_Template SET T_Title = @Title, T_Key = @Key, C_Id = @Chapter, T_Content = @Content, T_State = @State, T_Type = @Type WHERE T_Id = " + template.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Title", template.Title));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Key", template.Key));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Chapter", template.Chapter));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Content", template.Content));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", template.State));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Type", template.Type));
break;
case 6:
Framework.Entity.Model model = (Framework.Entity.Model)entity;
cmd.CommandText = "UPDATE CB_Model SET D_Name = @Name, D_Class = @Class, D_Description = @Description, D_State = @State WHERE D_Id = " + model.Id;
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Name", model.Name));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Class", model.Class));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@Description", model.Description));
cmd.Parameters.Add(new System.Data.SQLite.SQLiteParameter("@State", model.State));
break;
}
cmd.ExecuteReader();
this.getConnection.Close();
}
}
