/// <summary>
/// 업데이트 문을 처리 하기 위한 메서드
/// </summary>
/// <param name="ob_sub"></param>
/// <param name="type_u"></param>
/// <returns></returns>
internal bool Update_state_ob(object ob_sub, string type_u)
{
SqlParameter[] sqlParameters = new SqlParameter[0];
string sp = "";
if (type_u == "seller")
{
Seller_Vo sv_sub = ob_sub as Seller_Vo;
sp = "update_seller_join_state";
//var con = new DBCon_admin();
sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("seller_no", sv_sub.Seller_NO);
sqlParameters[1] = new SqlParameter("join_state", sv_sub.Join_state);
sqlParameters[2] = new SqlParameter("seller_state", sv_sub.Seller_state);
}
else if (type_u == "pro")
{
Products_Vo pv_sub = ob_sub as Products_Vo;
sp = "update_products_state";
sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("pro_ID", pv_sub.Pro_ID);
sqlParameters[1] = new SqlParameter("pro_state", pv_sub.Pro_State);
}
else if (type_u == "pay")
{
TaxBill_Vo tv_sub = ob_sub as TaxBill_Vo;
sp = "update_pay_tax_date";
sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("pay_id", tv_sub.Pay_ID);
}
else if (type_u == "inq")
{
Inquire_Admin_Vo ia_sub = ob_sub as Inquire_Admin_Vo;
sp = "update_Inquire_Admin";
sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("inquire_no", ia_sub.Inquire_no);
sqlParameters[1] = new SqlParameter("re_body", ia_sub.Re_body);
}
try
{
return(new DBCon_admin().Update_ob(sp, sqlParameters));
}
catch (Exception)
{
throw;
}
}
public Tax_Ex(TaxBill_Vo tv) : this()
{
this.tv = tv;
}
/// <summary>
/// 출력 버튼 클릭시 발생하는 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_output_Click(object sender, EventArgs e)
{
Excel.Application excelApp = new Excel.Application();
if (excelApp == null)
{
MessageBox.Show("Excel 응용 프로그램을 찾을 수 없거나, 설치 되지 않았습니다.");
}
Excel.Workbook workBook;
Excel.Worksheet workSheet;
object missingValue = System.Reflection.Missing.Value;
workBook = excelApp.Workbooks.Open(Application.StartupPath + "/Resources/Tax_Format.xlsx");
workSheet = workBook.Worksheets.Item[1];
workSheet.Cells[5, 3] = lbl_corporate_registration_no.Text;
workSheet.Cells[6, 6] = lbl_seller_boss.Text;
workSheet.Cells[6, 3] = lbl_seller_Id.Text;
workSheet.Cells[7, 3] = lbl_seller_addr.Text;
workSheet.Cells[10, 1] = lbl_pay_date_1.Text;
workSheet.Cells[10, 3] = lbl_pay_price_2.Text;
workSheet.Cells[10, 7] = lbl_pay_price_5.Text;
workSheet.Cells[12, 1] = lbl_pay_date_2.Text;
workSheet.Cells[12, 2] = lbl_stock_id.Text;
workSheet.Cells[12, 5] = lbl_pay_count.Text;
workSheet.Cells[12, 6] = lbl_pay_price_1.Text;
workSheet.Cells[12, 8] = lbl_pay_price_3.Text;
workSheet.Cells[12, 10] = lbl_pay_price_4.Text;
workSheet.Cells[17, 1] = lbl_pay_price_6.Text;
try
{
date_short = DateTime.Now.ToShortDateString();
workBook.SaveAs(lbl_path.Text + @"\세금계산서 " + lbl_stock_id.Text + " " + date_short + ".xls", Excel.XlFileFormat.xlWorkbookNormal, null, null, null, null, Excel.XlSaveAsAccessMode.xlNoChange, Excel.XlSaveConflictResolution.xlLocalSessionChanges, missingValue, missingValue, missingValue, missingValue);
}
catch (Exception)
{
MessageBox.Show("저장 실패");
return;
}
excelApp.Quit();
Marshal.ReleaseComObject(workSheet);
Marshal.ReleaseComObject(workBook);
Marshal.ReleaseComObject(excelApp);
string type_u = "pay";
TaxBill_Vo tv_sub = new TaxBill_Vo()
{
Pay_ID = tv.Pay_ID
};
if (new Admin_Dao().Update_state_ob(tv_sub, type_u))
{
MessageBox.Show("저장 성공");
Admin_main ad = (Admin_main)Owner;
ad.Pro_Temp = true;
}
}
