private void lbl_matruyen_TextChanged(object sender, EventArgs e)
{
var dt = ExecSQL.ExecProcedureDataFirstOrDefaultAsync <TenTruyen>("pro_get_tentruyen", new { option = 2, matruyen = lbl_matruyen.Text });
if (dt == null)
{
return;
}
lbl_tuatruyen.Text = dt.tuatruyen;
lbl_tentruyen.Text = dt.tentruyen;
lbl_hinhthuc.Text = dt.loaibia;
lbl_ngayxuatban.Text = dt.ngayxuatban.ToString();
lbl_loaitruyen.Text = dt.loaitruyen;
lbl_tacgia.Text = dt.tacgia;
lbl_tap.Text = dt.tap.ToString();
lbl_nhaxuatban.Text = dt.nhaxuatban;
lbl_xuatxu.Text = dt.quocgia;
string strNewDirPath = Application.StartupPath + "\\img\\origin\\" + lbl_matua.Text + "\\" + lbl_matruyen.Text + ".jpg";
if (File.Exists(strNewDirPath))
{
pictureEdit1.Image = ReadImageToStream(strNewDirPath);
}
else
{
pictureEdit1.Image = Image.FromFile(Application.StartupPath + "\\img\\origin\\default.jpg");
}
}
private void OnUploadProgress(IUploadProgress progress, int rowHanle, int maxByte)
{
switch (progress.Status)
{
case UploadStatus.Starting:
progressBarControl3.Properties.Minimum = 0;
progressBarControl3.EditValue = 0;
break;
case UploadStatus.Completed:
progressBarControl3.BeginInvoke(new Action(() =>
{
UpdateProgressByRowHandle(rowHanle, "progress", "100");
UpdateProgressByRowHandle(rowHanle, "uploadfile", "Đã upload");
_matruyen = grvViewDanhMuc.GetRowCellValue(rowHanle, "matruyen").ToString();
ExecSQL.ExecQueryNonData($"UPDATE dbo.tbl_tentruyen SET fileid=N'Đã hoàn tất' WHERE matruyen='{_matruyen}'");
progressBarControl3.EditValue = progressBarControl3.Properties.Maximum;
progressBarControl3.Visible = false;
lbl_upload.Visible = false;
}));
break;
case UploadStatus.Uploading:
var percent = Convert.ToDouble(progress.BytesSent) / Convert.ToDouble(maxByte) * 100.0;
UpdateProgressByRowHandle(rowHanle, "progress", Convert.ToInt16(percent).ToString());
UpdateProgressBar(progress.BytesSent);
break;
case UploadStatus.Failed:
XtraMessageBox.Show("Upload failed" + Environment.NewLine + progress.Exception);
break;
}
}
private void btn_luu_ItemClick(object sender, ItemClickEventArgs e)
{
grvViewDanhMuc.PostEditor();
if (modifined.Count == 0)
{
Form1.Default.ShowMessageDefault("Không có dòng dữ liệu nào thay đổi.");
return;
}
var dgr = HelperMessage.Instance.ShowMessageYesNo("Bạn có muốn lưu lại những thông tin thay đổi này không?", "Xác Nhận", SystemIcons.Question.ToBitmap());
if (dgr != DialogResult.Yes)
{
return;
}
int dem = 0;
foreach (var item in modifined)
{
var tentruyen = grvViewDanhMuc.GetRow(item) as TenTruyen;
if (tentruyen != null)
{
ExecSQL.ExecProcedureNonData("pro_update_tentruyen", new { tentruyen.matruyen, tentruyen.tentruyen, tentruyen.maloaibia, tentruyen.madvt, tentruyen.tap, tentruyen.giabia, tentruyen.ngayxuatban, tentruyen.ghichu, tentruyen.nguoitd2, tentruyen.sotrang, tentruyen.maquatang });
dem += 1;
}
}
modifined.Clear();
//GetDanhMuc();
Form1.Default.ShowMessageSuccess($"Đã cập nhật thành công {dem} dòng.");
}
public async void UploadFilePdf(string tuatruyen, int rowHandle)
{
// Create Drive API service.
var service = new DriveService(new BaseClientService.Initializer
{
HttpClientInitializer = credential,
ApplicationName = ApplicationName
});
//Folder đã được tạo
string folderid;
if (Convert.ToInt32(ExecSQL.ExecQuerySacalar($"SELECT COUNT(*) FROM dbo.tbl_tuatruyen WHERE tuatruyen=N'{tuatruyen}' AND LEN(folderid)>0")) > 0)
{
folderid = ExecSQL.ExecQuerySacalar($"SELECT folderid FROM dbo.tbl_tuatruyen WHERE tuatruyen=N'{tuatruyen}'").ToString();
}
else
{
//get folder id by name
var fileMetadatas = new Google.Apis.Drive.v3.Data.File
{
Name = tuatruyen,
MimeType = "application/vnd.google-apps.folder"
};
//Lây ID từ google trả về
var requests = service.Files.Create(fileMetadatas);
requests.Fields = "id";
var folder = requests.Execute();
//Update lại folder id
ExecSQL.ExecQueryNonData($"UPDATE dbo.tbl_tuatruyen SET folderid='{folder.Id}' WHERE tuatruyen=N'{tuatruyen}'");
folderid = folder.Id;
}
await UploadImage(ComicPro.StrDuongDanPdf, service, folderid, rowHandle);
}
private void btn_Luu_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_donvi.Text))
{
Form1.Default.ShowMessageWarning("Bạn phải nhập vào tên đơn vị.");
txt_donvi.Focus(); return;
}
if (string.IsNullOrEmpty(txt_donvi.Text))
{
Form1.Default.ShowMessageWarning("Bạn phải nhập nhóm đơn vị.");
cbo_nhomdonvi.Focus(); return;
}
var donvi = new DonVi {
madonvi = txt_madonvi.Text, donvi = txt_donvi.Text, manhom = Convert.ToInt32(cbo_nhomdonvi.EditValue), diachi = txt_diachi.Text, sodt = txt_sodt.Text, sofax = txt_sofax.Text, email = txt_email.Text, ghichu = txt_ghichu.Text, nguoitd = ComicPro.StrTenDangNhap.ToUpper()
};
ExecSQL.Insert(donvi);
Form1.Default.ShowMessageSuccess($"Đã thêm mới đơn vị ({txt_donvi.Text}) thành công.");
XoaText();
//Gửi dữ liệu
var message = new MessageBroker
{
data = DateTime.Now.ToString(CultureInfo.InvariantCulture),
task = "donvi"
};
message.Publish();
}
private async void UserLoaiTruyen_Load(object sender, EventArgs e)
{
var tong = ExecSQL.ExecQuerySacalar("SELECT COUNT(DISTINCT matruyen) AS tong FROM dbo.tbl_ct_phieunhapxuat WHERE slnhap>0");
Text = @"Loại truyện: " + tong + @" cuốn";
var chartControl1 = new ChartControl();
chartControl1.Dock = DockStyle.Fill;
panelControl.Controls.Add(chartControl1);
var dataTable = await ExecSQL.ExecProcedureDataAsyncAsDataTable("pro_get_tongso_loaitruyen");
await Task.Factory.StartNew(new Action(() =>
{
chartControl1.DataSource = dataTable;
chartControl1.BeginInvoke(new Action(() =>
{
Series seriesloaitruyen = new Series("Loại truyện", ViewType.Bar);
seriesloaitruyen.LabelsVisibility = DefaultBoolean.True;
// Add points to them, with their arguments different.
foreach (DataRow dr in dataTable.Rows)
{
seriesloaitruyen.Points.Add(new SeriesPoint(dr["loaitruyen"], dr["soluong"]));
}
chartControl1.Series.AddRange(new Series[] { seriesloaitruyen });
chartControl1.Legend.Visibility = DefaultBoolean.True;
Legend legend = chartControl1.Legend;
legend.Margins.All = 8;
legend.AlignmentHorizontal = LegendAlignmentHorizontal.Right;
legend.AlignmentVertical = LegendAlignmentVertical.Top;
legend.Direction = LegendDirection.LeftToRight;
}));
}));
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(ExecSQL.ExecQuerySacalar($"SELECT COUNT(*) FROM dbo.tbl_user WHERE tendangnhap='{txt_tendangnhap.Text.ToUpper()}' AND matkhau=CONVERT(VARCHAR(32), HashBytes('MD5', '{txt_matkhau.Text}'), 2)")) > 0)
{
ComicPro.StrTenDangNhap = txt_tendangnhap.Text.ToUpper();
//Gửi dữ liệu load form chính
IsLogin = "******";
Username = txt_tendangnhap.Text.Trim();
DialogResult = DialogResult.OK;
if (chkGhiNho.Checked)
{
ConfigAppSetting.SetSetting("UserName", txt_tendangnhap.Text);
ConfigAppSetting.SetSetting("Password", txt_matkhau.Text);
ConfigAppSetting.SetSetting("GhiNho", "True");
}
Close();
}
else
{
txt_tendangnhap.Text = "";
txt_matkhau.Text = "";
txt_tendangnhap.Focus();
XtraMessageBox.Show("Đăng nhập không thành công.", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public async void GetLayout(string matua)
{
string strDuongDan = Application.StartupPath + "\\img\\origin\\";
DataTable dt = await ExecSQL.ExecProcedureDataAsyncAsDataTable("pro_get_tonkho", new { option = 3, thang = Convert.ToDateTime(txt_tungay.EditValue).Month, nam = Convert.ToDateTime(txt_tungay.EditValue).Year, duongdanhinh = strDuongDan, matua });
BindingList <PictureObject> list = new BindingList <PictureObject>();
PictureObject item;
object b = new object();
await System.Threading.Tasks.Task.Factory.StartNew(() =>
{
foreach (DataRow drow in dt.Rows)
{
lock (b)
{
BeginInvoke(new Action(() =>
{
if (File.Exists(drow["hinhanh"].ToString()))
{
item = new PictureObject(drow["tentruyen"].ToString(), Image.FromFile(drow["hinhanh"].ToString()), drow["tuatruyen"].ToString());
}
else
{
item = new PictureObject(drow["tentruyen"].ToString(), Image.FromFile(strDuongDan + "no-image.png"), drow["tuatruyen"].ToString());
}
list.Add(item);
}));
}
}
});
dgv_Layout.DataSource = list;
}
private void btn_Luu_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_makho.Text))
{
Form1.Default.ShowMessageWarning("Bạn phải nhập vào mã kho.");
txt_makho.Focus(); return;
}
if (string.IsNullOrEmpty(txt_tenkho.Text))
{
Form1.Default.ShowMessageWarning("Bạn phải nhập vào tên kho.");
txt_tenkho.Focus(); return;
}
if (Convert.ToInt32(ExecSQL.ExecQuerySacalar($"SELECT COUNT(*) FROM dbo.tbl_kho WHERE makho='{txt_makho.Text}'")) > 0)
{
Form1.Default.ShowMessageError("Mã kho này đã tồn tại.");
txt_makho.Focus(); return;
}
var kho = new Kho {
makho = txt_makho.Text, tenkho = txt_tenkho.Text, nguoitd = ComicPro.StrTenDangNhap.ToUpper()
};
ExecSQL.Insert(kho);
XoaText();
//Gửi dữ liệu
var message = new MessageBroker
{
data = DateTime.Now.ToString(CultureInfo.InvariantCulture),
task = "kho"
};
message.Publish();
}
public async void GetLayout()
{
string strDuongDan = Application.StartupPath + @"/img/origin/";
DataTable dt = await ExecSQL.ExecProcedureDataAsyncAsDataTable("pro_get_tuatruyen_hinhanh", new { duongdanhinh = strDuongDan });
BindingList <PictureObject> list = new BindingList <PictureObject>();
PictureObject item;
object b = new object();
//await Task.Factory.StartNew(() =>
// {
foreach (DataRow drow in dt.Rows)
{
lock (b)
{
BeginInvoke(new Action(() =>
{
if (File.Exists(drow["hinhanh"].ToString()))
{
item = new PictureObject(Image.FromFile(drow["hinhanh"].ToString()), drow["tentruyen"].ToString(), drow["tuatruyen"].ToString());
// item = new PictureObject(drow["hinhanh"].ToString(), drow["tentruyen"].ToString(), drow["tuatruyen"].ToString());
}
else
{
item = new PictureObject(Image.FromFile(strDuongDan + "no-image.png"), drow["tentruyen"].ToString(), drow["tuatruyen"].ToString());
}
list.Add(item);
}));
}
}
//});
gridControl1.DataSource = list;
}
void Send(TickPosition _tp)
{
ExecSQL E = new ExecSQL(string.Format("insert into TickPositions values({0},{1},{2})",
tp_index++.ToString(),
Convert.ToInt32(Math.Round(_tp.tick)).ToString(),
_tp.position.ToString()));
}
private void btn_luu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
gridView1.PostEditor();
if (modifined.Count == 0)
{
Form1.Default.ShowMessageDefault("Không có dòng dữ liệu nào thay đổi.");
return;
}
var dgr = HelperMessage.Instance.ShowMessageYesNo($"Bạn có muốn lưu lại những thông tin thay đổi này không?", "Xác Nhận", SystemIcons.Question.ToBitmap());
if (dgr != DialogResult.Yes)
{
return;
}
int dem = 0;
foreach (var item in modifined)
{
var nxb = gridView1.GetRow(item) as NXB;
if (nxb != null)
{
nxb.nguoitd2 = ComicPro.StrTenDangNhap.ToUpper();
nxb.thoigian2 = DateTime.Now;
ExecSQL.Update(nxb);
dem += 1;
}
}
GetNxb();
modifined.Clear();
Form1.Default.ShowMessageSuccess($"Đã cập nhật thành công {dem} dòng.");
}
public async void GetQuocGia()
{
var dt = await ExecSQL.ExecQueryDataAsync <QuocGia>("SELECT id, quocgia FROM dbo.tbl_quocgia ORDER BY quocgia");
cbo_quocgia.Properties.DataSource = dt;
cbo_quocgia.Properties.DisplayMember = "quocgia";
cbo_quocgia.Properties.ValueMember = "id";
}
public async void GetLoaiTruyen()
{
var dt = await ExecSQL.ExecQueryDataAsync <LoaiTruyen>("SELECT maloai, loaitruyen FROM dbo.tbl_loaitruyen ORDER BY loaitruyen");
cbo_loaitruyen.Properties.DataSource = dt;
cbo_loaitruyen.Properties.DisplayMember = "loaitruyen";
cbo_loaitruyen.Properties.ValueMember = "maloai";
}
private void cbo_loaitruyen_EditValueChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbo_loaitruyen.Text))
{
return;
}
txt_matua.Text = ExecSQL.ExecProcedureSacalar("pro_taomatuatruyen", new { maloai = cbo_loaitruyen.EditValue.ToString() }).ToString();
}
public async void GetTuaTruyen()
{
var dt = await ExecSQL.ExecQueryDataAsyncAsDataTable("SELECT DISTINCT a.matua, b.tuatruyen FROM dbo.tbl_tentruyen a INNER JOIN dbo.tbl_tuatruyen b ON b.matua = a.matua WHERE a.filetruyen=1 ORDER BY b.tuatruyen");
cbo_tuatruyen.Properties.DataSource = dt;
cbo_tuatruyen.Properties.ValueMember = "matua";
cbo_tuatruyen.Properties.DisplayMember = "tuatruyen";
}
private void txt_tap_TextChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbo_tuatruyen.Text) || string.IsNullOrEmpty(txt_tap.Text))
{
return;
}
txt_matruyen.Text = ExecSQL.ExecQuerySacalar($"SELECT CONCAT('{cbo_tuatruyen.EditValue}.',FORMAT({Convert.ToInt32(txt_tap.Text)},'000'))").ToString();
}
public async void GetTenTruyen()
{
var listTenTruyen = await ExecSQL.ExecProcedureDataAsync <TenTruyen>("pro_get_tentruyen", new { option = 1 });
cbo_tentruyen.DataSource = listTenTruyen;
cbo_tentruyen.DisplayMember = "matruyen";
cbo_tentruyen.ValueMember = "matruyen";
}
public void GetDonVi()
{
var dt = ExecSQL.ExecProcedureData <DonVi>("pro_get_donvi", new { option = 2 });
cbo_donvi.Properties.DataSource = dt;
cbo_donvi.Properties.DisplayMember = "madonvi";
cbo_donvi.Properties.ValueMember = "madonvi";
}
public async void GetTacGia()
{
var listTacGia = await ExecSQL.ExecQueryDataAsync <TacGia>("SELECT matacgia, tacgia FROM dbo.tbl_tacgia ORDER BY tacgia");
cbo_tacgia2.DataSource = listTacGia;
cbo_tacgia2.DisplayMember = "tacgia";
cbo_tacgia2.ValueMember = "matacgia";
}
public async void GetLoaiBia()
{
var listLoaiBia = await ExecSQL.ExecQueryDataAsync <LoaiBia>("SELECT id, loaibia FROM dbo.tbl_loaibia");
cbo_loaibia.Properties.DataSource = listLoaiBia;
cbo_loaibia.Properties.DisplayMember = "loaibia";
cbo_loaibia.Properties.ValueMember = "id";
}
public async void GetDonViTinh()
{
var listDonViTinh = await ExecSQL.ExecQueryDataAsync <DonViTinh>("SELECT id, donvitinh FROM dbo.tbl_donvitinh");
cbo_donvitinh.DataSource = listDonViTinh;
cbo_donvitinh.DisplayMember = "donvitinh";
cbo_donvitinh.ValueMember = "id";
}
public async void GetNhaXuatBan()
{
var dt = await ExecSQL.ExecQueryDataAsync <NXB>("SELECT manxb, nhaxuatban FROM dbo.tbl_nhaxuatban ORDER BY nhaxuatban");
cbo_nhaxuatban.Properties.DataSource = dt;
cbo_nhaxuatban.Properties.DisplayMember = "nhaxuatban";
cbo_nhaxuatban.Properties.ValueMember = "manxb";
}
public async void GetQuaTang()
{
var lstQuaTang = await ExecSQL.ExecQueryDataAsync <QuaTang>("SELECT maquatang, quatang FROM dbo.tbl_quatang ORDER BY quatang");
cboQuaTang.Properties.DataSource = lstQuaTang;
cboQuaTang.Properties.DisplayMember = "quatang";
cboQuaTang.Properties.ValueMember = "maquatang";
}
public void GetKho()
{
var listKho = ExecSQL.ExecQueryData <Kho>("SELECT makho, tenkho FROM dbo.tbl_kho ORDER BY tenkho");
cbo_kho.Properties.DataSource = listKho;
cbo_kho.Properties.DisplayMember = "tenkho";
cbo_kho.Properties.ValueMember = "makho";
}
public async void GetNhomDonVi()
{
var dt = await ExecSQL.ExecQueryDataAsync <NhomDonVi>("SELECT id, nhomdonvi FROM dbo.tbl_nhomdonvi");
cbo_nhomdonvi.Properties.DataSource = dt;
cbo_nhomdonvi.Properties.DisplayMember = "nhomdonvi";
cbo_nhomdonvi.Properties.ValueMember = "id";
}
public async void GetTuaTruyen2()
{
var listTuaTruyen = await ExecSQL.ExecQueryDataAsync <TuaTruyen>("SELECT matua, tuatruyen FROM dbo.tbl_tuatruyen ORDER BY tuatruyen");
cbo_tua2.DataSource = listTuaTruyen;
cbo_tua2.DisplayMember = "tuatruyen";
cbo_tua2.ValueMember = "matua";
}
public async void GetTacGia()
{
var listTacGia = await ExecSQL.ExecQueryDataAsync <TacGia>("SELECT matacgia, tacgia FROM dbo.tbl_tacgia ORDER BY tacgia");
cbo_tacgia.Properties.DataSource = listTacGia;
cbo_tacgia.Properties.DisplayMember = "tacgia";
cbo_tacgia.Properties.ValueMember = "matacgia";
cbo_tacgia.EditValue = ComicPro.StrMaTacGia;
}
public void XoaText()
{
txt_manxb.Text = ExecSQL.ExecQuerySacalar("SELECT CONCAT('NXB', FORMAT(ISNULL(RIGHT(MAX(manxb),3),0)+1,'000')) FROM dbo.tbl_nhaxuatban").ToString();
txt_nhaxuatban.Text = "";
txt_diachi.Text = "";
txt_sodt.Text = "";
txt_sofax.Text = "";
txt_manxb.Focus();
}
public void GetLoaiPhieu()
{
var listLoaiPhieu = ExecSQL.ExecQueryData <LoaiPhieu>("SELECT id, loaiphieu FROM dbo.tbl_loaiphieunhapxuat");
cbo_loaiphieu.Properties.DataSource = listLoaiPhieu;
cbo_loaiphieu.Properties.DisplayMember = "loaiphieu";
cbo_loaiphieu.Properties.ValueMember = "id";
cbo_loaiphieu.EditValue = 2;
}
