public Form_DB()
{
InitializeComponent();
connector = new DBconnector();
list_from_DB();
}
public Form_Add()
{
InitializeComponent();
connector = new DBconnector();
combo_From_DB();
lv_From_DB();
}
public Form_Add()
{
InitializeComponent();
connector = new DBconnector();
combo_From_DB();
lv_From_DB();
}
public Form_Save(Form_Main _fmain, int i)
{
InitializeComponent();
fmain = _fmain;
connector = new DBconnector();
combo_from_db();
i_from = i;
}
public Form_Save(Form_Main _fmain, int i)
{
InitializeComponent();
fmain = _fmain;
connector = new DBconnector();
combo_from_db();
i_from = i;
}
public Form_DB()
{
InitializeComponent();
connector = new DBconnector();
list_from_DB();
}
public Form_Cloning()
{
InitializeComponent();
connector = new DBconnector();
list_from_DB();
i_SP = (int)(pn_view.Size.Width * 0.1);
i_EP = (int)(pn_view.Size.Width * 0.9);
}
public Form_Select(Form_Main _fMain, string _strType)
{
InitializeComponent();
connector = new DBconnector();
str_FormType = _strType;
fMain = _fMain;
select_to_listview();
}
public Form_Cloning()
{
InitializeComponent();
connector = new DBconnector();
list_from_DB();
i_SP = (int)(pn_view.Size.Width * 0.1);
i_EP = (int)(pn_view.Size.Width * 0.9);
}
public Form_Select(Form_Main _fMain, string _strType)
{
InitializeComponent();
connector = new DBconnector();
str_FormType = _strType;
fMain = _fMain;
select_to_listview();
}
public Form_Select_Other(Form_Main _fmain)
{
InitializeComponent();
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
connector = new DBconnector();
fMain = _fmain;
listview_from_DB();
combobox_setting_item();
}
public Form_Select_Other(Form_Main _fmain)
{
InitializeComponent();
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
connector = new DBconnector();
fMain = _fmain;
listview_from_DB();
combobox_setting_item();
}
public Form_Update(OleDbDataReader oddr)
{
InitializeComponent();
connector = new DBconnector();
while (oddr.Read())
{
tb_Name.Text = oddr.GetString(0);
tb_Desc.Text = oddr.GetString(2);
tb_Seq.Text = oddr.GetString(3);
}
}
public Form_Update(OleDbDataReader oddr)
{
InitializeComponent();
connector = new DBconnector();
while (oddr.Read())
{
tb_Name.Text = oddr.GetString(0);
tb_Desc.Text = oddr.GetString(2);
tb_Seq.Text = oddr.GetString(3);
}
}
public Form_Download()
{
InitializeComponent();
bgw = new BackgroundWorker();
bgw.WorkerReportsProgress = true;
bgw.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker_DoWork);
bgw.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.BackgroundWorker_ProgressChanged);
bgw.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker_RunWorkerCompleted);
bgw2 = new BackgroundWorker();
bgw2.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker2_DoWork);
bgw2.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker2_RunWorkerCompleted);
bgw3 = new BackgroundWorker();
bgw3.WorkerReportsProgress = true;
bgw3.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker3_DoWork);
bgw3.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.BackgroundWorker3_ProgressChanged);
bgw3.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker3_RunWorkerCompleted);
connector = new DBconnector();
this.combo_from_db();
}
public Form_Download()
{
InitializeComponent();
bgw = new BackgroundWorker();
bgw.WorkerReportsProgress = true;
bgw.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker_DoWork);
bgw.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.BackgroundWorker_ProgressChanged);
bgw.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker_RunWorkerCompleted);
bgw2 = new BackgroundWorker();
bgw2.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker2_DoWork);
bgw2.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker2_RunWorkerCompleted);
bgw3 = new BackgroundWorker();
bgw3.WorkerReportsProgress = true;
bgw3.DoWork += new System.ComponentModel.DoWorkEventHandler(this.BackgroundWorker3_DoWork);
bgw3.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.BackgroundWorker3_ProgressChanged);
bgw3.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.BackgroundWorker3_RunWorkerCompleted);
connector = new DBconnector();
this.combo_from_db();
}
/// <summary>
/// 클로닝 시퀀스 하는거염
/// </summary>
/// <param name="bb_name"></param>
/// <param name="bb_seq"></param>
/// <param name="rs1"></param>
/// <param name="i_rs1"></param>
/// <param name="rs2"></param>
/// <param name="i_rs2"></param>
public void processing_Seq(string bb_name, string bb_seq, string rs1, int i_rs1, string rs2, int i_rs2, bool isReg)
{
// 먼저 브릭리스트 앞에 해당되는 pre, suf 붙여주기
// 그런 다음에 bb seq를 가공하고 seq의 정보를 보고
// 먼저 위치계산을 먼저 해서 브릭이 앞에 갈지 뒤에 갈지를 결정
// 하지만 rs가 오는 순서는 prefix인지 suffix인지는 결정되어 있으니
string str_brick_prefix;
string str_brick_suffix;
string str_plasmid_seq;
if (rs1 == "Ecor1")
{
if (this.newBD.sl_subpart_list[0].part_seq.StartsWith("atg"))
{
str_brick_prefix = "cgcggccgcttctaga";
}
else
{
str_brick_prefix = "cgcggccgcttctagag";
}
}
else
{
if (this.newBD.sl_subpart_list[0].part_seq.StartsWith("atg"))
{
str_brick_prefix = "ag";
}
else
{
str_brick_prefix = "a";
}
}
if (rs2 == "Pst1")
{
str_brick_suffix = "tactagtagcggccgc";
}
else
{
str_brick_suffix = "ta";
}
// 제한효소가 뒤집어 있으면 서열 뒤집기
// 아니면 그대로
// 그리고 나서 prefix 넣고 브릭 넣고 서픽스 넣고 제한효소 넣고 시퀀스 넣고 제한효소 넣고 끝.
// 백본 시퀀스 서브시퀀스 가져오기
// rs1 이 더 큼
// rs2 는 앞 쪽임
str_plasmid_seq = bb_seq.Substring(i_rs2 + 5, Math.Abs(i_rs1 + 1 - (i_rs2 + 5)));
// 현재 백본 시퀀스 처리
if (i_rs2 > i_rs1)
{
string str_plasmid_seq_d = "";
foreach (char c in str_plasmid_seq.ToCharArray())
{
switch (c)
{
case 'a':
str_plasmid_seq_d += 't';
break;
case 't':
str_plasmid_seq_d += 'a';
break;
case 'c':
str_plasmid_seq_d += 'g';
break;
case 'g':
str_plasmid_seq_d += 'c';
break;
}
}
str_plasmid_seq = str_plasmid_seq_d;
}
// 클로닝 리스트 작성
// 1. Prefix
// 2. 브릭리스트
// 3. Suffix
// 4. 제한효소
// 5. 백본 시퀀스
// 6. 제한효소
int i = 0;
Brick_sub_data _bsd = new Brick_sub_data();
_bsd.part_name = "Prefix";
_bsd.part_type = "Prefix";
_bsd.part_seq = str_brick_prefix;
this.newBD.sl_cloning_list.Add(0, _bsd);
for (i = 1; i < this.newBD.sl_subpart_list.Count + 1; i++)
{
this.newBD.sl_cloning_list.Add(i, newBD.sl_subpart_list[i - 1]);
}
_bsd = new Brick_sub_data();
_bsd.part_name = "Suffix";
_bsd.part_type = "Suffix";
_bsd.part_seq = str_brick_suffix;
this.newBD.sl_cloning_list.Add(i, _bsd);
_bsd = new Brick_sub_data();
_bsd.part_name = rs2;
_bsd.part_type = rs2;
_bsd.part_seq = this.get_SR_seq(rs1);
this.newBD.sl_cloning_list.Add(i + 1, _bsd);
_bsd = new Brick_sub_data();
//_bsd.part_name = bb_name;
connector = new DBconnector();
if (isReg) // 등록된 브릭이면
{
string str_q = "select * from part where part_name = '" + bb_name + "'";
OleDbDataReader oddr = connector.select_Data(str_q);
while (oddr.Read())
{
_bsd.part_id = oddr.GetInt32(0);
_bsd.part_name = oddr.GetString(1);
_bsd.part_desc = oddr.GetString(3);
_bsd.part_type = oddr.GetString(4);
_bsd.part_status = oddr.GetString(5);
_bsd.part_result = oddr.GetString(6);
_bsd.part_entered = oddr.GetString(10);
_bsd.part_author = oddr.GetString(11);
_bsd.best_qulity = oddr.GetString(12);
}
str_q = "select p.part_name from part as p, specified_subparts as sp where sp.part_id = " + _bsd.part_id + " and sp.subpart_id = p.part_id";
oddr = connector.select_Data(str_q);
while (oddr.Read())
{
_bsd.subparts.Add(oddr.GetString(0));
lb_Subparts.Items.Add(oddr.GetString(0));
}
}
else
{
string str_q = "select * from userbricks where part_name = '" + bb_name + "'";
OleDbDataReader oddr = connector.select_Data(str_q);
while (oddr.Read())
{
_bsd.part_name = oddr.GetString(0);
_bsd.part_desc = oddr.GetString(2);
_bsd.part_type = oddr.GetString(1);
_bsd.part_seq = oddr.GetString(3);
}
}
_bsd.part_seq = str_plasmid_seq;
this.newBD.sl_cloning_list.Add(i + 2, _bsd);
_bsd = new Brick_sub_data();
_bsd.part_name = rs1;
_bsd.part_name = rs1;
_bsd.part_seq = this.get_SR_seq(rs2);
this.newBD.sl_cloning_list.Add(i + 3, _bsd);
}
public void data_load()
{
StringBuilder sbLoad = new StringBuilder();
Stream sr_Stream;
connector = new DBconnector();
OpenFileDialog openFD = new OpenFileDialog();
openFD.Filter = "project files (*brp)|*.brp";
if (openFD.ShowDialog() == DialogResult.OK)
{
if ((sr_Stream = openFD.OpenFile()) != null)
{
this.newBD = new Brick_data();
TextReader tr = new StreamReader(sr_Stream);
string _str;
int i = 0;
int j = 0;
while ((_str = tr.ReadLine()) != null)
{
if (_str.Length == 0)
{
continue;
}
if (i == 0)
{
this.newBD.str_brick_name = _str;
}
else if (i == 1)
{
this.newBD.str_brick_type = _str;
}
else if (i == 2)
{
this.newBD.str_brick_desc = _str;
}
else
{
// 여기서 브릭 네임으로 가져와서 정보를 서브 데이터로 저장해야함
Brick_sub_data bsd = new Brick_sub_data();
string[] split_str = _str.Split(' ');
if (split_str[0] == "Scar" || split_str[0] == "Spe1+Xba1")
{
// 여긴 스칼임
bsd.part_name = "Scar";
bsd.part_type = "Scar";
bsd.part_seq = "";
this.newBD.sl_subpart_list.Add(j, bsd);
}
else if (split_str[1] == "-1")
{
// 유저브릭임.
string str_q = "select * from userbricks where part_name = '" + split_str[0] + "'";
OleDbDataReader oddr = connector.select_Data(str_q);
while (oddr.Read())
{
bsd.part_name = oddr.GetString(0);
bsd.part_type = oddr.GetString(1);
bsd.part_desc = oddr.GetString(2);
bsd.part_seq = oddr.GetString(3);
if (split_str.Count() > 2)
{
bsd.part_icon = int.Parse(split_str[2]);
}
}
this.newBD.sl_subpart_list.Add(j, bsd);
}
else
{
string str_q = "select * from part where part_name = '" + split_str[0] + "'";
OleDbDataReader oddr = connector.select_Data(str_q);
while (oddr.Read())
{
bsd.part_id = oddr.GetInt32(0);
bsd.part_name = oddr.GetString(1);
bsd.part_desc = oddr.GetString(3);
bsd.part_type = oddr.GetString(4);
bsd.part_status = oddr.GetString(5);
bsd.part_result = oddr.GetString(6);
bsd.part_entered = oddr.GetString(10);
bsd.part_author = oddr.GetString(11);
bsd.best_qulity = oddr.GetString(12);
}
str_q = "select sequences.seq_data from sequences, part where part.part_name = '" + split_str[0] + "' and part.part_id = sequences.part_id";
oddr = connector.select_Data(str_q);
while (oddr.Read())
{
bsd.part_seq = oddr.GetString(0);
}
str_q = "select p.part_name from part as p, specified_subparts as sp where sp.part_id = " + bsd.part_id + " and sp.subpart_id = p.part_id";
oddr = connector.select_Data(str_q);
while (oddr.Read())
{
bsd.subparts.Add(oddr.GetString(0));
}
if (split_str.Count() > 2)
{
bsd.part_icon = int.Parse(split_str[2]);
}
this.newBD.sl_subpart_list.Add(j, bsd);
}
j++;
}
i++;
}
}
}
connector = null;
this.change_FromName();
}
