private void tựĐộngThanhLýToolStripMenuItem_Click(object sender, EventArgs e)
{
int count = 0;
List <TAISAN> liTS = bll.GetListTS();
foreach (TAISAN ts in liTS)
{
List <CHUNGTUGIAM> ThongtinCtg = bll.GetThongTinCTGbyMaTS(ts.MaTS);
if (ThongtinCtg.Count > 0)
{
continue;
}
int nsd = ts.NgayGhiTang.Year;
int now = DateTime.Now.Year;
if (ts.TyLeCL - ts.TyLeHM * (now - nsd) == 0)
{
count++;
CHUNGTUGIAM ctg = new CHUNGTUGIAM();
ctg.MaChungTuGiam = RandomString(8);
ctg.MaTS = ts.MaTS;
ctg.NgayGhiGiam = DateTime.Now;
ctg.SoLuong = ts.SoLuong;
ctg.ThanhTien = ts.ThanhTien;
ctg.NoiDung = "Thanh lý hao mòn dưới 0%";
ctg.GhiChu = "";
bll.AddCTG(ctg);
}
}
MessageBox.Show("Đã thanh lý " + count.ToString() + " tài sản có tỷ lệ còn lại dưới 0%!");
}
public void AddCTG(CHUNGTUGIAM myCTG)
{
db.CHUNGTUGIAMs.Add(myCTG);
var s = db.TAISANs.Single(p => p.MaTS == myCTG.MaTS);
TAISAN myTS = s;
myTS.SoLuong = myTS.SoLuong - myCTG.SoLuong;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
}
}
// Chuc nang delete chung tu giam
public void XoaCTG(string id)
{
var s = db.CHUNGTUGIAMs.Single(p => p.MaChungTuGiam == id);
int SoLuong = s.SoLuong;
var x = db.TAISANs.Single(p => p.MaTS == s.MaTS);
x.SoLuong += SoLuong;
CHUNGTUGIAM myCTG = s;
db.CHUNGTUGIAMs.Remove(myCTG);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
CHUNGTUGIAM newCTG = new CHUNGTUGIAM();
newCTG.MaChungTuGiam = comboBoxMaCTGiam.SelectedValue.ToString();
newCTG.SoLuong = int.Parse(numericUpDownSoLuong.Value.ToString());
newCTG.MaTS = textBoxMaTS.Text;
newCTG.NgayGhiGiam = dateTimePickerGhiGiam.Value;
newCTG.NoiDung = textBoxNoiDung.Text;
newCTG.GhiChu = textBoxGhiChu.Text;
int tien;
Int32.TryParse(textBoxThanhTien.Text, out tien);
newCTG.ThanhTien = tien;
d.Invoke(newCTG, SoLuongCu);
this.Close();
MessageBox.Show("Sửa chứng từ giảm thành công !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void buttonOK_Click(object sender, EventArgs e)
{
bool isGoodToGo = true;
foreach (object ob in bll.GetListMaCTG())
{
if (textBoxMaCTG.Text == ob.ToString())
{
MessageBox.Show("Nhập lại mã chứng từ giảm", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
isGoodToGo = false;
break;
}
}
if (String.IsNullOrEmpty(textBoxMaCTG.Text.Trim()))
{
MessageBox.Show("Nhập lại mã chứng từ giảm", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
isGoodToGo = false;
}
if (isGoodToGo)
{
CHUNGTUGIAM myCTG = new CHUNGTUGIAM();
myCTG.MaChungTuGiam = textBoxMaCTG.Text;
myCTG.MaTS = comboBoxMaTS.SelectedValue.ToString();
myCTG.NgayGhiGiam = DateTime.Parse(dateTimePickerGhiGiam.Value.ToShortDateString());
myCTG.SoLuong = int.Parse(numericUpDownSoLuong.Value.ToString());
int tien;
Int32.TryParse(textBoxThanhTien.Text, out tien);
myCTG.ThanhTien = tien;
myCTG.NoiDung = textBoxNoiDung.Text;
myCTG.GhiChu = textBoxGhiChu.Text;
d.Invoke(myCTG);
this.Close();
MessageBox.Show("Thêm chứng từ giảm thành công !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void SuaCTG(CHUNGTUGIAM newCTG, int SoLuongCu)
{
var s = db.CHUNGTUGIAMs.Single(p => p.MaChungTuGiam == newCTG.MaChungTuGiam);
CHUNGTUGIAM myCTG = s;
myCTG.SoLuong = newCTG.SoLuong;
myCTG.NgayGhiGiam = newCTG.NgayGhiGiam;
myCTG.NoiDung = newCTG.NoiDung;
myCTG.GhiChu = newCTG.GhiChu;
myCTG.ThanhTien = newCTG.ThanhTien;
var x = db.TAISANs.Single(p => p.MaTS == newCTG.MaTS);
TAISAN myTS = x;
myTS.SoLuong = myTS.SoLuong + SoLuongCu - myCTG.SoLuong;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
}
}
public void AddCTG(CHUNGTUGIAM myCTG)
{
dal.AddCTG(myCTG);
}
public void SuaCTG(CHUNGTUGIAM myCTG, int SoLuongCu)
{
dal.SuaCTG(myCTG, SoLuongCu);
}
private void importFromXLSToolStripMenuItem_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "Microsoft Excel(*.xls)|*.xls";
string filepath = "";
if (ofd.ShowDialog() == DialogResult.OK)
{
filepath = Path.GetFullPath(ofd.FileName);
string path = AppDomain.CurrentDomain.BaseDirectory + "log.txt";
if (!File.Exists(path))
{
File.Create(path);
}
TextWriter tw = new StreamWriter(path, true);
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkBook;
Excel.Range range;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(filepath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
int count = 0;
foreach (Worksheet xlWorkSheet in xlWorkBook.Worksheets)
{
int begini, beginj;
begini = 12;
beginj = 2;
while (xlWorkSheet.Cells[begini, beginj].Value2 != null)
{
TAISAN ts = new TAISAN();
ts.MaTS = xlWorkSheet.Cells[begini, beginj].Value2.ToString();
try
{
ts.MaPhong = bll.GetMaPhong(xlWorkSheet.Name);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi tên phòng");
}
ts.MaLoaiTS = xlWorkSheet.Cells[begini, beginj + 1].Value2.ToString();
ts.NgayGhiTang = Convert.ToDateTime("1/1/" + xlWorkSheet.Cells[begini, beginj + 2].Value2.ToString());
ts.TenTS = xlWorkSheet.Cells[begini, beginj + 3].Value2.ToString();
ts.ThongSoKyThuat = xlWorkSheet.Cells[begini, beginj + 4].Value2.ToString();
ts.SoLuong = int.Parse(xlWorkSheet.Cells[begini, beginj + 5].Value2.ToString());
ts.ThanhTien = int.Parse(xlWorkSheet.Cells[begini, beginj + 6].Value2.ToString());
ts.TyLeCL = int.Parse(xlWorkSheet.Cells[begini, beginj + 7].Value2.ToString());
ts.TyLeHM = int.Parse(xlWorkSheet.Cells[begini, beginj + 12].Value2.ToString());
ts.MaChungTuTang = RandomString(8);
try
{
count++;
bll.AddTS(ts);
}
catch (Exception ex)
{
tw.WriteLine("**********" + DateTime.Now + "**********");
tw.WriteLine("Imported File: " + filepath + "Line " + begini);
count--;
begini++;
continue;
}
if (xlWorkSheet.Cells[begini, beginj + 13].Value2 != null)
{
CHUNGTUGIAM ctg = new CHUNGTUGIAM();
ctg.MaChungTuGiam = ts.MaTS + "ctg";
ctg.MaTS = ts.MaTS;
ctg.NgayGhiGiam = Convert.ToDateTime("1/1/" + xlWorkSheet.Cells[begini, beginj + 13].Value2.ToString());
ctg.NoiDung = xlWorkSheet.Cells[begini, beginj + 14].Value2.ToString();
ctg.SoLuong = int.Parse(xlWorkSheet.Cells[begini, beginj + 15].Value2.ToString());
ctg.ThanhTien = int.Parse(xlWorkSheet.Cells[begini, beginj + 16].Value2.ToString());
ctg.GhiChu = xlWorkSheet.Cells[begini, beginj + 17].Value2.ToString();
MessageBox.Show(ctg.MaChungTuGiam);
bll.AddCTG(ctg);
}
begini++;
}
tw.Close();
}
MessageBox.Show("Có " + count.ToString() + " hàng dữ liệu được nhập thành công!");
MessageBox.Show("Các hàng lỗi được ghi ra ở file " + AppDomain.CurrentDomain.BaseDirectory + "log.txt");
}
}
void exportToExcel(string fullpath)
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
List <string> ListMaPhong = bll.GetListMaPhong();
ListMaPhong.RemoveAt(ListMaPhong.Count - 1);
foreach (string maphong in ListMaPhong)
{
tbStatusBar.Text = "Saving... Please Wait";
Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.Add(Type.Missing, xlWorkBook.Worksheets[xlWorkBook.Worksheets.Count], 1, XlSheetType.xlWorksheet);
xlWorkSheet.Name = bll.getTenPhong(maphong);
Range r = xlWorkSheet.Range["A8:A10"];
r.Merge();
r.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r.Font.Bold = true;
r.Cells[1, 1] = "Số TT";
Range r1 = xlWorkSheet.Range["B8:N8"];
r1.Merge();
r1.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r1.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r1.Font.Bold = true;
xlWorkSheet.Cells[8, 2] = "Ghi tăng tài sản, dụng cụ, đồ gỗ";
Range r2 = xlWorkSheet.Range["O8:S8"];
r2.Merge();
r2.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r2.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r2.Font.Bold = true;
r2.Cells[1, 1] = "Ghi giảm tài sản";
Range r3 = xlWorkSheet.Range["B9:D9"];
r3.Merge();
r3.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r3.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r3.Font.Bold = true;
r3.Cells[1, 1] = "Chứng từ";
xlWorkSheet.Cells[10, 2] = "Mã TS";
xlWorkSheet.Cells[10, 3] = "Mã số TB";
xlWorkSheet.Cells[10, 4] = "Mã NSD";
Range r4 = xlWorkSheet.Range["E9:E10"];
r4.Merge();
r4.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r4.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r4.Font.Bold = true;
r4.Cells[1, 1] = "Tên tài sản cố định, CC, DC và đồ gỗ ...";
Range r5 = xlWorkSheet.Range["F9:F10"];
r5.Merge();
r5.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r5.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r5.Font.Bold = true;
r5.Cells[1, 1] = "Số hiệu, thông số kỹ thuật";
Range r6 = xlWorkSheet.Range["G9:G10"];
r6.Merge();
r6.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r6.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r6.Font.Bold = true;
r6.Cells[1, 1] = "SL";
Range r7 = xlWorkSheet.Range["H9:H10"];
r7.Merge();
r7.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r7.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r7.Font.Bold = true;
r7.Cells[1, 1] = "Thành tiền";
Range r8 = xlWorkSheet.Range["I9:I10"];
r8.Merge();
r8.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r8.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r8.Font.Bold = true;
r8.Cells[1, 1] = "Tỷ lệ %CL";
Range r9 = xlWorkSheet.Range["J9:J10"];
r9.Merge();
r9.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r9.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r9.Font.Bold = true;
r9.Cells[1, 1] = "Tỷ lệ %CL";
Range r10 = xlWorkSheet.Range["K9:K10"];
r10.Merge();
r10.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r10.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r10.Font.Bold = true;
r10.Cells[1, 1] = "Tỷ lệ %CL";
Range r11 = xlWorkSheet.Range["L9:L10"];
r11.Merge();
r11.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r11.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r11.Font.Bold = true;
r11.Cells[1, 1] = "Tỷ lệ %CL";
Range r12 = xlWorkSheet.Range["M9:M10"];
r12.Merge();
r12.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r12.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r12.Font.Bold = true;
r12.Cells[1, 1] = "Tỷ lệ %CL";
Range r13 = xlWorkSheet.Range["N9:N10"];
r13.Merge();
r13.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r13.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r13.Font.Bold = true;
r13.Cells[1, 1] = "Tỷ lệ HM";
Range r14 = xlWorkSheet.Range["O9:P9"];
r14.Merge();
r14.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r14.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r14.Font.Bold = true;
r14.Cells[1, 1] = "Chứng từ";
Range r15 = xlWorkSheet.Range["O10:O10"];
r15.Merge();
r15.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r15.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r15.Font.Bold = true;
r15.Cells[1, 1] = "Ngày";
Range r16 = xlWorkSheet.Range["P10:P10"];
r16.Merge();
r16.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r16.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r16.Font.Bold = true;
r16.Cells[1, 1] = "Lý do";
Range r17 = xlWorkSheet.Range["Q9:Q10"];
r17.Merge();
r17.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r17.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r17.Font.Bold = true;
r17.Cells[1, 1] = "Số lượng";
Range r18 = xlWorkSheet.Range["R9:R10"];
r18.Merge();
r18.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r18.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r18.Font.Bold = true;
r18.Cells[1, 1] = "Thành tiền";
Range r19 = xlWorkSheet.Range["S9:S10"];
r19.Merge();
r19.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
r19.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
r19.Font.Bold = true;
r19.Cells[1, 1] = "Ghi chú";
QLTSContext db = new QLTSContext();
var s = db.TAISANs.Where(p => p.MaPhong.Contains(maphong)).Select(p => p);
//new { p.MaTS, p.MaPhong, p.NgayGhiTang, p.TenTS, p.ThongSoKyThuat, p.SoLuongCTT, p.TyLeCL, p.TyLeHM }
List <TAISAN> li = s.ToList <TAISAN>();
int begini = 12;
int beginj = 2;
int STT = 0;
foreach (TAISAN ts in li)
{
xlWorkSheet.Cells[begini, beginj - 1] = ++STT;
xlWorkSheet.Cells[begini, beginj] = ts.MaTS;
xlWorkSheet.Cells[begini, beginj + 1] = ts.MaLoaiTS;
xlWorkSheet.Cells[begini, beginj + 2] = ts.NgayGhiTang.Year.ToString();
xlWorkSheet.Cells[begini, beginj + 3] = ts.TenTS;
xlWorkSheet.Cells[begini, beginj + 4] = ts.ThongSoKyThuat;
xlWorkSheet.Cells[begini, beginj + 5] = ts.SoLuong;
xlWorkSheet.Cells[begini, beginj + 6] = ts.ThanhTien;
xlWorkSheet.Cells[begini, beginj + 7] = ts.TyLeCL;
xlWorkSheet.Cells[begini, beginj + 8].Formula = "=I" + begini + "-N" + begini;
xlWorkSheet.Cells[begini, beginj + 9].Formula = "=J" + begini + "-N" + begini;
xlWorkSheet.Cells[begini, beginj + 10].Formula = "=K" + begini + "-N" + begini;
xlWorkSheet.Cells[begini, beginj + 11].Formula = "=L" + begini + "-N" + begini;
xlWorkSheet.Cells[begini, beginj + 12] = ts.TyLeHM;
List <CHUNGTUGIAM> k = db.CHUNGTUGIAMs.Where(p => p.MaTS.Equals(ts.MaTS)).Select(p => p).ToList <CHUNGTUGIAM>();
CHUNGTUGIAM ctg = null;
if (k.Count > 0)
{
ctg = k[0];
}
if (ctg != null)
{
xlWorkSheet.Cells[begini, beginj + 13] = ctg.NgayGhiGiam.Year.ToString();
xlWorkSheet.Cells[begini, beginj + 14] = ctg.NoiDung;
xlWorkSheet.Cells[begini, beginj + 15] = ctg.SoLuong.ToString();
xlWorkSheet.Cells[begini, beginj + 16] = ctg.ThanhTien.ToString();
xlWorkSheet.Cells[begini, beginj + 17] = ctg.GhiChu;
}
begini++;
}
Range b = xlWorkSheet.Range[xlWorkSheet.Cells[11, 1], xlWorkSheet.Cells[begini, beginj + 17]];
b.Borders.LineStyle = XlLineStyle.xlDot;
b.Borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous;
b.Borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous;
b.Borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous;
b.Borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous;
xlWorkSheet.Columns.AutoFit();
xlWorkSheet.Rows.AutoFit();
Range x = xlWorkSheet.Range["E4:E4"];
x.Merge();
xlWorkSheet.Cells[4, 5].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
x.Font.Bold = true;
x.Font.Size = 22;
x.Cells[1, 1] = "BẢNG KIỂM KÊ, ĐÁNH GIÁ TÀI SẢN NĂM 2015";
x = xlWorkSheet.Range["C5:C5"];
x.Merge();
xlWorkSheet.Cells[5, 3].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
x.Font.Bold = true;
x.Font.Size = 16;
x.Cells[1, 1] = "SỔ THEO DÕI TÀI SẢN CỐ ĐỊNH VÀ CÔNG CỤ, DỤNG CỤ, VRTMH TẠI NƠI SỬ DỤNG";
xlWorkSheet.Cells[begini + 3, 2] = " - Gồm : */ Thiết bị : ................mục ; */ Đồ gỗ, VRTNH :.............mục ";
xlWorkSheet.Cells[begini + 3, 2].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
xlWorkSheet.Cells[begini + 4, 2] = " - Sổ này có ..................trang, đánh số từ trang 01 đến ...........";
xlWorkSheet.Cells[begini + 4, 2].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
xlWorkSheet.Cells[begini + 5, 2] = " - Ngày mở sổ:.......................";
xlWorkSheet.Cells[begini + 5, 2].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
xlWorkSheet.Cells[begini + 6, 3] = "Hiệu trưởng";
xlWorkSheet.Cells[begini + 6, 3].Font.Bold = true;
xlWorkSheet.Cells[begini + 6, 5] = "Kế toán tài sản";
xlWorkSheet.Cells[begini + 6, 5].Font.Bold = true;
xlWorkSheet.Cells[begini + 5, beginj + 14] = "Đà Nẵng, ngày tháng năm";
xlWorkSheet.Cells[begini + 6, beginj + 14] = "Người ghi sổ";
xlWorkSheet.Cells[begini + 6, beginj + 14].Font.Bold = true;
Marshal.ReleaseComObject(xlWorkSheet);
}
xlWorkBook.SaveAs(fullpath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(0);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
tbStatusBar.Text = "Working normally";
}
private void editCTG(CHUNGTUGIAM myCTG, int SoLuongCu)
{
bll.SuaCTG(myCTG, SoLuongCu);
showCTG();
}
// Xong xử lý click Cell
//Xử lý TAB CTG
private void addCTG(CHUNGTUGIAM myCTG)
{
bll.AddCTG(myCTG);
showCTG();
}