private void btnDeleteAll_Click(object sender, EventArgs e)
{
if (DialogResult.No == XtraMessageBox.Show("Bạn có muốn xóa toàn bộ sản phẩm không? Nhấn Yes để thực hiện!", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
try
{
btnXoaAll.Enabled = false;
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_DeleteAllProduct";
var json = API.API_GET(sLink);
dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
var Result = jsondataChild.First.GetValue("Result").Value;
var Message = jsondataChild.First.GetValue("Message").Value;
if (Result == 1)//Login thành công
{
XtraMessageBox.Show(Message, "Thông Báo");
LoadInfoProduct();
}
else
{
XtraMessageBox.Show("Xóa Dữ Liệu KHông Thành Công", "Thông Báo");
}
btnXoaAll.Enabled = true;
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Product", "btnDeleteAll_Click", ex.ToString()));
}
}
private void TaoMoi()
{
try
{
IDGroup = "0";
ProductGroupHeader ob = new ProductGroupHeader();
ob.ProductGroupName = txtTenNhom.Text;
ob.CreateBy = Form_Main.user.Username;
if (listHeader == null)
{
listHeader = new List <ProductGroupHeader>();
}
listHeader.Add(ob);
dgc_Main.DataSource = listHeader;
dgv_Main.RefreshData();
dgv_Main.BestFitColumns(true);
ProductGroupDetails obd = new ProductGroupDetails();
listdetails = new List <ProductGroupDetails>();
obd.SoLuong = 1;
listdetails.Add(obd);
dgcDetails.DataSource = listdetails;
dgvDetails.RefreshData();
dgvDetails.BestFitColumns(true);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Login", "TaoMoi()", ex.ToString()));
}
}
private void dgv_Other_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
try
{
int focus = dgv_Other.FocusedRowHandle;
if (focus >= 0)
{
string name = dgv_Other.FocusedColumn.FieldName;
if (name != "ID" && name != "ThanhToan")
{
DataRow result = table_Part_Profit_Other.AsEnumerable().Where(p => p.Field <string>("Key") == name).FirstOrDefault();
if (result != null)
{
txtMin_Other.EditValue = result["Minimum"];
txtMax_Other.EditValue = result["Maximum"];
ID_Part_Profit_Other = result["ID"].ToString();
ID_DayOfLate_Other = dgv_Other.GetDataRow(focus)["ID"].ToString();
txt_HoaHong_Other.EditValue = dgv_Other.GetDataRow(focus)[name];
txt_MaxLateDay_Other.EditValue = dgv_Other.GetDataRow(focus)["MaxDay"];
txt_MinLateDay_Other.EditValue = dgv_Other.GetDataRow(focus)["MinDay"];
}
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Commission", "dgv_Other_RowClick()", ex.ToString()));
}
}
private void dgc_Main_ViewRegistered(object sender, DevExpress.XtraGrid.ViewOperationEventArgs e)
{
try
{
GridView view = e.View as GridView;
view.OptionsView.ShowViewCaption = true;
view.ViewCaption = "Thông Tin Chi Tiết Báo Giá";
view.Columns["SoLuong"].Caption = "Số Lượng";
view.Columns["MaSP"].Caption = "Mã Sản Phẩm";
view.Columns["TenHang"].Caption = "Tên Sản Phẩm";
view.Columns["TenHang"].AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
view.Columns["MoTaHangHoa"].Caption = "Mô Tả Sản Phẩm";
view.Columns["MoTaHangHoa"].AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
view.Columns["DonGia"].Caption = "Đơn Giá";
view.Columns["DonGia"].DisplayFormat.FormatString = "n0";
view.Columns["DonGia"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
view.Columns["DonGia"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.Columns["ThanhTien"].Caption = "Thành Tiền";
view.Columns["ThanhTien"].DisplayFormat.FormatString = "n0";
view.Columns["ThanhTien"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
view.Columns["ThanhTien"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.OptionsDetail.ShowDetailTabs = false;
view.BestFitColumns(true);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_TimKiemBaoGia", "LoadDSBaoGia()", ex.ToString()));
}
}
private void XoaDuLieu(string MaSP)
{
try
{
string sql_Exect = string.Format("Exec sp_Product_Delete @ID ='{0}', @UserName='******'", MaSP, Form_Main.user.Username);
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sql_Exect;
var json = API.API_GET(sLink);
dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
var Result = jsondataChild.First.GetValue("Result").Value;
var Message = jsondataChild.First.GetValue("Message").Value;
if (Result == 1) //Login thành công
{
XtraMessageBox.Show(Message, "Thông Báo");
LoadInfoProduct();
}
else
{
XtraMessageBox.Show(Message, "Thông Báo");
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Product", "XoaDuLieu()", ex.ToString()));
}
}
private void XoaBaoGia()
{
DialogResult result = XtraMessageBox.Show("Bạn Có muốn Xóa Báo Giá này không?", "Thông Báo", MessageBoxButtons.YesNo);
if (result == DialogResult.No)
{
return;
}
try
{
// Create an empty list.
int focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
InfoCustomer dr = (InfoCustomer)dgv_Main.GetFocusedRow();
if (dr != null)
{
listob.Remove(dr);
// dgc_Main.DataSource = listob;
dgv_Main.RefreshData();
// Xóa data
string sql_Exect = string.Format("Exec sp_Quote_Delete " +
"@ID={0}", dr.ID); //11
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sql_Exect;
var json = API.API_GET(sLink);
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_TimKiemBaoGia", "XoaBaoGia()", ex.ToString()));
}
}
private void txtDeposit_TextChanged(object sender, EventArgs e)
{
try
{
decimal deposit = 0;
decimal.TryParse(txtDeposit.EditValue.ToString(), out deposit);
decimal money = 0;
if (txtSum_Price.EditValue != null)
{
decimal.TryParse(txtSum_Price.EditValue.ToString(), out money);
}
if (deposit < 0 || deposit > money)
{
dxErrorProvider1.SetError(txtDeposit, "số tiền đặt cọc phải lớn hơn 0 và không quá số tiền đơn hàng");
Check_Save = false;
}
else
{
txt_Remainder.EditValue = money - deposit;
dxErrorProvider1.SetError(txtDeposit, null);
Check_Save = true;
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Manage_Order", "txtDeposit_EditValueChanged()", ex.ToString()));
}
}
private void LoadThongTinDefault()
{
try
{
txtTenCty.Text = Form_Main.info.TenCongTy;
txtNguoiGui.Text = Form_Main.info.NguoiGui;
txtMobile.Text = Form_Main.info.Mobile;
txtEmail.Text = Form_Main.info.Email;
txtDiaChi.Text = Form_Main.info.DiaChi;
string FilePaht = AppDomain.CurrentDomain.BaseDirectory + "/AppData/Image/ImageLeft.jpg";
if (File.Exists(FilePaht))
{
using (FileStream stream = new FileStream(FilePaht, FileMode.Open, FileAccess.Read))
{
ptbHinhTrai.Image = Image.FromStream(stream);
}
}
FilePaht = AppDomain.CurrentDomain.BaseDirectory + "/AppData/Image/ImageRight.jpg";
if (File.Exists(FilePaht))
{
using (FileStream stream = new FileStream(FilePaht, FileMode.Open, FileAccess.Read))
{
ptbHinhPhai.Image = Image.FromStream(stream);
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_MasterData", "LoadThongTinDefault()", ex.ToString()));
}
}
private void btn_SearchIfo_Click(object sender, EventArgs e)
{
try
{
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("p_FromDate", dte_FromDate.Text == "" ? "" : dte_FromDate.DateTime.ToString("dd/MM/yyyy")); //0
param.Add("p_ToDate", dte_ToDate.Text == "" ? "" : dte_ToDate.DateTime.ToString("dd/MM/yyyy")); //0
param.Add("UserName", slu_SearchUser.EditValue.ToString()); //2
param.Add("UserID", Form_Main.user.Username); //3
DataSet ds = new DataSet();
ds = SQLHelper.ExecuteDataSetUndefine("sp_Get_Commission_Of_Employees", param);
DataTable dt = new DataTable();
if (ds != null && ds.Tables.Count == 2)
{
dt = ds.Tables[0];
}
dgc_Main.DataSource = dt;
dt = ds.Tables[1];
for (int i = 0; i < dt.Rows.Count; i++)
{
string colname = dt.Rows[i][0].ToString();
if (colname != null && colname != "")
{
dgv_Main.Columns[colname].Visible = true;
}
}
dgv_Main.BestFitColumns(true);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_CommissonOfElp", "btn_SearchIfo_Click()", ex.ToString()));
}
}
private void sp_Cancel_Order()
{
try
{
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("IDOrder", IDOrder); //0
param.Add("UserID", Form_Main.user.Username); //2
DataTable dt = new DataTable();
dt = SQLHelper.ExecuteDataTableUndefine("sp_Cancel_Order", param);
if (dt != null && dt.Rows.Count > 0)
{
var Result = dt.Rows[0]["Result"].ToString();
var Message = dt.Rows[0]["Message"].ToString();
XtraMessageBox.Show(Message, "Thông Báo");
}
else
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Manage_Order", "sp_Cancel_Order()", "Không có dữ liệu trả về!"));
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Manage_Order", "sp_Cancel_Order()", ex.ToString()));
}
}
private void SaveInfo()
{
try
{
InfoIPC ipc = new InfoIPC();
ipc.TenCongTy = txtTenCty.Text;
ipc.NguoiGui = txtNguoiGui.Text;
ipc.Mobile = txtMobile.Text;
ipc.Email = txtEmail.Text;
ipc.DiaChi = txtDiaChi.Text;
var jsonsave = new JavaScriptSerializer().Serialize(ipc);
string base64info = Convert.ToBase64String(Encoding.UTF8.GetBytes(jsonsave.ToString()));
string str = "[" + string.Format(@"{{""Key"":""Key"",""value"":""{0}"",""Type"":""string""}},{{""Key"":""Value"",""value"":""{1}"",""Type"":""string""}},{{""Key"":""UserID"",""value"":""{2}"",""Type"":""string""}}", "Info", base64info, Form_Main.user.Username) + "]";
var json = new JavaScriptSerializer().Serialize(new { StoreProcedure = "sp_UpdateInfoMaster", Param = str });
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_SaveQuote";
json = API.API_POS(sLink, json);
dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
var Result = jsondataChild.First.GetValue("Result").Value;
var Message = jsondataChild.First.GetValue("Message").Value;
XtraMessageBox.Show(Message, "Thông Báo", System.Windows.Forms.MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_MasterData", "SaveInfo()", ex.ToString()));
XtraMessageBox.Show("Cập Nhật Thông Tin Không Thành Công", "Thông Báo", System.Windows.Forms.MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Get_Push_Notify_Tick(object sender, EventArgs e)
{
try
{
string sql_Exect = string.Format("Exec sp_Get_Notify @UserName='******'", Form_Main.user.Username);
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sql_Exect;
var json = API.API_GET_Rep(sLink);
var jsondata = JObject.Parse(json).GetValue("Data");
DataTable dt = (DataTable)JsonConvert.DeserializeObject(jsondata.ToString(), (typeof(DataTable)));
for (int i = 0; i < dt.Rows.Count; i++)
{
string Caption = dt.Rows[i]["Caption"].ToString();
string Body = dt.Rows[i]["Body"].ToString();
int AutoFormDelay;
int.TryParse(dt.Rows[i]["AutoFormDelay"].ToString(), out AutoFormDelay);
alertControl1.AutoFormDelay = AutoFormDelay;
alertControl1.Show(this, Caption, Body, "", Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "/AppData/Image/switchtimescalesto_32x32.png"), null);
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Main", "Get_Push_Notify_Tick()", ex.ToString()));
}
}
private void dgv_Main_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
try
{
int focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
bool mini = false;
bool maxi = false;
bool.TryParse(dgv_Main.GetDataRow(focus)["IsEqualMinimum"].ToString(), out mini);
bool.TryParse(dgv_Main.GetDataRow(focus)["IsEqualMaximum"].ToString(), out maxi);
lblDoanhSo.Text = string.Format("{0} DS {1}", mini ? "<=" : "<", maxi ? "<=" : "");
chk_Minimum.Checked = mini;
chk_Maximum.Checked = maxi;
txtMinimum.EditValue = dgv_Main.GetDataRow(focus)["Minimun"];
txtMaximum.EditValue = dgv_Main.GetDataRow(focus)["Maximum"];
txtLuongTheoDS.EditValue = dgv_Main.GetDataRow(focus)["LuongTheoDS"];
ID = dgv_Main.GetDataRow(focus)["ID"].ToString();
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "MasterData_Commission", "dgv_Main_RowClick()", ex.ToString()));
}
}
private void dgv_Main_RowClick(object sender, RowClickEventArgs e)
{
try
{
int focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
IDCompany = dgv_Main.GetDataRow(focus)["ID"].ToString();
txtTenCongTy.Text = dgv_Main.GetDataRow(focus)["CompanyName"].ToString();
txtDiaChi.Text = dgv_Main.GetDataRow(focus)["Address"].ToString();
txtMoTa.Text = dgv_Main.GetDataRow(focus)["Description"].ToString();
cbbTrangThai.EditValue = dgv_Main.GetDataRow(focus)["Status"].ToString();
}
else
{
IDCompany = "";
txtTenCongTy.Text = "";
txtDiaChi.Text = "";
txtMoTa.Text = "";
cbbTrangThai.EditValue = 1;
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_DoanhNghiep", "dgv_Main_RowClick()", ex.ToString()));
IDCompany = "";
txtTenCongTy.Text = "";
txtDiaChi.Text = "";
txtMoTa.Text = "";
cbbTrangThai.EditValue = 1;
}
}
private void btnHuyBo_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == XtraMessageBox.Show("Thay đổi của bạn sẽ ảnh hưởng đến thưởng của nhân viên? Bạn có chắc đây là điều bạn muốn", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("ID", ID); //0
param.Add("UserID", Form_Main.user.Username); //0
DataTable dt = new DataTable();
dt = SQLHelper.ExecuteDataTableUndefine("sp_Delete_Masster_Commission", param);
if (dt != null && dt.Rows.Count > 0)
{
string Result = dt.Rows[0]["Result"].ToString();
string Message = dt.Rows[0]["Message"].ToString();
XtraMessageBox.Show(Message, "Thông Báo");
if (Result == "1")//Login thành công
{
LoadMasterData();
}
}
else
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "MasterData_Commission", "btnHuyBo_Click()", "Không có kết quả trả về"));
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "MasterData_Commission", "btnHuyBo_Click()", ex.ToString()));
}
}
void HuyTaiKhoan()
{
try
{
string sql_Exect = string.Format("Exec sp_HuyUser @ID ='{0}' ", ID);
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sql_Exect;
var json = API.API_GET(sLink);
dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
var Result = jsondataChild.First.GetValue("Result").Value;
var Message = jsondataChild.First.GetValue("Message").Value;
if (Result == 1)//Login thành công
{
XtraMessageBox.Show(Message, "Thông Báo");
}
else
{
XtraMessageBox.Show("Hủy Tài Khoản Không Thành Công", "Thông Báo");
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_NhomQuyen", "HuyTaiKhoan()", ex.ToString()));
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
try
{
InfoReportDetails ob = lst.Find(o => o.ID == ID);
if (ob != null)
{
ob.MaSP = txtMaSP.Text;
ob.TenHang = txtTenSanPham.Text;
ob.MoTaHangHoa = txtMoTa.Text;
// ob.ThanhTien = decimal.Parse(txtThanhTien.EditValue.ToString());
ob.ChietKhau = decimal.Parse(txtTienChietKhau.EditValue.ToString());
ob.DonGia = decimal.Parse(txtDonGia.EditValue.ToString());
ob.SoLuong = int.Parse(txtSoLuong.EditValue.ToString());
ob.Profit = decimal.Parse(txtProfit.EditValue.ToString());
ob.IsGroup = _IsGroup;
ob.Status = 1;
// ob.MoneyProfit = decimal.Parse(txtTienLoiNhuan.EditValue.ToString());
}
if (lst.Exists(o => o.Status == 0))
{
dgv_BaoGia.OptionsView.EnableAppearanceOddRow = false;
}
else
{
dgv_BaoGia.OptionsView.EnableAppearanceOddRow = true;
}
dgv_BaoGia.RefreshData();
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Quote", "btnCapNhat_Click", ex.ToString()));
}
}
private void txtCompany_EditValueChanged(object sender, EventArgs e)
{
try
{
int rowHandle = txtCustomer.Properties.GetIndexByKeyValue(txtCustomer.EditValue);
object row = txtCustomer.Properties.View.GetRow(rowHandle);
en = new Enquiry();
en.ID_Request = (row as DataRowView).Row["ID_Request"].ToString();
en.CompanyName = (row as DataRowView).Row["CompanyName"].ToString();
en.Description = (row as DataRowView).Row["Description"].ToString();
en.CardName = (row as DataRowView).Row["CardName"].ToString();
en.SDT = (row as DataRowView).Row["SDT"].ToString();
en.Email = (row as DataRowView).Row["Email"].ToString();
en.ID_Enquiry = (row as DataRowView).Row["ID_Enquiry"].ToString();
en.EnquiryName = (row as DataRowView).Row["EnquiryName"].ToString();
en.Curator = (row as DataRowView).Row["Curator"].ToString();
en.CuratorName = (row as DataRowView).Row["CuratorName"].ToString();
en.CompanyCode = (row as DataRowView).Row["Company"].ToString();
en.CardCode = (row as DataRowView).Row["CardCode"].ToString();
en.Address_Cus = (row as DataRowView).Row["Address_Cus"].ToString();
// Form_Add_Enquiry.en = en;
this.Close();
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Search_Enquiry", "txtCompany_EditValueChanged", ex.ToString()));
}
}
/// <summary>
/// Load Thông Tin Sản Phẩm
/// </summary>
private void LoadInfoProduct()
{
try
{
//string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByStore?sql_Exec=" + "sp_Get_Product_Select";
//var json = API.API_GET(sLink);
//var jsondata = JObject.Parse(json).GetValue("Data");
//var ds = JsonConvert.DeserializeObject<List<ProductSelect>>(jsondata.ToString());
DataTable dt = SQLHelper.ExecuteDataTable("sp_Get_Product_Select");
List <ProductSelect> listob = new List <ProductSelect>();
for (int i = 0; i < dt.Rows.Count; i++)
{
string ID = dt.Rows[i]["ID"].ToString();
string ProductCode = dt.Rows[i]["ProductCode"].ToString();;
string ProductName = dt.Rows[i]["ProductName"].ToString();;
string Description = dt.Rows[i]["Description"].ToString();;
decimal Price = decimal.Parse(dt.Rows[i]["Price"].ToString());
ProductSelect ob = new ProductSelect(ID, ProductCode, ProductName, Description, Price);
listob.Add(ob);
}
searchSanPham.DataSource = listob;
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_ProductGroup", "LoadInfoProduct()", ex.ToString()));
}
}
private void ShowInfo_CommissionOfProduct()
{
#region Xử Lý Hệ Số Tổng:
try
{
if (lst != null)
{
// decimal sumofCostPrice = 0;
decimal sumofPrice = 0;
// int Soluong = 0;
// int.TryParse(txtSoLuong.EditValue.ToString(), out Soluong);
decimal profit = 0;
decimal.TryParse(txtProfit.Text, out profit);
decimal.TryParse(txtThanhTien.EditValue.ToString(), out sumofPrice);
// sumofCostPrice = CostPrice* Soluong;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("Profit", profit); //0
param.Add("DayofLate", 0); //1
param.Add("Money", sumofPrice); //2
DataTable tablecommission = new DataTable();
tablecommission = SQLHelper.ExecuteDataTableUndefine("sp_Get_MasterData_Commission", param);
if (tablecommission != null && tablecommission.Rows.Count > 0)
{
lbl_ADV_JHC_Product.Text = string.Format("Adv/JHC: {0} đ", tablecommission.Rows[0]["Profit_MoneyAdv_JHC"]);
lbl_Other_Product.Text = string.Format("Hãng Khác: {0} đ", tablecommission.Rows[0]["Profit_MoneyOther"]);
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Quote", "btnAdd_Click_sp_Get_MasterData_Commission", ex.ToString()));
}
#endregion Xử Lý Hệ Số Tổng:
}
/// <summary>
/// lấy danh sách chi tiết nhóm sản phẩm
/// </summary>
private void LoadInfoProductDetails(string ListID)
{
try
{
string sqlQuery = string.Format("exec sp_ProductGroup_GetdataDetails @ID='{0}' ", ListID);
//string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sqlQuery;
//var json = API.API_GET(sLink);
//var jsondata = JObject.Parse(json).GetValue("Data");
//listdetails = JsonConvert.DeserializeObject<List<ProductGroupDetails>>(jsondata.ToString());
listdetails = new List <ProductGroupDetails>();
DataTable dt = SQLHelper.ExecuteDataTableByQuery(sqlQuery);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string ID = dt.Rows[i]["ID"].ToString();
string ProductCode = dt.Rows[i]["ProductCode"].ToString();
string ProductName = dt.Rows[i]["ProductName"].ToString();
decimal Price = decimal.Parse(dt.Rows[i]["Price"].ToString());
int SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString());
ProductGroupDetails ob = new ProductGroupDetails(ID, ProductCode, ProductName, Price, SoLuong);
listdetails.Add(ob);
}
}
dgcDetails.DataSource = listdetails;
dgvDetails.BestFitColumns(true);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_ProductGroup", "LoadInfoProductDetails()", ex.ToString()));
}
}
private void dgc_Main_Click(object sender, EventArgs e)
{
try
{
int focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
txtSumAllAmountOfElp.EditValue = dgv_Main.GetDataRow(focus)["SumAmount"];
decimal commissionAmount = 0;
decimal commissionProduct = 0;
decimal.TryParse(dgv_Main.GetDataRow(focus)["CommissionOfAmount"].ToString(), out commissionAmount);
decimal.TryParse(dgv_Main.GetDataRow(focus)["SumCommission"].ToString(), out commissionProduct);
txt_SumCommissionAmountOfElp.EditValue = commissionAmount;
txt_CommissionOfProductElp.EditValue = commissionProduct;
txt_SumAllCommissionOfElp.EditValue = commissionAmount + commissionProduct;
decimal commissionAmount_all = 0;
decimal commissionProduct_all = 0;
decimal.TryParse(dgv_Main.GetDataRow(focus)["CommissionOfAmountAll"].ToString(), out commissionAmount_all);
decimal.TryParse(dgv_Main.GetDataRow(focus)["SumCommissionAll"].ToString(), out commissionProduct_all);
txt_SumAllOrderOfDate.EditValue = dgv_Main.GetDataRow(focus)["SumAmountAll"];
txt_SumCommissionAmount.EditValue = commissionAmount_all;
txt_SumCommisionProduct.EditValue = commissionProduct_all;
txt_SumAllcommision.EditValue = commissionAmount_all + commissionProduct_all;
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_CommissonOfElp", "dgc_Main_Click()", ex.ToString()));
}
}
/// <summary>
/// xóa tay từng line
/// </summary>
private void DeleteDetails()
{
try
{
// Create an empty list.
int focus = dgvDetails.FocusedRowHandle;
if (focus >= 0)
{
ProductGroupDetails dr = (ProductGroupDetails)dgvDetails.GetFocusedRow();
if (dr != null)
{
listdetails.Remove(dr);
dgcDetails.DataSource = listdetails;
dgvDetails.RefreshData();
}
focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
dgv_Main.SetFocusedRowCellValue("TongTien", listdetails.Sum(o => o.ThanhTien));
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Login", "DeleteDetails()", ex.ToString()));
}
}
private void slu_Paystatus_EditValueChanged(object sender, EventArgs e)
{
try
{
if (slu_Paystatus.EditValue != null)
{
decimal Remainder = 0;
decimal.TryParse(txt_Remainder.EditValue.ToString(), out Remainder);
string paystatus = slu_Paystatus.EditValue.ToString();
if (paystatus == "F")
{
dte_PayOffDate.EditValue = DateTime.Now;
txt_Remainder.EditValue = 0;
}
else
{
txt_Remainder.EditValue = Remainder;
dte_PayOffDate.EditValue = null;
}
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Manage_Order", "slu_Paystatus_EditValueChanged()", ex.ToString()));
}
}
/// <summary>
/// Load Thông tin Nhóm Sản Phẩm
/// </summary>
private void LoadInfoProductGroup()
{
try
{
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByStore?sql_Exec=" + "sp_ProductGroup_Getdata";
var json = API.API_GET(sLink);
var jsondata = JObject.Parse(json).GetValue("Data");
DataTable dt = (DataTable)JsonConvert.DeserializeObject(jsondata.ToString(), (typeof(DataTable)));
listHeader = JsonConvert.DeserializeObject <List <ProductGroupHeader> >(jsondata.ToString());
dgc_Main.DataSource = listHeader;
if (listHeader == null || listHeader.Count == 0)
{
listdetails = new List <ProductGroupDetails>();
dgcDetails.DataSource = listdetails;
dgvDetails.RefreshData();
}
dgv_Main.BestFitColumns(true);
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_ProductGroup", "LoadInfoProductGroup()", ex.ToString()));
}
}
private void ptbHinhPhai_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.Title = "Open Image";
dlg.Filter = "Image files(*.jpg, *.jpeg, *.png) | *.jpg; *.jpeg; *.png";
if (dlg.ShowDialog() == DialogResult.OK)
{
Image img = Image.FromFile(dlg.FileName);
if (img.Width != 450 || img.Height != 100)
{
if (DialogResult.Cancel == XtraMessageBox.Show("File bạn chọn có kích thước không đúng với kích thước 450x100!", "Bạn có chắc muốn sử dụng hình này", MessageBoxButtons.OKCancel, MessageBoxIcon.Information))
{
return;
}
}
else
{
flag_Image2 = true;
ptbHinhPhai.Image = Image.FromFile(dlg.FileName);
}
}
dlg.Dispose();
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_MasterData", "ptbHinhPhai_Click", ex.ToString()));
XtraMessageBox.Show("File Bạn Chọn Không Đúng Format", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgv_Main_RowClick(object sender, RowClickEventArgs e)
{
try
{
int focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
txtNoiDung.Text = dgv_Main.GetDataRow(focus)["Description"].ToString();
txtTrangThai.EditValue = dgv_Main.GetDataRow(focus)["Status"];
txtPhuTrach.EditValue = dgv_Main.GetDataRow(focus)["Curator"];
IDDetail = dgv_Main.GetDataRow(focus)["ID"].ToString();
}
else
{
txtNoiDung.Text = "";
IDDetail = "0";
txtTrangThai.EditValue = null;
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_DoanhNghiep", "dgv_Main_RowClick()", ex.ToString()));
txtNoiDung.Text = "";
txtTrangThai.EditValue = null;
}
}
void SaveInfo()
{
try
{
bool flag_edit = false;
if (string.IsNullOrEmpty(txtTenCongTy.Text) || txtTenCongTy.Text.Length < 4)
{
dxErrorProvider1.SetError(txtTenCongTy, "Tên công ty ít nhất 4 ký tự");
flag_edit = true;
}
else
{
dxErrorProvider1.SetError(txtTenCongTy, null);
}
if (flag_edit)
{
XtraMessageBox.Show("Vui lòng bổ sung những thông tin còn trống", "Thông Báo");
return;
}
string str = "[" +
string.Format(@"
{{""Key"":""ID"",""value"":""{0}"",""Type"":""string""}},
{{""Key"":""CompanyName"",""value"":""{1}"",""Type"":""Base64""}},
{{""Key"":""Description"",""value"":""{2}"",""Type"":""Base64""}},
{{""Key"":""Address"",""value"":""{3}"",""Type"":""string""}},
{{""Key"":""Status"",""value"":""{4}"",""Type"":""string""}},
{{""Key"":""User"",""value"":""{5}"",""Type"":""string""}} ",
IDCompany //0
, Convert.ToBase64String(Encoding.UTF8.GetBytes(txtTenCongTy.Text)) //1
, Convert.ToBase64String(Encoding.UTF8.GetBytes(txtMoTa.Text)) //2
, txtDiaChi.Text //3
, cbbTrangThai.EditValue.ToString() //4
, Form_Main.user.Username //5
) + "]";
// JObject json = JObject.Parse(str);
var json = new JavaScriptSerializer().Serialize(new { StoreProcedure = "sp_Company_Insert", Param = str });
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_SaveQuote";
json = API.API_POS(sLink, json);
dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
var Result = jsondataChild.First.GetValue("Result").Value;
var Message = jsondataChild.First.GetValue("Message").Value;
if (Result == 1)//Login thành công
{
//XtraMessageBox.Show(Message, "Thông Báo");
sp_Get_Company();
}
else
{
XtraMessageBox.Show("Lưu Thông Tin Không Thành Công", "Thông Báo");
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_DoanhNghiep", "SaveInfo()", ex.ToString()));
}
}
private void UpdateData()
{
try
{
Product product = new Product();
product.Id = int.Parse(ID == "" ? "0" : ID);
product.ProductCode = txtMaSP.Text;
product.ProductName = txtTenSP.Text;
product.Description = txtMoTa.Text;
product.Price = decimal.Parse(txtDonGia.EditValue.ToString());
product.CostPrice = decimal.Parse(txtGiaNhap.EditValue.ToString());
//string sql_Exect = string.Format("Exec sp_Product_Update @ID ={0},@ProductCode=N'{1}',@ProductName=N'{2}',@Description=N'{3}'," +
// "@Price={4},@UserID='{5}',@CostPrice={6}", product.Id, product.ProductCode, product.ProductName, product.Description, product.Price, Form_Main.user.Username,product.CostPrice);
//string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_GetDataByQueryString?str_Query=" + sql_Exect;
string str = "[" +
string.Format(@" {{""Key"":""ID"",""value"":""{0}"",""Type"":""string""}},
{{""Key"":""ProductCode"",""value"":""{1}"",""Type"":""string""}},
{{""Key"":""ProductName"",""value"":""{2}"",""Type"":""string""}},
{{""Key"":""Description"",""value"":""{3}"",""Type"":""string""}},
{{""Key"":""Price"",""value"":""{4}"",""Type"":""string""}},
{{""Key"":""UserID"",""value"":""{5}"",""Type"":""string""}},
{{""Key"":""CostPrice"",""value"":""{6}"",""Type"":""string""}}"
, product.Id //0
, product.ProductCode //1
, product.ProductName //2
, product.Description //3
, product.Price //4
, Form_Main.user.Username //5
, product.CostPrice) + "]"; //6
// JObject json = JObject.Parse(str);
var json = new JavaScriptSerializer().Serialize(new { StoreProcedure = "sp_Product_Update", Param = str });
string sLink = Form_Main.URL_API + "/api/IPC247/sp_extension_SaveQuote";
json = API.API_POS(sLink, json);
dynamic jsondata = JObject.Parse(json);
// var json = API.API_GET(sLink);
// dynamic jsondata = JObject.Parse(json);
var jsondataChild = jsondata.GetValue("Data");
string result = jsondataChild.First.GetValue("Result").Value.ToString();
if (result != null && result == "1")
{
ID = jsondataChild.First.GetValue("ID").Value.ToString();
LoadInfoProduct();
}
else
{
string Message = jsondataChild.First.GetValue("Message").Value.ToString();
XtraMessageBox.Show(Message, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Form_Product", "UpdateData()", ex.ToString()));
}
}
private void LoadComboboxUser()
{
try
{
DataTable dt = SQLHelper.ExecuteDataTable("sp_Get_ListUser");
slu_Saler.Properties.DataSource = dt;
}
catch (Exception ex)
{
API.API_ERRORLOG(new ERRORLOG(Form_Main.IPAddress, "Frm_Manage_Order", "LoadComboboxUser()", ex.ToString()));
}
}
