/// <summary> /// 用于更新sale00相应产品使用退货的功能 /// </summary> /// <param name="sale_id">销售单号</param> /// <param name="totmoney">总退货额</param> /// <param name="qty">总退货数量</param> /// <returns>bool</returns> public bool UpdateSale00(string sale_id, decimal totmoney, double qty) { bool a = false; DateTime datetime = DateTime.Now; try { string sql = "UPDATE sale00 SET BACK_SALES=" + totmoney + ", BACK_QUAN=" + qty + ", LAST_UPDATE='" + datetime + "' ,STATUS_ID='3',transfer_status='0' WHERE SALE_ID='" + sale_id + "'"; a = base.RunSQL(sql); } catch { string da = datetime.ToString("yyyy-MM-dd HH:mm:ss"); string sql = "UPDATE sale00 SET BACK_SALES=" + totmoney + ", BACK_QUAN=" + qty + ", LAST_UPDATE='" + da + "' ,STATUS_ID='3',transfer_status='0' WHERE SALE_ID='" + sale_id + "'"; a = base.RunSQL(sql); } if (a) { try { ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string sql = "begin " + "UPDATE sale01 SET transfer_status='0' WHERE SALE_ID='" + sale_id + "';" + "UPDATE sale02 SET transfer_status='0' WHERE SALE_ID='" + sale_id + "';" + "delete from OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo.sale00 where shop_id='" + Info.shop_id + "' and sale_id='" + sale_id + "';end"; DBSql.SRunSQL(sql); } catch { } } return(a); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private int Update() { List <children_tcm_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); foreach (children_tcm_record info in infolist) { DBSql sqls = new DBSql(); sqls.sql = @"update children_tcm_record set upload_status=0,visit_date=@visit_date,tcm_info=@tcm_info,tcm_other=@tcm_other,next_visit_date=@next_visit_date,visit_doctor=@visit_doctor,update_user=@update_user,update_name=@update_name,update_time=@update_time where name=@name and aichive_no=@aichive_no and id_number=@id_number and age=@age;"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@age", info.age), new MySqlParameter("@tcm_info", info.tcm_info), new MySqlParameter("@tcm_other", info.tcm_other), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@update_user", info.update_user), new MySqlParameter("@update_name", info.update_name), new MySqlParameter("@update_time", info.update_time), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
public static int AddExecSql(string sql, string name, string datetime, string L_content) { DBSql dbObj = new DBSql(); int i = 0; SqlConnection myConn = dbObj.GetConnection(); SqlCommand myCmd = new SqlCommand(sql, myConn); myConn.Open(); try { myCmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name; myCmd.Parameters.Add("@datetime", SqlDbType.DateTime).Value = datetime; myCmd.Parameters.Add("@L_content", SqlDbType.Text).Value = L_content; i = myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { myCmd.Dispose(); myConn.Close(); } return(i); }
/// <summary> /// 新增 /// </summary> /// <returns></returns> private int Insert() { List <children_tcm_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); foreach (children_tcm_record info in infolist) { DBSql sqls = new DBSql(); sqls.sql = @"insert into children_tcm_record(id,name,aichive_no,id_number,age,visit_date,tcm_info,tcm_other,next_visit_date,visit_doctor,create_user,create_name,create_time,create_org,create_org_name,upload_status ) values(@id,@name,@aichive_no,@id_number,@age,@visit_date,@tcm_info,@tcm_other,@next_visit_date,@visit_doctor,@create_user,@create_name,@create_time,@create_org,@create_org_name,@upload_status);"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@age", info.age), new MySqlParameter("@tcm_info", info.tcm_info), new MySqlParameter("@tcm_other", info.tcm_other), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@create_user", info.create_user), new MySqlParameter("@create_name", info.create_name), new MySqlParameter("@create_time", info.create_time), new MySqlParameter("@create_org", info.create_org), new MySqlParameter("@create_org_name", info.create_org_name), new MySqlParameter("@upload_status", info.upload_status), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
/// <summary> /// 获取单个留言的信息 /// </summary> /// <param name="sql">sql语句</param> /// <param name="M_Table">表名</param> /// <returns></returns> public static DataSet GetMessOnes(string sql, string M_Table) { DBSql dbObj = new DBSql(); SqlConnection myConn = dbObj.GetConnection(); SqlCommand myCmd = new SqlCommand(sql, myConn); myConn.Open(); try { myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw (ex); } finally { myCmd.Dispose(); myConn.Close(); } SqlDataAdapter da = new SqlDataAdapter(myCmd); DataSet ds = new DataSet(); ds.Clear(); da.Fill(ds, M_Table); return(ds); }
/// <summary> /// 执行一条sql语句,回复留言 /// </summary> /// <param name="sql"></param> /// <param name="id"></param> /// <param name="huifu">回复内容</param> /// <returns>返回受影响的行数</returns> public static int PlyExecSql(string sql, int ID, string huifu) { DBSql dbObj = new DBSql(); int i = 0; SqlConnection myConn = dbObj.GetConnection(); SqlCommand myCmd = new SqlCommand(sql, myConn); myConn.Open(); try { myCmd.Parameters.Add("@ID", SqlDbType.Int).Value = ID; myCmd.Parameters.Add("@huifu", SqlDbType.VarChar).Value = huifu; i = myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { myCmd.Dispose(); myConn.Close(); } return(i); }
private void value_filter() { DataTable dt_contract = DBSql.DoGetData("select distinct contract from tbl_barangs").Tables[0]; for (int i = 0; i < dt_contract.Rows.Count; i++) { Contract_Combobox.Items.Add(dt_contract.Rows[i][0].ToString()); } DataTable dt_product = DBSql.DoGetData("select distinct product_code_desc from tbl_barangs").Tables[0]; for (int i = 0; i < dt_product.Rows.Count; i++) { Product_ComboBox.Items.Add(dt_product.Rows[i][0].ToString()); } DataTable dt_design = DBSql.DoGetData("select distinct description from tbl_barangs").Tables[0]; for (int i = 0; i < dt_design.Rows.Count; i++) { Design_ComboBox.Items.Add(dt_design.Rows[i][0].ToString()); } DataTable dt_family = DBSql.DoGetData("select distinct fam_product_desc from tbl_barangs").Tables[0]; for (int i = 0; i < dt_family.Rows.Count; i++) { Family_ComboBox.Items.Add(dt_family.Rows[i][0].ToString()); } }
/// <summary> /// 删除临时表中符合要求的记录 /// </summary> public void DelSaletmp() { DBSql.SRunSQL("delete saletmp03 where sale_id in(select sale_id from saletmp00 where locked=0 and sale_id not in('" + Info.sale_id + "'))"); DBSql.SRunSQL("delete saletmp02 where sale_id in(select sale_id from saletmp00 where locked=0 and sale_id not in('" + Info.sale_id + "'))"); DBSql.SRunSQL("delete saletmp01 where sale_id in(select sale_id from saletmp00 where locked=0 and sale_id not in('" + Info.sale_id + "'))"); DBSql.SRunSQL("delete saletmp00 where locked=0 and sale_id not in('" + Info.sale_id + "')"); }
/// <summary> /// Buat Load dari database ke DataGrid yang dituju /// </summary> /// <param name="sqlCommand"></param> /// <param name="grid"></param> /// <param name="OnGridLoad"></param> public static void LoadDatabaseToGrid(string sqlCommand, GridControl grid, Action OnGridLoad) { GridView gridView = null; foreach (var v in grid.ViewCollection) { if (v is GridView) { gridView = (GridView)v; break; } } gridView.ShowLoadingPanel(); DBSql.DoGetDataAsync(sqlCommand, delegate(DataSet dt) { grid.DataSource = dt; grid.DataMember = dt.Tables[0].TableName; gridView.OptionsView.ColumnAutoWidth = true; gridView.PopulateColumns(); gridView.BestFitColumns(true); gridView.OptionsView.ColumnAutoWidth = false; gridView.HideLoadingPanel(); OnGridLoad?.Invoke(); }); }
private void Decline_Button_Click(object sender, EventArgs e) { if (DBSql.DoCommand("update checkouts set checkout_status='Declined' where order_no='" + this.Text + "' and checkout_status='Waiting'")) { this.Close(); MessageBox.Show("Order Declined"); } }
private void Approve_Button_Click(object sender, EventArgs e) { for (int i = 0; i < Nego_GridView.GetSelectedRows().Length; i++) { int nNego = Nego_GridView.GetSelectedRows()[i]; string keyPointA = Nego_GridView.GetRowCellValue(nNego, "CUSTOMER_ID").ToString(); string keyPointB = Nego_GridView.GetRowCellValue(nNego, "DESIGN_NAME").ToString(); DBSql.DoCommand("update tbl_negos set status_approval='1', status_desc='Approved' where customer_id='" + keyPointA + "' and design_name='" + keyPointB + "' and status_approval='0'"); } Display_nego(); }
/// <summary> /// 是否可以改变数量 /// </summary> /// <param name="GROUP_PROD">组号</param> /// <param name="type">0代表在原来的基础上加一,1代表在原来的基础上减一,2代表把给定的字段改成给定的值num</param> /// <param name="sale_id">销售单号</param> /// <param name="num">数量</param> /// <returns></returns> public bool CanChangeQty(string GROUP_PROD, int type, string sale_id, decimal num) { string str = "select * from saletmp01 where GROUP_PROD=@group_prod and sale_id=@sale_id"; System.Data.SqlClient.SqlParameter[] para = new System.Data.SqlClient.SqlParameter[2]; para[0] = new System.Data.SqlClient.SqlParameter("@GROUP_PROD", SqlDbType.NVarChar); para[1] = new System.Data.SqlClient.SqlParameter("@SALE_ID", SqlDbType.NVarChar); para[0].Value = GROUP_PROD; para[1].Value = sale_id; //DataSet ds= DBSql.SCreateDataSet(str); DataSet ds = DBSql.SCreateDataSet(str, para); try { if (ds != null) { if (type == 0) { return(true); } else { decimal sale_price = Convert.ToDecimal(ds.Tables[0].Rows[0]["SALE_PRICE"]); decimal disc_total = -Convert.ToDecimal(ds.Tables[0].Rows[0]["ITEM_DISC_TOT"]); //2012年11月5日11:02:05 string price_type = ds.Tables[0].Rows[0]["PRICE_TYPE"].ToString(); int number = Convert.ToInt32(ds.Tables[0].Rows[0]["QTY"]); if (1 == type) { number -= 1; } else { number = Convert.ToInt32(num); } if (sale_price * number <= disc_total && price_type.Equals("2")) { return(false); } else { return(true); } } } else { return(false); } } catch { return(false); } }
/// <summary> /// 新增 /// </summary> /// <returns></returns> private int Insert() { List <gravida_after_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); DBSql sqls = null; foreach (gravida_after_record info in infolist) { sqls = new DBSql(); sqls.sql = @"insert into gravida_after_record(id,name,aichive_no,id_number,order_num,visit_date,childbirth,discharge_date,temperature,general_health_status,general_psychology_status,blood_pressure_high,blood_pressure_low,breast,breast_error,lyma,lyma_error,womb,womb_error,wound,wound_error,other,`condition`,error_info,guidance,guidance_other,transfer_treatment,transfer_treatment_reason,transfer_treatment_department,next_visit_date,visit_doctor,create_user,create_name,create_time,create_org,create_org_name,upload_status) values(@id,@name,@aichive_no,@id_number,@order_num,@visit_date,@childbirth,@discharge_date,@temperature,@general_health_status,@general_psychology_status,@blood_pressure_high,@blood_pressure_low,@breast,@breast_error,@lyma,@lyma_error,@womb,@womb_error,@wound,@wound_error,@other,@condition,@error_info,@guidance,@guidance_other,@transfer_treatment,@transfer_treatment_reason,@transfer_treatment_department,@next_visit_date,@visit_doctor,@create_user,@create_name,@create_time,@create_org,@create_org_name,@upload_status);"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@order_num", info.order_num), new MySqlParameter("@childbirth", info.childbirth), new MySqlParameter("@discharge_date", info.discharge_date), new MySqlParameter("@temperature", info.temperature), new MySqlParameter("@general_health_status", info.general_health_status), new MySqlParameter("@general_psychology_status", info.general_psychology_status), new MySqlParameter("@blood_pressure_high", info.blood_pressure_high), new MySqlParameter("@blood_pressure_low", info.blood_pressure_low), new MySqlParameter("@breast", info.breast), new MySqlParameter("@breast_error", info.breast_error), new MySqlParameter("@lyma", info.lyma), new MySqlParameter("@lyma_error", info.lyma_error), new MySqlParameter("@womb", info.womb), new MySqlParameter("@womb_error", info.womb_error), new MySqlParameter("@wound", info.wound), new MySqlParameter("@wound_error", info.wound_error), new MySqlParameter("@other", info.other), new MySqlParameter("@condition", info.condition), new MySqlParameter("@error_info", info.error_info), new MySqlParameter("@guidance", info.guidance), new MySqlParameter("@guidance_other", info.guidance_other), new MySqlParameter("@transfer_treatment", info.transfer_treatment), new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason), new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@create_user", info.create_user), new MySqlParameter("@create_name", info.create_name), new MySqlParameter("@create_time", info.create_time), new MySqlParameter("@create_org", info.create_org), new MySqlParameter("@create_org_name", info.create_org_name), new MySqlParameter("@upload_status", info.upload_status), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
/// <summary> /// 按照要求删除本地数据库中的数据 /// </summary> /// <returns>成功删除返回true</returns> public bool DelLocalData() { DataSet ds = DBSql.SCreateDataSet("select * from pos_transfer where transfer_mode='out' or transfer_mode='shift'"); bool b = false; ReadIni readIni = new ReadIni("config.ini"); int day; try { day = Convert.ToInt32(mainForm.OperPara.GetIniConfig("clearDay")); if (day < 1) { day = 7; } } catch { day = 7; } DateTime d = DateTime.Now; string str; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { //SALE01中没有LAST_UPDATE字段且先执行SALE00的删除操作,再执行SALE01的删除操作 if (ds.Tables[0].Rows[i]["transfer_table"].ToString() == "SALE01") { continue; } else {//删除day天前的数据 str = " delete " + ds.Tables[0].Rows[i]["transfer_table"] + " where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); } } catch { b = false; } } str = " delete SALE01 where sale_id not in (select sale_id from sale00)"; b = DBSql.SRunSQL(str); str = " delete saletmp00 where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); str = " delete saletmp01 where sale_id not in (select sale_id from saletmp00)"; b = DBSql.SRunSQL(str); str = " delete saletmp02 where DATEDIFF(day,LAST_UPDATE,'" + d + "')>" + day; b = DBSql.SRunSQL(str); return(b); }
/// <summary> /// 新增 /// </summary> /// <returns></returns> private int Insert() { List <gravida_follow_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); DBSql sqls = null; foreach (gravida_follow_record info in infolist) { sqls = new DBSql(); sqls.sql = @"insert into gravida_follow_record(id,name,aichive_no,id_number,order_num,visit_date,gestational_weeks,symptom,weight,fundus_height,abdomen_circumference,fetus_position,fetal_heart_rate,blood_pressure_high,blood_pressure_low,hemoglobin,urine_protein,check_other,`condition`,error_info,guidance,guidance_other,transfer_treatment,transfer_treatment_reason,transfer_treatment_department,next_visit_date,visit_doctor,create_user,create_name,create_time,create_org,create_org_name,upload_status) values(@id,@name,@aichive_no,@id_number,@order_num,@visit_date,@gestational_weeks,@symptom,@weight,@fundus_height,@abdomen_circumference,@fetus_position,@fetal_heart_rate,@blood_pressure_high,@blood_pressure_low,@hemoglobin,@urine_protein,@check_other,@condition,@error_info,@guidance,@guidance_other,@transfer_treatment,@transfer_treatment_reason,@transfer_treatment_department,@next_visit_date,@visit_doctor,@create_user,@create_name,@create_time,@create_org,@create_org_name,@upload_status);"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@order_num", info.order_num), new MySqlParameter("@gestational_weeks", info.gestational_weeks), new MySqlParameter("@symptom", info.symptom), new MySqlParameter("@weight", info.weight), new MySqlParameter("@fundus_height", info.fundus_height), new MySqlParameter("@abdomen_circumference", info.abdomen_circumference), new MySqlParameter("@fetus_position", info.fetus_position), new MySqlParameter("@fetal_heart_rate", info.fetal_heart_rate), new MySqlParameter("@blood_pressure_high", info.blood_pressure_high), new MySqlParameter("@blood_pressure_low", info.blood_pressure_low), new MySqlParameter("@hemoglobin", info.hemoglobin), new MySqlParameter("@urine_protein", info.urine_protein), new MySqlParameter("@check_other", info.check_other), new MySqlParameter("@condition", info.condition), new MySqlParameter("@error_info", info.error_info), new MySqlParameter("@guidance", info.guidance), new MySqlParameter("@guidance_other", info.guidance_other), new MySqlParameter("@transfer_treatment", info.transfer_treatment), new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason), new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@create_user", info.create_user), new MySqlParameter("@create_name", info.create_name), new MySqlParameter("@create_time", info.create_time), new MySqlParameter("@create_org", info.create_org), new MySqlParameter("@create_org_name", info.create_org_name), new MySqlParameter("@upload_status", info.upload_status), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private int Update() { List <gravida_after_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); foreach (gravida_after_record info in infolist) { DBSql sqls = new DBSql(); sqls.sql = @"update gravida_after_record set upload_status=0,visit_date=@visit_date,childbirth=@childbirth,discharge_date=@discharge_date,temperature=@temperature,general_health_status=@general_health_status,general_psychology_status=@general_psychology_status,blood_pressure_high=@blood_pressure_high,blood_pressure_low=@blood_pressure_low,breast=@breast,breast_error=@breast_error,lyma=@lyma,lyma_error=@lyma_error,womb=@womb,womb_error=@womb_error,wound=@wound,wound_error=@wound_error,other=@other,`condition`=@condition,error_info=@error_info,guidance=@guidance,guidance_other=@guidance_other,transfer_treatment=@transfer_treatment,transfer_treatment_reason=@transfer_treatment_reason,transfer_treatment_department=@transfer_treatment_department,next_visit_date=@next_visit_date,visit_doctor=@visit_doctor,update_user=@update_user,update_name=@update_name,update_time=@update_time where name=@name and aichive_no=@aichive_no and id_number=@id_number and order_num=@order_num;"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@order_num", info.order_num), new MySqlParameter("@childbirth", info.childbirth), new MySqlParameter("@discharge_date", info.discharge_date), new MySqlParameter("@temperature", info.temperature), new MySqlParameter("@general_health_status", info.general_health_status), new MySqlParameter("@general_psychology_status", info.general_psychology_status), new MySqlParameter("@blood_pressure_high", info.blood_pressure_high), new MySqlParameter("@blood_pressure_low", info.blood_pressure_low), new MySqlParameter("@breast", info.breast), new MySqlParameter("@breast_error", info.breast_error), new MySqlParameter("@lyma", info.lyma), new MySqlParameter("@lyma_error", info.lyma_error), new MySqlParameter("@womb", info.womb), new MySqlParameter("@womb_error", info.womb_error), new MySqlParameter("@wound", info.wound), new MySqlParameter("@wound_error", info.wound_error), new MySqlParameter("@other", info.other), new MySqlParameter("@condition", info.condition), new MySqlParameter("@error_info", info.error_info), new MySqlParameter("@guidance", info.guidance), new MySqlParameter("@guidance_other", info.guidance_other), new MySqlParameter("@transfer_treatment", info.transfer_treatment), new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason), new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@update_user", info.update_user), new MySqlParameter("@update_name", info.update_name), new MySqlParameter("@update_time", info.update_time), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
//Constructor public Form_SplashScreen() { InitializeComponent(); //ProgressBar Setup ProgressBar.Maximum = 100; ProgressBar.Step = 1; ProgressBar.Value = 0; //Animation Setup this.Opacity = 0.0f; m_animTimer = new Timer(); m_animTimer.Interval = 17; //ms m_animTimer.Tick += AnimEvent; m_tweener = new Tweener <float>(); m_tweener.duration = 0.3f; //second; m_tweener.tweenDelegate = delegate(ref float value) { value = Tween.DoTween(0f, 1f, m_tweener.progress, m_tweener.type); this.Opacity = value; }; m_tweener.Start(); m_animTimer.Start(); //Sequence Execution m_sequence = new Sequence(); m_sequence.OnEachActionStart = OnEachActionStart; m_sequence.OnEachActionFinish = OnEachActionFinish; m_sequence.OnSequenceFinish = OnSequenceFinish; m_sequence.AddAction(delegate { //Initialize App App.Initialize(); }); m_sequence.AddAction(delegate { //Pinging Server Ping ping = new Ping(); m_pingReply = ping.Send(DB.ipString); }); m_sequence.AddAction(delegate { //Testing Connection DBSql.Test(); }); }
private void ProductForm_Load(object sender, EventArgs e) { keyName = this.Text; DataSet ds_image_desain = new DataSet(); DBSql.DoGetData("select url_design_img from tbl_barangs where description='" + keyName.Split('$')[0] + "' and contract='" + keyName.Split('$')[1] + "' and grade='A'", ds_image_desain); if (ds_image_desain.Tables[0].Rows.Count > 0) { if (!String.IsNullOrEmpty(ds_image_desain.Tables[0].Rows[0][0].ToString())) { if (ds_image_desain.Tables[0].Rows[0][0].ToString() != "-") { string url = "http://ultimindserver.mywire.org:3000/img_file/designs/" + ds_image_desain.Tables[0].Rows[0][0].ToString(); r_image = new RequestImage(); r_image.loadFromUrlAsync(url, delegate(Image img) { if (img != null) { pic_product.Image = img; } else { pic_product.Image = Properties.Resources.img_error; } }); } DataSet ds = DBSql.DoGetData("select design_id from tbl_barangs where description='" + keyName.Split('$')[0] + "' and contract='" + keyName.Split('$')[1] + "' and grade='A'"); design_id = ds.Tables[0].Rows[0][0].ToString(); DataSet ds_colors = DBSql.DoGetData("select color_desc, url_color_img, part_no, design_id from tbl_barangs where description='" + keyName.Split('$')[0] + "' and contract='" + keyName.Split('$')[1] + "' and grade='A'"); for (int i = 0; i < ds_colors.Tables[0].Rows.Count; i++) { list_colors.Items.Add(ds_colors.Tables[0].Rows[i][0].ToString()); list_colors_img.Add(ds_colors.Tables[0].Rows[i][1].ToString()); list_part.Add(ds_colors.Tables[0].Rows[i][2].ToString()); } } else { pic_product.Image = Properties.Resources.img_error; } } else { MessageBox.Show("Data Tidak ditemukan"); return; } }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private int Update() { List <gravida_follow_record> infolist = GetData(); List <DBSql> hb = new List <DBSql>(); foreach (gravida_follow_record info in infolist) { DBSql sqls = new DBSql(); sqls.sql = @"update gravida_follow_record set upload_status=0,visit_date=@visit_date,gestational_weeks=@gestational_weeks,symptom=@symptom, weight=@weight,fundus_height=@fundus_height,abdomen_circumference=@abdomen_circumference,fetus_position=@fetus_position, fetal_heart_rate=@fetal_heart_rate,blood_pressure_high=@blood_pressure_high,blood_pressure_low=@blood_pressure_low, hemoglobin=@hemoglobin,urine_protein=@urine_protein,check_other=@check_other,`condition`=@condition,error_info=@error_info, guidance=@guidance,guidance_other=@guidance_other,transfer_treatment=@transfer_treatment,transfer_treatment_reason=@transfer_treatment_reason,transfer_treatment_department=@transfer_treatment_department,next_visit_date=@next_visit_date,visit_doctor=@visit_doctor,update_user=@update_user,update_name=@update_name,update_time=@update_time where name=@name and aichive_no=@aichive_no and id_number=@id_number and order_num=@order_num;"; sqls.parameters = new MySqlParameter[] { new MySqlParameter("@id", info.id), new MySqlParameter("@name", info.name), new MySqlParameter("@aichive_no", info.aichive_no), new MySqlParameter("@id_number", info.id_number), new MySqlParameter("@visit_date", info.visit_date), new MySqlParameter("@order_num", info.order_num), new MySqlParameter("@gestational_weeks", info.gestational_weeks), new MySqlParameter("@symptom", info.symptom), new MySqlParameter("@weight", info.weight), new MySqlParameter("@fundus_height", info.fundus_height), new MySqlParameter("@abdomen_circumference", info.abdomen_circumference), new MySqlParameter("@fetus_position", info.fetus_position), new MySqlParameter("@fetal_heart_rate", info.fetal_heart_rate), new MySqlParameter("@blood_pressure_high", info.blood_pressure_high), new MySqlParameter("@blood_pressure_low", info.blood_pressure_low), new MySqlParameter("@hemoglobin", info.hemoglobin), new MySqlParameter("@urine_protein", info.urine_protein), new MySqlParameter("@check_other", info.check_other), new MySqlParameter("@condition", info.condition), new MySqlParameter("@error_info", info.error_info), new MySqlParameter("@guidance", info.guidance), new MySqlParameter("@guidance_other", info.guidance_other), new MySqlParameter("@transfer_treatment", info.transfer_treatment), new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason), new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department), new MySqlParameter("@next_visit_date", info.next_visit_date), new MySqlParameter("@visit_doctor", info.visit_doctor), new MySqlParameter("@update_user", info.update_user), new MySqlParameter("@update_name", info.update_name), new MySqlParameter("@update_time", info.update_time), }; hb.Add(sqls); } return(DbHelperMySQL.ExecuteSqlTran(hb)); }
void LoadData() { DataTable dt_segment = DBSql.DoGetData("select distinct segment from tbl_customers").Tables[0]; for (int i = 0; i < dt_segment.Rows.Count; i++) { Segment_ComboBox.Items.Add(dt_segment.Rows[i][0].ToString()); } DataTable dt_region = DBSql.DoGetData("select distinct region_name from tbl_customers").Tables[0]; for (int i = 0; i < dt_region.Rows.Count; i++) { Region_ComboBox.Items.Add(dt_region.Rows[i][0].ToString()); } }
/// <summary> /// 根据用户名从服务器的pos_rounds表中获取登录有关的信息 /// </summary> /// <param name="userName">用户名</param> /// <returns>DataSet</returns> public DataSet GetOnlineInfo(string userName) { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@USER_ID", SqlDbType.NVarChar); para[0].Value = userName; ReadIni readIni = new ReadIni("config.ini"); string srvIp = readIni.ReadString("RepastErp", "txtServerIP"); string srvPort = readIni.ReadString("RepastErp", "txtPort"); string srvDBName = readIni.ReadString("RepastErp", "txtIPdataname"); string srvUserName = readIni.ReadString("RepastErp", "txtFTPuser"); string srvPassword = readIni.ReadString("RepastErp", "txtFTPpassword"); string str = " select * from OPENDATASOURCE('SQLOLEDB','Data Source=" + srvIp + "," + srvPort + ";User ID=" + srvUserName + ";Password="******"' )." + srvDBName + ".dbo.POS_ROUNDS where user_id=@USER_ID and exit_date is null"; return(DBSql.SCreateDataSet(str, para)); }
/// <summary> /// 根据条件删除,此删除方法,不支持分表数据的删除 /// </summary> /// <typeparam name="T">要删除的类型</typeparam> /// <param name="where">删除条件</param> /// <param name="paras">参数</param> /// <returns>影响行数</returns> public int Delete <T>(string where, params object[] paras) { Type type = typeof(T); DBTable table = MapHelper.GetDBTable(type); DBSql dbsql = DBSqlHelper.GetDBSql(table.Name, _dbContext.DataType); where = FormatWhereOrder(table, where); Command.CommandText = string.Format("delete from {0} {1}", table.Name, where.Length > 0 ? " where " + where : ""); Command.CommandType = CommandType.Text; Command.Parameters.Clear(); int i = 0; foreach (object obj in paras) { AddParameter(FormatParameterName("p" + (i++).ToString()), ParameterDirection.Input, obj); } return(Command.ExecuteNonQuery()); }
/// <summary> /// 写入数据 /// </summary> /// <param name="instance"></param> /// <param name="type">映射表类型</param> /// <param name="date">要写入表的拆分日期。注意该日期必须与Id中的日期对应。比如按年拆分的表,Id中的年份与该日期中的年份必须相同</param> public void Insert(object instance, Type type, DateTime date) { DBTable table = MapHelper.GetDBTable(type); //取主键值 object primaryVal = null; if (table.PrimaryKey[0].DBPrimaryType != DBPrimaryType.Identity) { primaryVal = this.GetValue(table.PrimaryKey[0], instance); if (primaryVal == null) { throw new MyDBException("新增对象,非自增长表主键不能为空"); } } //取表名。如果是拆分表,则获取拆分表名 string tbName = table.Name; if (table.SeparateType != SeparateType.None) { //如果传入时间为空,则取myId中的时间 if (date == DateTime.MinValue) { date = MyIdMake.GetMyIdDate(primaryVal); } //获取数据库表名 tbName = TableSeparate.GetTableName(table, date); } //获取该数据库表 对应的DBSql中的Insert语句 DBSql dbsql = DBSqlHelper.GetDBSql(tbName, _dbContext.DataType); if (string.IsNullOrEmpty(dbsql.InsertSql))//如果该表的新增语句为空,则生成该表的Insert语句 { dbsql.InsertSql = GetInsertSql(table, tbName); } //将数据写入数据库 Insert(instance, primaryVal, table, dbsql.InsertSql); }
private void Add_Button_Click(object sender, EventArgs e) { if (!ValidationForm(CustID_Textbox, Cust_Textbox, Segment_ComboBox, Addr_Textbox, Country_Textbox, Region_ComboBox, Market_ComboBox, CP_Textbox, PH_Textbox, MPH_Textbox, fx_Textbox)) { MessageBox.Show("Semua Form Harus Diisi", "Form Required", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string queryInsert = "insert ignore into tbl_customers (customer_id, customer_name, segment_id, segment, address1, country, city, region_id, region_name, market_id, market, contact_person, phone, mobile_phone, fax, sales_id, status_approval) " + "values ('" + CustID_Textbox.Text + "','" + Cust_Textbox.Text + "','" + list_segment_id[Segment_ComboBox.SelectedIndex] + "','" + Segment_ComboBox.Text + "','" + Addr_Textbox.Text + "','" + Country_Textbox.Text + "','" + "-" + "','" + list_region_id[Region_ComboBox.SelectedIndex] + "','" + Region_ComboBox.Text + "','" + list_market_id[Market_ComboBox.SelectedIndex] + "','" + Market_ComboBox.Text + "','" + CP_Textbox.Text + "','" + PH_Textbox.Text + "','" + MPH_Textbox.Text + "','" + fx_Textbox.Text + "','" + "-" + "','" + "Approve" + "')"; if (DBSql.DoCommand(queryInsert)) { status_add_customer = true; this.Close(); } else { MessageBox.Show("Customer ID Sudah Digunakan", "Add Customer", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void Display_data() { DataSet ds = DBSql.DoGetData("select order_no as ORDER_NO, order_date as TANGGAL, tbl_customers.segment as BIDANG_USAHA, checkouts.market as MARKET, checkouts.region as WILAYAH, checkouts.customer_name as CUSTOMER, tbl_users.fullname as SALESMAN, g_total_price as TOTAL_PEMBAYARAN, currency as KURS, checkout_status as STATUS, notes as NOTE from checkouts inner join tbl_users on tbl_users.user_id=checkouts.sales_id inner join tbl_customers on tbl_customers.customer_id=checkouts.customer_id" + " where checkouts.order_no='" + this.Text + "'"); Customer_Label.Text = ds.Tables[0].Rows[0][5].ToString(); Segment_Label.Text = ds.Tables[0].Rows[0][2].ToString(); Region_Label.Text = ds.Tables[0].Rows[0][4].ToString(); Salesman_Label.Text = ds.Tables[0].Rows[0][6].ToString(); Notes_rtb.Text = ds.Tables[0].Rows[0][10].ToString(); Status_Label.Text = ds.Tables[0].Rows[0][9].ToString(); Approve_Button.Enabled = true; Decline_Button.Enabled = true; if (Status_Label.Text != "Waiting") { Approve_Button.Enabled = false; Decline_Button.Enabled = false; } FormUtility.LoadDatabaseToGrid( "select part_no as PART_NO, product_name as PRODUCT_NAME, family_name as FAMILY_NAME, design_name as DESIGN_NAME, colors_name as COLOR, grade as GRADE, qty as JUMLAH, unit as SATUAN, price_unit as HARGA_SATUAN, total_price as TOTAL_HARGA, total_price_dom as TOTAL_HARGA_DOMESTIK from tbl_orders where order_no='" + this.Text + "'", Detail_Grid, null); }
private void Value_Filter() { DataTable dt = DBSql.DoGetData("select distinct region_name from tbl_customers").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { Region_Combobox.Items.Add(dt.Rows[i][0].ToString()); } DataTable dt_sales = DBSql.DoGetData("select fullname from tbl_users where user_roles='3'").Tables[0]; for (int i = 0; i < dt_sales.Rows.Count; i++) { Sales_ComboBox.Items.Add(dt_sales.Rows[i][0].ToString()); } DataTable dt_segment = DBSql.DoGetData("select distinct segment from tbl_customers").Tables[0]; for (int i = 0; i < dt_segment.Rows.Count; i++) { Segment_ComboBox.Items.Add(dt_segment.Rows[i][0].ToString()); } }
/// <summary> /// 修改对象,支持分表数据的修改 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="instance"></param> /// <returns>受影响的行数</returns> public int Update <T>(T instance) { Type type = typeof(T); DBTable table = MapHelper.GetDBTable(type); //获取修改对象的主键 object primaryVal = this.GetValue(table.PrimaryKey[0], instance); //获取主键对应的数据库表名 string tbName = TableSeparate.GetTableName(table, primaryVal); DBSql dbsql = DBSqlHelper.GetDBSql(tbName, _dbContext.DataType); if (string.IsNullOrEmpty(dbsql.UpdateSql))//如果该表的修改语句为空,则生成该表的update语句 { dbsql.UpdateSql = GetUpdateSql(table, tbName); } //修改数据 int retVal = Update <T>(instance, table, dbsql.UpdateSql, primaryVal); return(retVal); }
/// <summary> /// 根据主键删除,支持分表数据的删除 /// </summary> /// <typeparam name="T">要删除的类型</typeparam> /// <typeparam name="IdT">主键类型</typeparam> /// <param name="id">主键值</param> /// <returns>影响行数</returns> public int Delete <T, IdT>(IdT id) { Type type = typeof(T); DBTable table = MapHelper.GetDBTable(type); if (table.PrimaryKey.Count > 1) { throw new Exception("联合主键表,不支持根据主键删除"); } //获取对应的数据库表名 string tbName = TableSeparate.GetTableName(table, id); DBSql dbsql = DBSqlHelper.GetDBSql(tbName, _dbContext.DataType); if (string.IsNullOrEmpty(dbsql.DeleteSql))//如果该表的修改语句为空,则生成该表的update语句 { dbsql.DeleteSql = GetDeleteSql(table, tbName); } int retVal = Delete <T, IdT>(id, table, dbsql.DeleteSql); return(retVal); }
/// <summary> /// Event yang dipanggil ketika Berpindah "Scene" /// </summary> /// <param name="i"></param> private void Event_OnNavSelectedPageChanged(int i) { //Stop All Worker Worker.DisposeAllWorker(); //UnLoad All Grid Order_Grid.DataSource = null; Order_GridView.PopulateColumns(); Product_Grid.DataSource = null; Product_GridView.PopulateColumns(); switch (i) { case 0: //Dashboard Page DataTable dt = null; //Load Statistic dt = DBSql.DoGetData("select count(*) from tbl_customers").Tables[0]; Dashboard_PanelInfo1_Num.Text = dt.Rows[0][0].ToString(); dt = DBSql.DoGetData("select count(*) from checkouts").Tables[0]; Dashboard_PanelInfo2_Num.Text = dt.Rows[0][0].ToString(); dt = DBSql.DoGetData("select count(*) from checkouts where checkout_status not like 'Success'").Tables[0]; Dashboard_PanelInfo3_Num.Text = dt.Rows[0][0].ToString(); dt = DBSql.DoGetData("select count(*) from checkouts where checkout_status='Success'").Tables[0]; Dashboard_PanelInfo4_Num.Text = dt.Rows[0][0].ToString(); break; case 1: //Order Page OrderGridUpdate(); break; case 2: //Product Page ProductGridUpdate(); break; case 3: //Customer Page if (App.userInfo.userType != UserType.SuperAdmin) { _context.Show_Overlay(this); MessageBox.Show("Akses ditolak, Hanya Super Admin yang Diperbolehkan", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop); _context.Hide_Overlay(); Header_Button_Dashboard.Checked = true; return; } CustomerUpdateGrid(); break; case 4: //Sales Page if (App.userInfo.userType != UserType.SuperAdmin) { _context.Show_Overlay(this); MessageBox.Show("Akses ditolak, Hanya Super Admin yang Diperbolehkan", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop); _context.Hide_Overlay(); Header_Button_Dashboard.Checked = true; return; } SalesUpdateGrid(); break; } }
/// <summary> /// Event yangd dipanggil ketika <see cref="CircleButton"/> terclick di Area <see cref="Product_NavFrame"/> /// </summary> /// <param name="obj"></param> /// <param name="e"></param> private void Event_OnProductNavButtonClicked(object obj, EventArgs e) { var btn = (CircleButton)obj; switch (btn.tag) { case "FilterFilter": Form_ProductFilter form_filter = new Form_ProductFilter(); form_filter.ShowDialog(); string query_filter = " AND"; if (form_filter.filterContract != "") { query_filter += " contract='" + form_filter.filterContract + "' AND"; } if (form_filter.filterProduct != "") { query_filter += " product_code_desc='" + form_filter.filterProduct + "' AND"; } if (form_filter.filterDesign != "") { query_filter += " description='" + form_filter.filterDesign + "' AND"; } if (form_filter.filterFamily != "") { query_filter += " fam_product_desc='" + form_filter.filterFamily + "' AND"; } query_filter = query_filter.Substring(0, query_filter.Length - 3); if (form_filter.status_filter) { FormUtility.LoadDatabaseToGrid(queryProduct + query_filter, Product_Grid, null); } break; case "FilterCancel": FormUtility.LoadDatabaseToGrid(queryProduct, Product_Grid, null); break; case "PrevPage": break; case "NextPage": break; case "Import": Dialog.ShowOpenFileDialog("Import Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path) { if (ok) { XlsData data = new XlsData(path); DataSet ds = data.ToDataSet(); bool status_import = false; Random rand = new Random(9999); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string query_import = "insert into tbl_barangs (contract, design_id, part_no, description, accounting_group, acc_gr_desc, product_code, product_code_desc, fam_product, fam_product_desc, prime_com, prime_com_desc, second_com, second_com_desc, unit, grade, color_code, color_desc, url_design_img, url_color_img, price_inc, price_exc) values('" + ds.Tables[0].Rows[i][0].ToString() + "','" + "des" + rand.Next(9999).ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "','" + ds.Tables[0].Rows[i][2].ToString() + "','" + ds.Tables[0].Rows[i][3].ToString() + "','" + ds.Tables[0].Rows[i][4].ToString() + "','" + ds.Tables[0].Rows[i][5].ToString() + "','" + ds.Tables[0].Rows[i][6].ToString() + "','" + ds.Tables[0].Rows[i][7].ToString() + "','" + ds.Tables[0].Rows[i][8].ToString() + "','" + ds.Tables[0].Rows[i][9].ToString() + "','" + ds.Tables[0].Rows[i][10].ToString() + "','" + ds.Tables[0].Rows[i][11].ToString() + "','" + ds.Tables[0].Rows[i][12].ToString() + "','" + ds.Tables[0].Rows[i][13].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString().Split('-')[ds.Tables[0].Rows[i][1].ToString().Split('-').Length - 1] + "','" + ds.Tables[0].Rows[i][14].ToString() + "','" + ds.Tables[0].Rows[i][15].ToString() + "','" + "-" + "','" + "-" + "','" + ds.Tables[0].Rows[i][16].ToString() + "','" + ds.Tables[0].Rows[i][17].ToString() + "')"; DataSet ds_check = DBSql.DoGetData("select count(*) from tbl_barangs where part_no='" + ds.Tables[0].Rows[i][1].ToString() + "' and contract='" + ds.Tables[0].Rows[i][0].ToString() + "'"); if (int.Parse(ds_check.Tables[0].Rows[0][0].ToString()) == 0) { DataSet ds_check_part2 = DBSql.DoGetData("select design_id from tbl_barangs where description='" + ds.Tables[0].Rows[i][2].ToString() + "' and contract='" + ds.Tables[0].Rows[i][0].ToString() + "' limit 1"); if (ds_check_part2.Tables[0].Rows.Count > 0) { query_import = "insert into tbl_barangs (contract, design_id, part_no, description, accounting_group, acc_gr_desc, product_code, product_code_desc, fam_product, fam_product_desc, prime_com, prime_com_desc, second_com, second_com_desc, unit, grade, color_code, color_desc, url_design_img, url_color_img, price_inc, price_exc) values('" + ds.Tables[0].Rows[i][0].ToString() + "','" + ds_check_part2.Tables[0].Rows[0][0].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "','" + ds.Tables[0].Rows[i][2].ToString() + "','" + ds.Tables[0].Rows[i][3].ToString() + "','" + ds.Tables[0].Rows[i][4].ToString() + "','" + ds.Tables[0].Rows[i][5].ToString() + "','" + ds.Tables[0].Rows[i][6].ToString() + "','" + ds.Tables[0].Rows[i][7].ToString() + "','" + ds.Tables[0].Rows[i][8].ToString() + "','" + ds.Tables[0].Rows[i][9].ToString() + "','" + ds.Tables[0].Rows[i][10].ToString() + "','" + ds.Tables[0].Rows[i][11].ToString() + "','" + ds.Tables[0].Rows[i][12].ToString() + "','" + ds.Tables[0].Rows[i][13].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString().Split('-')[ds.Tables[0].Rows[i][1].ToString().Split('-').Length - 1] + "','" + ds.Tables[0].Rows[i][14].ToString() + "','" + ds.Tables[0].Rows[i][15].ToString() + "','" + "-" + "','" + "-" + "','" + ds.Tables[0].Rows[i][16].ToString() + "','" + ds.Tables[0].Rows[i][17].ToString() + "')"; DBSql.DoCommand(query_import); } else { DBSql.DoCommand(query_import); } status_import = true; } } Toast.ShowToast("Data Barang " + (status_import ? "Berhasil" : "Tidak") + " Diimport", "Import Data Barang", ToastIndicator.Ok); } }); break; case "Export": Dialog.ShowSaveFileDialog("Export Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path) { if (ok) { DataSet ds = DBSql.DoGetData("select contract as CONTRACT, part_no as PART_NO, description as DESCRIPTION, accounting_group as ACCOUNTING_GROUP, acc_gr_desc as ACC_GROUP_DESC, product_code as PRODUCT_CODE, product_code_desc as PRODUCT_CODE_DESC, fam_product as FAM_PRODUCT_CODE, fam_product_desc as FAM_PRODUCT_DESC, prime_com as PRIME_COMMODITY, prime_com_desc as PRIME_COM_DESC, second_com as SECOND_COMMODIY, second_com_desc as SECOND_COM_DESC, unit as UNIT_MEAS, grade as GRADE, color_code as COLOR_CODE, color_desc as COLOR_DESC, price_inc as PRICE_INC, price_exc as PRICE_EXC FROM tbl_barangs where grade='A'"); XlsData data = new XlsData(ds); data.ToFile(path); Toast.ShowToast("Data Barang Berhasil Diexport", "Export Data Barang", ToastIndicator.Ok); } }); break; } }