/// <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;
}
}
