//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_SCORE", Convert.ToInt32(Request["SCM_ScoreID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblPostDate.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Substring(0, 10);
lbltester.Text = ds.Tables[0].Rows[0]["tester"].ToString();
lbllangScore.Text = ds.Tables[0].Rows[0]["langScore"].ToString();
lblengScore.Text = ds.Tables[0].Rows[0]["engScore"].ToString();
lblmathScore.Text = ds.Tables[0].Rows[0]["mathScore"].ToString()
.Replace("\r\n", "<br />");
lbltotalScore.Text = ds.Tables[0].Rows[0]["totalScore"].ToString();
lblpf.Text = ds.Tables[0].Rows[0]["pf"].ToString();
lblReadCount.Text = ds.Tables[0].Rows[0]["ReadCount"].ToString()
.Replace("\r\n", "<br />");
}
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_ETRI", Convert.ToInt32(Request["SCM_NewsID"]));
//[3]Bind
txtTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
txtwt1.Text = ds.Tables[0].Rows[0]["wt1"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_SCORE", Convert.ToInt32(Request["SCM_ScoreID"]));
//[3]Bind
txttester.Text = ds.Tables[0].Rows[0]["tester"].ToString();
txtlangScore.Text = ds.Tables[0].Rows[0]["langScore"].ToString();
txtengScore.Text = ds.Tables[0].Rows[0]["engScore"].ToString();
txtmathScore.Text = ds.Tables[0].Rows[0]["mathScore"].ToString();
txttotalScore.Text = ds.Tables[0].Rows[0]["totalScore"].ToString();
txtpf.Text = ds.Tables[0].Rows[0]["pf"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//[4]삭제
protected void btnDelete_Click(object sender, ImageClickEventArgs e)
{
//[1]script
string strAlert = @"<script>alert('삭제되었습니다.');location.href='SCM_NoticeList.aspx';</script>";
try
{
using (Is.Notice.Bsl.Notice_RTx rBsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(
ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_DeleteSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SCM_ScoreID", Convert.ToInt32(Request["SCM_ScoreID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[3]
Page.RegisterStartupScript("EndScript", strAlert);
}
catch (Exception err)
{
//[4]
//Response.Write(err.Source + " : " + err.Message);
}
}
//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Sales", Convert.ToInt32(Request["SCM_SalesID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblReadCount.Text = ds.Tables[0].Rows[0]["ReadCount"].ToString();
lblPostDate.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Substring(0, 10);
lblSCM_SalesID.Text = ds.Tables[0].Rows[0]["SCM_SalesID"].ToString();
lbltotal1.Text = ds.Tables[0].Rows[0]["total1"].ToString()
.Replace("\r\n", "<br />");
lblTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblsalesdate1.Text = ds.Tables[0].Rows[0]["salesdate1"].ToString();
lblcompany1.Text = ds.Tables[0].Rows[0]["company1"].ToString();
/*lblterm.Text = ds.Tables[0].Rows[0]["term"].ToString();*/
lblprice1.Text = ds.Tables[0].Rows[0]["price1"].ToString();
lblitem1.Text = ds.Tables[0].Rows[0]["item1"].ToString();
/*lblcontent2.Text = ds.Tables[0].Rows[0]["content2"].ToString()
* .Replace("\r\n", "<br />");*/
lblsupply1.Text = ds.Tables[0].Rows[0]["supply1"].ToString();
/*lbldeadline.Text = ds.Tables[0].Rows[0]["deadline"].ToString();*/
/*lblsalesman1.Text = ds.Tables[0].Rows[0]["salesman1"].ToString();*/
lblvat1.Text = ds.Tables[0].Rows[0]["vat1"].ToString();
lblea1.Text = ds.Tables[0].Rows[0]["ea1"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
if ((lblFileName.Text != null) && (lblFileName.Text != ""))
{
btnFile.Visible = true;
}
else
{
btnFile.Visible = false;
}
}
else
{
lblNoticeError.Text = "잘못된 요청입니다";
}
}
}
//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Notice", Convert.ToInt32(Request["SCM_NoticeID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblReadCount.Text = ds.Tables[0].Rows[0]["ReadCount"].ToString();
lblPostDate.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Substring(0, 10);
lblSCM_NoticeID.Text = ds.Tables[0].Rows[0]["SCM_NoticeID"].ToString();
lblContent.Text = ds.Tables[0].Rows[0]["Content"].ToString()
.Replace("\r\n", "<br />");
lblTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblps.Text = ds.Tables[0].Rows[0]["ps"].ToString();
lblts1.Text = ds.Tables[0].Rows[0]["ts1"].ToString();
lbllink1.Text = ds.Tables[0].Rows[0]["link1"].ToString();
lblsec1.Text = ds.Tables[0].Rows[0]["sec1"].ToString();
lblcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
lblcs1.Text = ds.Tables[0].Rows[0]["cs1"].ToString()
.Replace("\r\n", "<br />");
lbltech1.Text = ds.Tables[0].Rows[0]["tech1"].ToString();
lblDead1.Text = ds.Tables[0].Rows[0]["Dead1"].ToString();
lblcorp1.Text = ds.Tables[0].Rows[0]["corp1"].ToString();
lblProgress1.Text = ds.Tables[0].Rows[0]["Progress1"].ToString();
lbllang1.Text = ds.Tables[0].Rows[0]["lang1"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
if ((lblFileName.Text != null) && (lblFileName.Text != ""))
{
btnFile.Visible = true;
}
else
{
btnFile.Visible = false;
}
}
else
{
lblNoticeError.Text = "잘못된 요청입니다";
}
}
}
//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Notice", Convert.ToInt32(Request["SCM_NoticeID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblContent.Text = ds.Tables[0].Rows[0]["Content"].ToString()
.Replace("\r\n", "<br />");
lblPostDate.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Substring(0, 10);
lblproject.Text = ds.Tables[0].Rows[0]["project"].ToString();
lbldate1.Text = ds.Tables[0].Rows[0]["date1"].ToString();
lblcustomer.Text = ds.Tables[0].Rows[0]["customer"].ToString();
lbletc.Text = ds.Tables[0].Rows[0]["etc"].ToString()
.Replace("\r\n", "<br />");
lblperiod1.Text = ds.Tables[0].Rows[0]["period1"].ToString();
lbldueDate.Text = ds.Tables[0].Rows[0]["dueDate"].ToString();
lblprogress1.Text = ds.Tables[0].Rows[0]["progress1"].ToString();
lblcompany.Text = ds.Tables[0].Rows[0]["company"].ToString();
lblcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
lbllanguage1.Text = ds.Tables[0].Rows[0]["language1"].ToString();
lbltodo.Text = ds.Tables[0].Rows[0]["todo"].ToString();
lbltech.Text = ds.Tables[0].Rows[0]["tech"].ToString();
lblReadCount.Text = ds.Tables[0].Rows[0]["ReadCount"].ToString()
.Replace("\r\n", "<br />");
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
if ((lblFileName.Text != null) && (lblFileName.Text != ""))
{
btnFile.Visible = true;
}
else
{
btnFile.Visible = false;
}
}
else
{
lblNoticeError.Text = "잘못된 요청입니다";
}
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Order", Convert.ToInt32(Request["SCM_OrderID"]));
//[3]Bind
txtserial_num.Text = ds.Tables[0].Rows[0]["serial_num"].ToString()
.Replace("\r\n", "<br />");
txtdue_date.Text = ds.Tables[0].Rows[0]["due_date"].ToString();
txtc_num.Text = ds.Tables[0].Rows[0]["c_num"].ToString();
txtc_name.Text = ds.Tables[0].Rows[0]["c_name"].ToString();
txtc_leader.Text = ds.Tables[0].Rows[0]["c_leader"].ToString();
txtc_address.Text = ds.Tables[0].Rows[0]["c_address"].ToString()
.Replace("\r\n", "<br />");
txtc_charge.Text = ds.Tables[0].Rows[0]["c_charge"].ToString();
txtc_phonenum.Text = ds.Tables[0].Rows[0]["c_phonenum"].ToString();
lblcode.Text = ds.Tables[0].Rows[0]["code"].ToString();
lblitem.Text = ds.Tables[0].Rows[0]["item"].ToString();
lblamount.Text = ds.Tables[0].Rows[0]["amount"].ToString();
lbluniprice.Text = ds.Tables[0].Rows[0]["uniprice"].ToString();
lblprice.Text = ds.Tables[0].Rows[0]["price"].ToString();
lblvat.Text = ds.Tables[0].Rows[0]["vat"].ToString();
txtt_amount.Text = ds.Tables[0].Rows[0]["t_amount"].ToString()
.Replace("\r\n", "<br />");
txtt_uniprice.Text = ds.Tables[0].Rows[0]["t_uniprice"].ToString();
txtt_vat.Text = ds.Tables[0].Rows[0]["t_vat"].ToString();
txtt_price.Text = ds.Tables[0].Rows[0]["t_price"].ToString();
txtprice_kor.Text = ds.Tables[0].Rows[0]["price_kor"].ToString();
txtprice_num.Text = ds.Tables[0].Rows[0]["price_num"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Notice", Convert.ToInt32(Request["SCM_NoticeID"]));
//[3]Bind
txtproject.Text = ds.Tables[0].Rows[0]["project"].ToString();
txtdate1.Text = ds.Tables[0].Rows[0]["date1"].ToString();
txtcustomer.Text = ds.Tables[0].Rows[0]["customer"].ToString();
txtetc.Text = ds.Tables[0].Rows[0]["etc"].ToString();
txtperiod1.Text = ds.Tables[0].Rows[0]["period1"].ToString();
txtlanguage1.Text = ds.Tables[0].Rows[0]["language1"].ToString();
txttodo.Text = ds.Tables[0].Rows[0]["todo"].ToString();
txtdueDate.Text = ds.Tables[0].Rows[0]["dueDate"].ToString();
txtprogress1.Text = ds.Tables[0].Rows[0]["progress1"].ToString();
txtcompany.Text = ds.Tables[0].Rows[0]["company"].ToString();
txtcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
txtContent.Text = ds.Tables[0].Rows[0]["Content"].ToString()
.Replace("\r\n", "<br />");
txttech.Text = ds.Tables[0].Rows[0]["tech"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Notice", Convert.ToInt32(Request["SCM_NoticeID"]));
//[3]Bind
txtTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
txtps.Text = ds.Tables[0].Rows[0]["ps"].ToString();
txtts1.Text = ds.Tables[0].Rows[0]["ts1"].ToString();
txtcs1.Text = ds.Tables[0].Rows[0]["cs1"].ToString();
txtlink1.Text = ds.Tables[0].Rows[0]["link1"].ToString();
txtlang1.Text = ds.Tables[0].Rows[0]["lang1"].ToString();
txtsec1.Text = ds.Tables[0].Rows[0]["sec1"].ToString();
txtDead1.Text = ds.Tables[0].Rows[0]["Dead1"].ToString();
txtProgress1.Text = ds.Tables[0].Rows[0]["Progress1"].ToString();
txtcorp1.Text = ds.Tables[0].Rows[0]["corp1"].ToString();
txtcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
txtContent.Text = ds.Tables[0].Rows[0]["Content"].ToString()
.Replace("\r\n", "<br />");
txttech1.Text = ds.Tables[0].Rows[0]["tech1"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//Submit
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{ //이 부분은 db에는 한줄씩 리스트에는 여러줄로 출력되는형태에 필요한 부분! 혹시 몰라 안지우고 주석처리합니당
// string sub_codes ="";
// string sub_items ="";
// string sub_amounts ="";
// string sub_prices ="";
// string sub_uniprices ="";
// string sub_vats ="";
// sub_codes = submit_codes.Text;
// string [] list_codes = sub_codes.Split(','); // ["액자,물티슈,노트북..."] => ["액자","물티슈","노트북"] 리스트길이는 3
// 위에 있는건 리스트 길이가 1, 오른쪽은 리스트 길이가 3 (,을 기준으로 리스트를 생성해줌)
// sub_items = submit_items.Text;
// string [] list_items = sub_items.Split(',');
// sub_uniprices = submit_uniprices.Text;
// string [] list_uniprices = sub_uniprices.Split(',');
// sub_prices = submit_prices.Text;
// string [] list_prices = sub_prices.Split(',');
// sub_amounts = submit_amounts.Text;
// string [] list_amounts = sub_amounts.Split(',');
// sub_vats = submit_vats.Text;
// string [] list_vats = sub_vats.Split(',');
// for (int i = 0; i < list_vats.Length ; i++){ // 리스트 길이만큼 반복해 이 부분을
string UpfileName = ""; // 이 부분은 데이터 베이스에 추가가 되는부분 ,포문 안에 있으니깐 리스트 길이 만큼 반복->이것도 예전꺼
string dbFileName = string.Empty;
string strserial_num = "";
string strdue_date = "";
string strc_num = "";
string strc_name = "";
string strc_leader = "";
string strc_address = "";
string strc_charge = "";
string strc_phonenum = "";
string strcode = "";
string stritem = "";
string stramount = "";
string struniprice = "";
string strprice = "";
string strvat = "";
string strt_amount = "";
string strt_uniprice = "";
string strt_price = "";
string strt_vat = "";
string strprice_kor = "";
string strprice_num = "";
string path = "c:\\inetpub\\joblink\\fileUpload\\Order\\";
string strAlert = @"<script>alert('입력했습니다.');location.href='SCM_NoticeList.aspx';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\Order\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\Order\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]변환
strserial_num = txtserial_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strdue_date = txtdue_date.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_num = txtc_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_name = txtc_name.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_leader = txtc_leader.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_address = txtc_address.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_charge = txtc_charge.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_phonenum = txtc_phonenum.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strcode = submit_codes.Text //list_codes[i] // 이 끝부분에 i= 0~리스트 길이 만큼의 리스트 항목을 반환 =>['물티슈','액자','노트북'] 처음에는 물티슈로 디비에 저장
// 두번쨰는 액자로 저장
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
stritem = submit_items.Text // list_items[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
stramount = submit_amounts.Text //list_amounts[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
struniprice = submit_uniprices.Text//list_uniprices[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice = submit_prices.Text //list_prices[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strvat = submit_vats.Text//list_vats[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_amount = txtt_amount.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_uniprice = txtt_uniprice.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_price = txtt_price.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_vat = txtt_vat.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice_kor = txtprice_kor.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice_num = txtprice_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
if (strserial_num != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@serial_num", strserial_num);
cmd.Parameters.AddWithValue("@due_date", strdue_date);
cmd.Parameters.AddWithValue("@c_num", strc_num);
cmd.Parameters.AddWithValue("@c_name", strc_name);
cmd.Parameters.AddWithValue("@c_leader", strc_leader);
cmd.Parameters.AddWithValue("@c_address", strc_address);
cmd.Parameters.AddWithValue("@c_charge", strc_charge);
cmd.Parameters.AddWithValue("@c_phonenum", strc_phonenum);
cmd.Parameters.AddWithValue("@code", strcode);
cmd.Parameters.AddWithValue("@item", stritem);
cmd.Parameters.AddWithValue("@amount", stramount);
cmd.Parameters.AddWithValue("@uniprice", struniprice);
cmd.Parameters.AddWithValue("@price", strprice);
cmd.Parameters.AddWithValue("@vat", strvat);
cmd.Parameters.AddWithValue("@t_amount", strt_amount);
cmd.Parameters.AddWithValue("@t_uniprice", strt_uniprice);
cmd.Parameters.AddWithValue("@t_vat", strt_vat);
cmd.Parameters.AddWithValue("@t_price", strt_price);
cmd.Parameters.AddWithValue("@price_kor", strprice_kor);
cmd.Parameters.AddWithValue("@price_num", strprice_num);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
// cmd.Parameters.AddWithValue("@submit_codes", sub_codes);
// cmd.Parameters.AddWithValue("@submit_items", sub_items);
// cmd.Parameters.AddWithValue("@submit_amounts", sub_amounts);
// cmd.Parameters.AddWithValue("@submit_uniprices", sub_uniprices);
// cmd.Parameters.AddWithValue("@submit_prices", sub_prices);
// cmd.Parameters.AddWithValue("@submit_vats", sub_vats);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//[4]
Response.Write(strAlert);
}
catch (Exception err)
{
//[5]Exception
Response.Write(err.Source + " : " + err.Message);
}
//}//for문 대괄호 액자,물티슈,컴퓨터 => 데이터 베이스 액자한번 물티슈 한번 컴퓨터 한번 이렇게 저장하는게 이 포문
}
//수정
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]제목과 내용 변수
string strtester = "";
string strlangScore = "";
string strengScore = "";
string strmathScore = "";
string strtotalScore = "";
string strpf = "";
//[1-1]script
string strAlert = @"<script>alert('수정했습니다.');location.href='SCM_NoticeView.aspx?SCM_ScoreID="
+ Request["SCM_ScoreID"]
+ "';</script>";
try
{
//[2]리플레이스 변환
strtester = txttester.Text;
strlangScore = txtlangScore.Text;
strengScore = txtengScore.Text;
strmathScore = txtmathScore.Text;
strtotalScore = txttotalScore.Text;
strpf = txtpf.Text;
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[1]Excute
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_ModifySCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
cmd.Parameters.AddWithValue("@SCM_ScoreID", Convert.ToInt32(Request["SCM_ScoreID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[2]리디렉트..수차후수정
Response.Write(strAlert);
}
catch (Exception err)
{
//[3]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Order", Convert.ToInt32(Request["SCM_NoticeID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblps.Text = ds.Tables[0].Rows[0]["ps"].ToString();
lbltech1.Text = ds.Tables[0].Rows[0]["tech1"].ToString();
lblDead1.Text = ds.Tables[0].Rows[0]["Dead1"].ToString();
lblcorp1.Text = ds.Tables[0].Rows[0]["corp1"].ToString();
lblcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
lbllang1.Text = ds.Tables[0].Rows[0]["lang1"].ToString();
lblsec1.Text = ds.Tables[0].Rows[0]["sec1"].ToString();
lblts1.Text = ds.Tables[0].Rows[0]["ts1"].ToString();
lblts02.Text = ds.Tables[0].Rows[0]["ts02"].ToString();
lblts03.Text = ds.Tables[0].Rows[0]["ts03"].ToString();
lblts04.Text = ds.Tables[0].Rows[0]["ts04"].ToString();
lblts05.Text = ds.Tables[0].Rows[0]["ts05"].ToString();
lblcs1.Text = ds.Tables[0].Rows[0]["cs1"].ToString();
lblcs2.Text = ds.Tables[0].Rows[0]["cs2"].ToString();
lblcs3.Text = ds.Tables[0].Rows[0]["cs3"].ToString();
lblcs4.Text = ds.Tables[0].Rows[0]["cs4"].ToString();
lblcs5.Text = ds.Tables[0].Rows[0]["cs5"].ToString();
lblqty1.Text = ds.Tables[0].Rows[0]["qty1"].ToString();
lblqty2.Text = ds.Tables[0].Rows[0]["qty2"].ToString();
lblqty3.Text = ds.Tables[0].Rows[0]["qty3"].ToString();
lblqty4.Text = ds.Tables[0].Rows[0]["qty4"].ToString();
lblqty5.Text = ds.Tables[0].Rows[0]["qty5"].ToString();
lblprice1.Text = ds.Tables[0].Rows[0]["price1"].ToString();
lblprice2.Text = ds.Tables[0].Rows[0]["price2"].ToString();
lblprice3.Text = ds.Tables[0].Rows[0]["price3"].ToString();
lblprice4.Text = ds.Tables[0].Rows[0]["price4"].ToString();
lblprice5.Text = ds.Tables[0].Rows[0]["price5"].ToString();
lblvos1.Text = ds.Tables[0].Rows[0]["vos1"].ToString();
lblvos2.Text = ds.Tables[0].Rows[0]["vos2"].ToString();
lblvos3.Text = ds.Tables[0].Rows[0]["vos3"].ToString();
lblvos4.Text = ds.Tables[0].Rows[0]["vos4"].ToString();
lblvos5.Text = ds.Tables[0].Rows[0]["vos5"].ToString();
lblvat1.Text = ds.Tables[0].Rows[0]["vat1"].ToString();
lblvat2.Text = ds.Tables[0].Rows[0]["vat2"].ToString();
lblvat3.Text = ds.Tables[0].Rows[0]["vat3"].ToString();
lblvat4.Text = ds.Tables[0].Rows[0]["vat4"].ToString();
lblvat5.Text = ds.Tables[0].Rows[0]["vat5"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
if ((lblFileName.Text != null) && (lblFileName.Text != ""))
{
btnFile.Visible = true;
}
else
{
btnFile.Visible = false;
}
}
else
{
lblNoticeError.Text = "잘못된 요청입니다";
}
}
}
//수정
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]제목과 내용 변수
string strproject = "";
string strdate1 = "";
string strcustomer = "";
string stretc = "";
string strperiod1 = "";
string strdueDate = "";
string strlanguage1 = "";
string strprogress1 = "";
string strcompany = "";
string strcode1 = "";
string strtodo = "";
string strtech = "";
string strContent = "";
string UpfileName = "";
string dbFileName = lblFileName.Text;
//[1-1]script
string strAlert = @"<script>alert('수정했습니다.');location.href='SCM_NoticeView.aspx?SCM_NoticeID="
+ Request["SCM_NoticeID"]
+ "';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]리플레이스 변환
strproject = txtproject.Text;
strdate1 = txtdate1.Text;
strcustomer = txtcustomer.Text;
stretc = txtetc.Text;
strperiod1 = txtperiod1.Text;
strdueDate = txtdueDate.Text;
strprogress1 = txtprogress1.Text;
strcompany = txtcompany.Text;
strcode1 = txtcode1.Text;
strlanguage1 = txtlanguage1.Text;
strtodo = txttodo.Text;
strtech = txttech.Text;
strContent = txtContent.Text
.Replace("\r\n", "<br />");
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[1]Excute
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_ModifySCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@SCM_NoticeID", Convert.ToInt32(Request["SCM_NoticeID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[2]리디렉트..수차후수정
Response.Write(strAlert);
}
catch (Exception err)
{
//[3]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//Submit
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]임시변수
string strTitle = "";
string strtotal1 = "";
string strsalesdate1 = "";
string strcompany1 = "";
string strcompany2 = "";
string strcompany3 = "";
string strcompany4 = "";
string strcompany5 = "";
string strcompany6 = "";
string strcompany7 = "";
string strcompany8 = "";
string stritem1 = "";
//string strcontent2 = "";
//string strterm = "";
//string strdeadline = "";
string strvat1 = "";
string strsalesman1 = "";
string strea1 = "";
string strprice1 = "";
string strsupply1 = "";
string UpfileName = "";
string dbFileName = string.Empty;
string path = "d:\\_Mobile_System\\joblink\\fileUpload\\Notice\\";
string strAlert = @"<script>alert('입력했습니다.');location.href='SCM_NoticeList.aspx';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]변환
strTitle = txtTitle.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strtotal1 = txttotal1.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strsalesdate1 = txtsalesdate1.Text;
stritem1 = txtitem1.Text;
strcompany1 = txtcompany1.Text;
//strcontent2 = txtcontent2.Text;
//strterm = txtterm.Text;
//strdeadline = txtdeadline.Text;
strvat1 = txtvat1.Text;
strsalesman1 = txtsalesman1.Text;
strea1 = txtea1.Text;
strprice1 = txtprice1.Text;
strsupply1 = txtsupply1.Text;
if (strcompany1 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany2 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany3 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany4 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany5 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany6 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany7 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strcompany8 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@total1", strtotal1);
cmd.Parameters.AddWithValue("@item1", stritem1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@salesdate1", strsalesdate1);
cmd.Parameters.AddWithValue("@ea1", strea1);
cmd.Parameters.AddWithValue("@company1", strcompany1);
//cmd.Parameters.AddWithValue("@content2", strcontent2);
//cmd.Parameters.AddWithValue("@term", strterm);
//cmd.Parameters.AddWithValue("@deadline", strdeadline);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@salesman1", strsalesman1);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@supply1", strsupply1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
/*
* using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
* {
* SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
* SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
*
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Parameters.AddWithValue("@Title", strTitle);
* cmd.Parameters.AddWithValue("@Content", strContent);
* cmd.Parameters.AddWithValue("@code1", strcode1);
* cmd.Parameters.AddWithValue("@code2", strcode2);
* cmd.Parameters.AddWithValue("@code3", strcode3);
* cmd.Parameters.AddWithValue("@code4", strcode4);
* cmd.Parameters.AddWithValue("@code5", strcode5);
*
*
* cmd.Parameters.AddWithValue("@upFileName", dbFileName);
* cmd.Parameters.AddWithValue("@upFileName2", dbFileName2);
* cmd.Parameters.AddWithValue("@upFileName3", dbFileName3);
* cmd.Parameters.AddWithValue("@upFileName4", dbFileName4);
* cmd.Parameters.AddWithValue("@upFileName5", dbFileName5);
*
*
*
* cmd.Parameters.AddWithValue("@ps", strps);
* cmd.Parameters.AddWithValue("@ts1", strts1);
* cmd.Parameters.AddWithValue("@ts2", strts2);
* cmd.Parameters.AddWithValue("@ts3", strts3);
* cmd.Parameters.AddWithValue("@ts4", strts4);
* cmd.Parameters.AddWithValue("@ts5", strts5);
*
* cmd.Parameters.AddWithValue("@cs1", strcs1);
* cmd.Parameters.AddWithValue("@cs2", strcs2);
* cmd.Parameters.AddWithValue("@cs3", strcs3);
* cmd.Parameters.AddWithValue("@cs4", strcs4);
* cmd.Parameters.AddWithValue("@cs5", strcs5);
*
*
* cmd.Parameters.AddWithValue("@link1", strlink1);
* cmd.Parameters.AddWithValue("@link2", strlink2);
* cmd.Parameters.AddWithValue("@link3", strlink3);
* cmd.Parameters.AddWithValue("@link4", strlink4);
* cmd.Parameters.AddWithValue("@link5", strlink5);
*
* cmd.Parameters.AddWithValue("@Dead1", strDead1);
* cmd.Parameters.AddWithValue("@Dead2", strDead2);
* cmd.Parameters.AddWithValue("@Dead3", strDead3);
* cmd.Parameters.AddWithValue("@Dead4", strDead4);
* cmd.Parameters.AddWithValue("@Dead5", strDead5);
*
* cmd.Parameters.AddWithValue("@Progress1", strProgress1);
* cmd.Parameters.AddWithValue("@Progress2", strProgress2);
* cmd.Parameters.AddWithValue("@Progress3", strProgress3);
* cmd.Parameters.AddWithValue("@Progress4", strProgress4);
* cmd.Parameters.AddWithValue("@Progress5", strProgress5);
*
* cmd.Parameters.AddWithValue("@corp1", strcorp1);
* cmd.Parameters.AddWithValue("@corp2", strcorp2);
* cmd.Parameters.AddWithValue("@corp3", strcorp3);
* cmd.Parameters.AddWithValue("@corp4", strcorp4);
* cmd.Parameters.AddWithValue("@corp5", strcorp5);
*
* con.Open();
* cmd.ExecuteNonQuery();
* con.Close();
* }
*/
//[4]
Response.Write(strAlert);
}
catch (Exception err)
{
//[5]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//Submit
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]임시변수
string strtester = "";
string strlangScore = "";
string strmathScore = "";
string strpf = "";
string strts2 = "";
string strts3 = "";
string strts4 = "";
string strts5 = "";
string strts6 = "";
string strts7 = "";
string strts8 = "";
string strengScore = "";
string strtotalScore = "";
string dbFileName = string.Empty;
string path = "d:\\_Mobile_System\\joblink\\fileUpload\\Notice\\";
string strAlert = @"<script>alert('입력했습니다.');location.href='SCM_NoticeList.aspx';</script>";
try
{
//[2]변환
strtester = txttester.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strlangScore = txtlangScore.Text;
strengScore = txtengScore.Text;
strmathScore = txtmathScore.Text;
strtotalScore = txttotalScore.Text;
strpf = txtpf.Text;
if (strpf != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts2 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts3 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts4 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts5 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts6 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts7 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts8 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_SCORE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tester", strtester);
cmd.Parameters.AddWithValue("@langScore", strlangScore);
cmd.Parameters.AddWithValue("@engScore", strengScore);
cmd.Parameters.AddWithValue("@mathScore", strmathScore);
cmd.Parameters.AddWithValue("@totalScore", strtotalScore);
cmd.Parameters.AddWithValue("@pf", strpf);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
/*
* using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
* {
* SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
* SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
*
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Parameters.AddWithValue("@tester", strtester);
* cmd.Parameters.AddWithValue("@langScore", strlangScore);
* cmd.Parameters.AddWithValue("@engScore", strengScore);
* cmd.Parameters.AddWithValue("@code2", strcode2);
* cmd.Parameters.AddWithValue("@code3", strcode3);
* cmd.Parameters.AddWithValue("@code4", strcode4);
* cmd.Parameters.AddWithValue("@code5", strcode5);
*
*
* cmd.Parameters.AddWithValue("@upFileName", dbFileName);
* cmd.Parameters.AddWithValue("@upFileName2", dbFileName2);
* cmd.Parameters.AddWithValue("@upFileName3", dbFileName3);
* cmd.Parameters.AddWithValue("@upFileName4", dbFileName4);
* cmd.Parameters.AddWithValue("@upFileName5", dbFileName5);
*
*
*
* cmd.Parameters.AddWithValue("@mathScore", strmathScore);
* cmd.Parameters.AddWithValue("@pf", strpf);
* cmd.Parameters.AddWithValue("@ts2", strts2);
* cmd.Parameters.AddWithValue("@ts3", strts3);
* cmd.Parameters.AddWithValue("@ts4", strts4);
* cmd.Parameters.AddWithValue("@ts5", strts5);
*
* cmd.Parameters.AddWithValue("@cs1", strcs1);
* cmd.Parameters.AddWithValue("@cs2", strcs2);
* cmd.Parameters.AddWithValue("@cs3", strcs3);
* cmd.Parameters.AddWithValue("@cs4", strcs4);
* cmd.Parameters.AddWithValue("@cs5", strcs5);
*
*
* cmd.Parameters.AddWithValue("@link1", strlink1);
* cmd.Parameters.AddWithValue("@link2", strlink2);
* cmd.Parameters.AddWithValue("@link3", strlink3);
* cmd.Parameters.AddWithValue("@link4", strlink4);
* cmd.Parameters.AddWithValue("@link5", strlink5);
*
* cmd.Parameters.AddWithValue("@Dead1", strDead1);
* cmd.Parameters.AddWithValue("@Dead2", strDead2);
* cmd.Parameters.AddWithValue("@Dead3", strDead3);
* cmd.Parameters.AddWithValue("@Dead4", strDead4);
* cmd.Parameters.AddWithValue("@Dead5", strDead5);
*
* cmd.Parameters.AddWithValue("@Progress1", strProgress1);
* cmd.Parameters.AddWithValue("@Progress2", strProgress2);
* cmd.Parameters.AddWithValue("@Progress3", strProgress3);
* cmd.Parameters.AddWithValue("@Progress4", strProgress4);
* cmd.Parameters.AddWithValue("@Progress5", strProgress5);
*
* cmd.Parameters.AddWithValue("@corp1", strcorp1);
* cmd.Parameters.AddWithValue("@corp2", strcorp2);
* cmd.Parameters.AddWithValue("@corp3", strcorp3);
* cmd.Parameters.AddWithValue("@corp4", strcorp4);
* cmd.Parameters.AddWithValue("@corp5", strcorp5);
*
* con.Open();
* cmd.ExecuteNonQuery();
* con.Close();
* }
*/
//[4]
Response.Write(strAlert);
}
catch (Exception err)
{
//[5]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//수정
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]제목과 내용 변수
string UpfileName = ""; // 이 부분은 데이터 베이스에 추가가 되는부분 ,포문 안에 있으니깐 리스트 길이 만큼 반복->이것도 예전꺼
string dbFileName = string.Empty;
string strserial_num = "";
string strdue_date = "";
string strc_num = "";
string strc_name = "";
string strc_leader = "";
string strc_address = "";
string strc_charge = "";
string strc_phonenum = "";
string strcode = "";
string stritem = "";
string stramount = "";
string struniprice = "";
string strprice = "";
string strvat = "";
string strt_amount = "";
string strt_uniprice = "";
string strt_price = "";
string strt_vat = "";
string strprice_kor = "";
string strprice_num = "";
//[1-1]script
string strAlert = @"<script>alert('수정했습니다.');location.href='SCM_NoticeView.aspx?SCM_OrderID="
+ Request["SCM_OrderID"]
+ "';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\Order\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\Order\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]리플레이스 변환
strserial_num = txtserial_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strdue_date = txtdue_date.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_num = txtc_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_name = txtc_name.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_leader = txtc_leader.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_address = txtc_address.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_charge = txtc_charge.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strc_phonenum = txtc_phonenum.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strcode = submit_codes.Text //list_codes[i] // 이 끝부분에 i= 0~리스트 길이 만큼의 리스트 항목을 반환 =>['물티슈','액자','노트북'] 처음에는 물티슈로 디비에 저장
// 두번쨰는 액자로 저장
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
stritem = submit_items.Text // list_items[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
stramount = submit_amounts.Text //list_amounts[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
struniprice = submit_uniprices.Text//list_uniprices[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice = submit_prices.Text //list_prices[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strvat = submit_vats.Text//list_vats[i]
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_amount = txtt_amount.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_uniprice = txtt_uniprice.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_price = txtt_price.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strt_vat = txtt_vat.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice_kor = txtprice_kor.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strprice_num = txtprice_num.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[1]Excute
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_ModifySCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@serial_num", strserial_num);
cmd.Parameters.AddWithValue("@due_date", strdue_date);
cmd.Parameters.AddWithValue("@c_num", strc_num);
cmd.Parameters.AddWithValue("@c_name", strc_name);
cmd.Parameters.AddWithValue("@c_leader", strc_leader);
cmd.Parameters.AddWithValue("@c_address", strc_address);
cmd.Parameters.AddWithValue("@c_charge", strc_charge);
cmd.Parameters.AddWithValue("@c_phonenum", strc_phonenum);
cmd.Parameters.AddWithValue("@code", strcode);
cmd.Parameters.AddWithValue("@item", stritem);
cmd.Parameters.AddWithValue("@amount", stramount);
cmd.Parameters.AddWithValue("@uniprice", struniprice);
cmd.Parameters.AddWithValue("@price", strprice);
cmd.Parameters.AddWithValue("@vat", strvat);
cmd.Parameters.AddWithValue("@t_amount", strt_amount);
cmd.Parameters.AddWithValue("@t_uniprice", strt_uniprice);
cmd.Parameters.AddWithValue("@t_vat", strt_vat);
cmd.Parameters.AddWithValue("@t_price", strt_price);
cmd.Parameters.AddWithValue("@price_kor", strprice_kor);
cmd.Parameters.AddWithValue("@price_num", strprice_num);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@SCM_OrderID", Convert.ToInt32(Request["SCM_OrderID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[2]리디렉트..수차후수정
Response.Write(strAlert);
}
catch (Exception err)
{
//[3]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//레이블 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = new DataSet();
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Order", Convert.ToInt32(Request["SCM_OrderID"]));
if (ds.Tables[0].Rows.Count > 0)
{
//[3]내용이 길어서.. 출력 오류 날수 있으니..나중에 체크하자..
lblserial_num.Text = ds.Tables[0].Rows[0]["serial_num"].ToString()
.Replace("\r\n", "<br />");
lbldue_date.Text = ds.Tables[0].Rows[0]["due_date"].ToString();
lblc_num.Text = ds.Tables[0].Rows[0]["c_num"].ToString();
lblc_name.Text = ds.Tables[0].Rows[0]["c_name"].ToString();
lblc_leader.Text = ds.Tables[0].Rows[0]["c_leader"].ToString();
lblc_address.Text = ds.Tables[0].Rows[0]["c_address"].ToString()
.Replace("\r\n", "<br />");
lblc_charge.Text = ds.Tables[0].Rows[0]["c_charge"].ToString();
lblc_phonenum.Text = ds.Tables[0].Rows[0]["c_phonenum"].ToString();
lblcode.Text = ds.Tables[0].Rows[0]["code"].ToString();
lblitem.Text = ds.Tables[0].Rows[0]["item"].ToString();
lblamount.Text = ds.Tables[0].Rows[0]["amount"].ToString();
lbluniprice.Text = ds.Tables[0].Rows[0]["uniprice"].ToString();
lblprice.Text = ds.Tables[0].Rows[0]["price"].ToString();
lblvat.Text = ds.Tables[0].Rows[0]["vat"].ToString();
lblt_amount.Text = ds.Tables[0].Rows[0]["t_amount"].ToString()
.Replace("\r\n", "<br />");
lblt_uniprice.Text = ds.Tables[0].Rows[0]["t_uniprice"].ToString();
lblt_vat.Text = ds.Tables[0].Rows[0]["t_vat"].ToString();
lblt_price.Text = ds.Tables[0].Rows[0]["t_price"].ToString();
lblprice_kor.Text = ds.Tables[0].Rows[0]["price_kor"].ToString();
lblprice_num.Text = ds.Tables[0].Rows[0]["price_num"].ToString();
lblPostDate.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Substring(0, 10);
lblReadCount.Text = ds.Tables[0].Rows[0]["ReadCount"].ToString()
.Replace("\r\n", "<br />");
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
if ((lblFileName.Text != null) && (lblFileName.Text != ""))
{
btnFile.Visible = true;
}
else
{
btnFile.Visible = false;
}
}
else
{
lblNoticeError.Text = "잘못된 요청입니다";
}
}
}
//[5]삭제
protected void btnDelete_Click(object sender, ImageClickEventArgs e)
{
//[1]임시변수
int intTemp = 0;
string strAlert = @"<script>alert('삭제되었습니다.');location.href='SCM_NoticeList.aspx';</script>";
try
{
for (int j = 0; j < ctlNoticeList.Rows.Count; j++)
{
CheckBox chkBox = (CheckBox)ctlNoticeList.Rows[j].FindControl("chk");
if (chkBox.Checked)
{
#region 삭제
//[2]Find
for (int i = 0; i < ctlNoticeList.Rows.Count; i++)
{
CheckBox check = (CheckBox)ctlNoticeList.Rows[i].FindControl("chk");
if (check.Checked)
{
//[3]SCM_noticeID
intTemp = Convert.ToInt32(ctlNoticeList.Rows[i].Cells[0].Text);
using (Is.Notice.Bsl.Notice_RTx rBsl = new Is.Notice.Bsl.Notice_RTx())
{
//[4]Delete
SqlConnection con = new SqlConnection(
ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_DeleteSCM_Sales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SCM_SalesID", intTemp);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//[5]변수 초기화
intTemp = 0;
}
//[6]script
Page.RegisterStartupScript("EndScript", strAlert);
#endregion
}
else
{
lblError.Text = "삭제할 항목을 선택하세요";
}
}
}
catch (Exception err)
{
//[7]Exception
//Response.Write(err.Source + " : " + err.Message);
}
}
//Submit
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]임시변수
string strproject = "";
string strContent = "";
string strdate1 = "";
string strcustomer = "";
string strts2 = "";
string strts3 = "";
string strts4 = "";
string strts5 = "";
string strts6 = "";
string strts7 = "";
string strts8 = "";
string strcode1 = "";
string stretc = "";
string strperiod1 = "";
string strdueDate = "";
string strprogress1 = "";
string strcompany = "";
string strlanguage1 = "";
string strtodo = "";
string strtech = "";
string UpfileName = "";
string dbFileName = string.Empty;
string path = "d:\\_Mobile_System\\joblink\\fileUpload\\Notice\\";
string strAlert = @"<script>alert('입력했습니다.');location.href='SCM_NoticeList.aspx';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]변환
strproject = txtproject.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strContent = txtContent.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strdate1 = txtdate1.Text;
strcode1 = txtcode1.Text;
strcustomer = txtcustomer.Text;
stretc = txtetc.Text;
strperiod1 = txtperiod1.Text;
strdueDate = txtdueDate.Text;
strprogress1 = txtprogress1.Text;
strcompany = txtcompany.Text;
strlanguage1 = txtlanguage1.Text;
strtodo = txttodo.Text;
strtech = txttech.Text;
if (strcustomer != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts2 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts3 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts4 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts5 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts6 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts7 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts8 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@project", strproject);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@date1", strdate1);
cmd.Parameters.AddWithValue("@language1", strlanguage1);
cmd.Parameters.AddWithValue("@customer", strcustomer);
cmd.Parameters.AddWithValue("@etc", stretc);
cmd.Parameters.AddWithValue("@period1", strperiod1);
cmd.Parameters.AddWithValue("@dueDate", strdueDate);
cmd.Parameters.AddWithValue("@progress1", strprogress1);
cmd.Parameters.AddWithValue("@company", strcompany);
cmd.Parameters.AddWithValue("@todo", strtodo);
cmd.Parameters.AddWithValue("@tech", strtech);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
/*
* using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
* {
* SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
* SqlCommand cmd = new SqlCommand("UP_AddSCM_Notice", con);
*
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Parameters.AddWithValue("@project", strproject);
* cmd.Parameters.AddWithValue("@Content", strContent);
* cmd.Parameters.AddWithValue("@code1", strcode1);
* cmd.Parameters.AddWithValue("@code2", strcode2);
* cmd.Parameters.AddWithValue("@code3", strcode3);
* cmd.Parameters.AddWithValue("@code4", strcode4);
* cmd.Parameters.AddWithValue("@code5", strcode5);
*
*
* cmd.Parameters.AddWithValue("@upFileName", dbFileName);
* cmd.Parameters.AddWithValue("@upFileName2", dbFileName2);
* cmd.Parameters.AddWithValue("@upFileName3", dbFileName3);
* cmd.Parameters.AddWithValue("@upFileName4", dbFileName4);
* cmd.Parameters.AddWithValue("@upFileName5", dbFileName5);
*
*
*
* cmd.Parameters.AddWithValue("@date1", strdate1);
* cmd.Parameters.AddWithValue("@customer", strcustomer);
* cmd.Parameters.AddWithValue("@ts2", strts2);
* cmd.Parameters.AddWithValue("@ts3", strts3);
* cmd.Parameters.AddWithValue("@ts4", strts4);
* cmd.Parameters.AddWithValue("@ts5", strts5);
*
* cmd.Parameters.AddWithValue("@etc", stretc);
* cmd.Parameters.AddWithValue("@cs2", strcs2);
* cmd.Parameters.AddWithValue("@cs3", strcs3);
* cmd.Parameters.AddWithValue("@cs4", strcs4);
* cmd.Parameters.AddWithValue("@cs5", strcs5);
*
*
* cmd.Parameters.AddWithValue("@period1", strperiod1);
* cmd.Parameters.AddWithValue("@link2", strlink2);
* cmd.Parameters.AddWithValue("@link3", strlink3);
* cmd.Parameters.AddWithValue("@link4", strlink4);
* cmd.Parameters.AddWithValue("@link5", strlink5);
*
* cmd.Parameters.AddWithValue("@dueDate", strdueDate);
* cmd.Parameters.AddWithValue("@Dead2", strDead2);
* cmd.Parameters.AddWithValue("@Dead3", strDead3);
* cmd.Parameters.AddWithValue("@Dead4", strDead4);
* cmd.Parameters.AddWithValue("@Dead5", strDead5);
*
* cmd.Parameters.AddWithValue("@progress1", strprogress1);
* cmd.Parameters.AddWithValue("@Progress2", strProgress2);
* cmd.Parameters.AddWithValue("@Progress3", strProgress3);
* cmd.Parameters.AddWithValue("@Progress4", strProgress4);
* cmd.Parameters.AddWithValue("@Progress5", strProgress5);
*
* cmd.Parameters.AddWithValue("@company", strcompany);
* cmd.Parameters.AddWithValue("@corp2", strcorp2);
* cmd.Parameters.AddWithValue("@corp3", strcorp3);
* cmd.Parameters.AddWithValue("@corp4", strcorp4);
* cmd.Parameters.AddWithValue("@corp5", strcorp5);
*
* con.Open();
* cmd.ExecuteNonQuery();
* con.Close();
* }
*/
//[4]
Response.Write(strAlert);
}
catch (Exception err)
{
//[5]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//텍스트 박스 바인딩
private void DisplayData()
{
//[1]dataset
DataSet ds = null;
try
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[2]Fill
// ds = bsl.ViewNotice(Convert.ToInt32(Request["NoticeID"]));
ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ViewSCM_Order", Convert.ToInt32(Request["SCM_NoticeID"]));
//[3]Bind
txtTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
txtps.Text = ds.Tables[0].Rows[0]["ps"].ToString();
txtts1.Text = ds.Tables[0].Rows[0]["ts1"].ToString();
txtcs1.Text = ds.Tables[0].Rows[0]["cs1"].ToString();
txtlang1.Text = ds.Tables[0].Rows[0]["lang1"].ToString();
txtDead1.Text = ds.Tables[0].Rows[0]["Dead1"].ToString();
txtcode1.Text = ds.Tables[0].Rows[0]["code1"].ToString();
txtContent.Text = ds.Tables[0].Rows[0]["Content"].ToString()
.Replace("\r\n", "<br />");
txtts02.Text = ds.Tables[0].Rows[0]["ts02"].ToString();
txtts03.Text = ds.Tables[0].Rows[0]["ts03"].ToString();
txtts04.Text = ds.Tables[0].Rows[0]["ts04"].ToString();
txtts05.Text = ds.Tables[0].Rows[0]["ts05"].ToString();
txtcs2.Text = ds.Tables[0].Rows[0]["cs2"].ToString();
txtcs3.Text = ds.Tables[0].Rows[0]["cs3"].ToString();
txtcs4.Text = ds.Tables[0].Rows[0]["cs4"].ToString();
txtcs5.Text = ds.Tables[0].Rows[0]["cs5"].ToString();
txtqty1.Text = ds.Tables[0].Rows[0]["qty1"].ToString();
txtqty2.Text = ds.Tables[0].Rows[0]["qty2"].ToString();
txtqty3.Text = ds.Tables[0].Rows[0]["qty3"].ToString();
txtqty4.Text = ds.Tables[0].Rows[0]["qty4"].ToString();
txtqty5.Text = ds.Tables[0].Rows[0]["qty5"].ToString();
txtprice1.Text = ds.Tables[0].Rows[0]["price1"].ToString();
txtprice2.Text = ds.Tables[0].Rows[0]["price2"].ToString();
txtprice3.Text = ds.Tables[0].Rows[0]["price3"].ToString();
txtprice4.Text = ds.Tables[0].Rows[0]["price4"].ToString();
txtprice5.Text = ds.Tables[0].Rows[0]["price5"].ToString();
txtvos1.Text = ds.Tables[0].Rows[0]["vos1"].ToString();
txtvos2.Text = ds.Tables[0].Rows[0]["vos2"].ToString();
txtvos3.Text = ds.Tables[0].Rows[0]["vos3"].ToString();
txtvos4.Text = ds.Tables[0].Rows[0]["vos4"].ToString();
txtvos5.Text = ds.Tables[0].Rows[0]["vos5"].ToString();
txtvos1.Text = ds.Tables[0].Rows[0]["vat1"].ToString();
txtvos2.Text = ds.Tables[0].Rows[0]["vat2"].ToString();
txtvos3.Text = ds.Tables[0].Rows[0]["vat3"].ToString();
txtvos4.Text = ds.Tables[0].Rows[0]["vat4"].ToString();
txtvos5.Text = ds.Tables[0].Rows[0]["vat5"].ToString();
lblFileName.Text = ds.Tables[0].Rows[0]["UpFileName"].ToString();
}
}
catch (Exception err)
{
//[4]예외
Response.Write(err.Source + " : " + err.Message);
}
}
//수정
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]제목과 내용 변수
string strTitle = "";
string strps = "";
string strwt1 = "";
string strContent = "";
string UpfileName = "";
string dbFileName = lblFileName.Text;
//[1-1]script
string strAlert = @"<script>alert('수정했습니다.');location.href='SCM_NoticeView.aspx?SCM_NewsID="
+ Request["SCM_NewsID"]
+ "';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]리플레이스 변환
strTitle = txtTitle.Text;
strContent = txtContent.Text;
strwt1 = txtwt1.Text;
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[1]Excute
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_ModifySCM_ETRI", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@wt1", strwt1)
;
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@SCM_NewsID", Convert.ToInt32(Request["SCM_NewsID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[2]리디렉트..수차후수정
Response.Write(strAlert);
}
catch (Exception err)
{
//[3]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//Submit
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]임시변수
string strTitle = "";
string strContent = "";
string strps = "";
string strts1 = "";
string strts2 = "";
string strts3 = "";
string strts4 = "";
string strts5 = "";
string strts6 = "";
string strts7 = "";
string strts8 = "";
string strcode1 = "";
string strcs1 = "";
string strlink1 = "";
string strDead1 = "";
string strcorp1 = "";
string strlang1 = "";
string strsec1 = "";
string strtech1 = "";
string strts02 = "";
string strts03 = "";
string strts04 = "";
string strts05 = "";
string strcs2 = "";
string strcs3 = "";
string strcs4 = "";
string strcs5 = "";
string strqty1 = "";
string strqty2 = "";
string strqty3 = "";
string strqty4 = "";
string strqty5 = "";
string strprice1 = "";
string strprice2 = "";
string strprice3 = "";
string strprice4 = "";
string strprice5 = "";
string strvos1 = "";
string strvos2 = "";
string strvos3 = "";
string strvos4 = "";
string strvos5 = "";
string strvat1 = "";
string strvat2 = "";
string strvat3 = "";
string strvat4 = "";
string strvat5 = "";
string UpfileName = "";
string dbFileName = string.Empty;
string path = "d:\\_Mobile_System\\joblink\\fileUpload\\Notice\\";
string strAlert = @"<script>alert('입력했습니다.');location.href='SCM_NoticeList.aspx';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\Notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]변환
strTitle = txtTitle.Text
.Replace("&", "&")
.Replace("<", "<")
.Replace(">", ">")
.Replace("\r\n", "<br>")
.Replace("\t", " ");
strps = txtps.Text;
strcode1 = txtcode1.Text;
strts1 = txtts1.Text;
strcs1 = txtcs1.Text;
strlink1 = txtlink1.Text;
strDead1 = txtDead1.Text;
strcorp1 = txtcorp1.Text;
strlang1 = txtlang1.Text;
strsec1 = txtsec1.Text;
strtech1 = txttech1.Text;
strts02 = txtts02.Text;
strts03 = txtts03.Text;
strts04 = txtts04.Text;
strts05 = txtts05.Text;
strcs2 = txtcs2.Text;
strcs3 = txtcs3.Text;
strcs4 = txtcs4.Text;
strcs5 = txtcs5.Text;
strqty1 = txtqty1.Text;
strqty2 = txtqty2.Text;
strqty3 = txtqty3.Text;
strqty4 = txtqty4.Text;
strqty5 = txtqty5.Text;
strprice1 = txtprice1.Text;
strprice2 = txtprice2.Text;
strprice3 = txtprice3.Text;
strprice4 = txtprice4.Text;
strprice5 = txtprice5.Text;
strvos1 = txtvos1.Text;
strvos2 = txtvos2.Text;
strvos3 = txtvos3.Text;
strvos4 = txtvos4.Text;
strvos5 = txtvos5.Text;
strvat1 = txtvat1.Text;
strvat2 = txtvat2.Text;
strvat3 = txtvat3.Text;
strvat4 = txtvat4.Text;
strvat5 = txtvat5.Text;
if (strts1 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts2 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts3 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts4 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts5 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts6 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts7 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
if (strts8 != "")
{
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
/*
* using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
* {
* SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
* SqlCommand cmd = new SqlCommand("UP_AddSCM_Order", con);
*
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Parameters.AddWithValue("@Title", strTitle);
* cmd.Parameters.AddWithValue("@Content", strContent);
* cmd.Parameters.AddWithValue("@code1", strcode1);
* cmd.Parameters.AddWithValue("@code2", strcode2);
* cmd.Parameters.AddWithValue("@code3", strcode3);
* cmd.Parameters.AddWithValue("@code4", strcode4);
* cmd.Parameters.AddWithValue("@code5", strcode5);
*
*
* cmd.Parameters.AddWithValue("@upFileName", dbFileName);
* cmd.Parameters.AddWithValue("@upFileName2", dbFileName2);
* cmd.Parameters.AddWithValue("@upFileName3", dbFileName3);
* cmd.Parameters.AddWithValue("@upFileName4", dbFileName4);
* cmd.Parameters.AddWithValue("@upFileName5", dbFileName5);
*
*
*
* cmd.Parameters.AddWithValue("@ps", strps);
* cmd.Parameters.AddWithValue("@ts1", strts1);
* cmd.Parameters.AddWithValue("@ts2", strts2);
* cmd.Parameters.AddWithValue("@ts3", strts3);
* cmd.Parameters.AddWithValue("@ts4", strts4);
* cmd.Parameters.AddWithValue("@ts5", strts5);
*
* cmd.Parameters.AddWithValue("@cs1", strcs1);
* cmd.Parameters.AddWithValue("@cs2", strcs2);
* cmd.Parameters.AddWithValue("@cs3", strcs3);
* cmd.Parameters.AddWithValue("@cs4", strcs4);
* cmd.Parameters.AddWithValue("@cs5", strcs5);
*
*
* cmd.Parameters.AddWithValue("@link1", strlink1);
* cmd.Parameters.AddWithValue("@link2", strlink2);
* cmd.Parameters.AddWithValue("@link3", strlink3);
* cmd.Parameters.AddWithValue("@link4", strlink4);
* cmd.Parameters.AddWithValue("@link5", strlink5);
*
* cmd.Parameters.AddWithValue("@Dead1", strDead1);
* cmd.Parameters.AddWithValue("@Dead2", strDead2);
* cmd.Parameters.AddWithValue("@Dead3", strDead3);
* cmd.Parameters.AddWithValue("@Dead4", strDead4);
* cmd.Parameters.AddWithValue("@Dead5", strDead5);
*
* cmd.Parameters.AddWithValue("@Progress1", strProgress1);
* cmd.Parameters.AddWithValue("@Progress2", strProgress2);
* cmd.Parameters.AddWithValue("@Progress3", strProgress3);
* cmd.Parameters.AddWithValue("@Progress4", strProgress4);
* cmd.Parameters.AddWithValue("@Progress5", strProgress5);
*
* cmd.Parameters.AddWithValue("@corp1", strcorp1);
* cmd.Parameters.AddWithValue("@corp2", strcorp2);
* cmd.Parameters.AddWithValue("@corp3", strcorp3);
* cmd.Parameters.AddWithValue("@corp4", strcorp4);
* cmd.Parameters.AddWithValue("@corp5", strcorp5);
*
* con.Open();
* cmd.ExecuteNonQuery();
* con.Close();
* }
*/
//[4]
Response.Write(strAlert);
}
catch (Exception err)
{
//[5]Exception
Response.Write(err.Source + " : " + err.Message);
}
}
//수정
protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{
//[1]제목과 내용 변수
string strTitle = "";
string strContent = "";
string strps = "";
string strcode1 = "";
string strts1 = "";
string strcs1 = "";
string strlink1 = "";
string strDead1 = "";
string strlang1 = "";
string strcorp1 = "";
string strsec1 = "";
string strtech1 = "";
string strts02 = "";
string strts03 = "";
string strts04 = "";
string strts05 = "";
string strcs2 = "";
string strcs3 = "";
string strcs4 = "";
string strcs5 = "";
string strqty1 = "";
string strqty2 = "";
string strqty3 = "";
string strqty4 = "";
string strqty5 = "";
string strprice1 = "";
string strprice2 = "";
string strprice3 = "";
string strprice4 = "";
string strprice5 = "";
string strvos1 = "";
string strvos2 = "";
string strvos3 = "";
string strvos4 = "";
string strvos5 = "";
string strvat1 = "";
string strvat2 = "";
string strvat3 = "";
string strvat4 = "";
string strvat5 = "";
string UpfileName = "";
string dbFileName = lblFileName.Text;
//[1-1]script
string strAlert = @"<script>alert('수정했습니다.');location.href='SCM_NoticeView.aspx?SCM_NoticeID="
+ Request["SCM_NoticeID"]
+ "';</script>";
if ((FileUpload1.PostedFile.FileName != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
UpfileName = FileUpload1.PostedFile.FileName;
string SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + UpfileName;
dbFileName = UpfileName;
FileInfo fInfo = new FileInfo(SaveLocation);
string newUpFile = string.Empty;
if (!fInfo.Exists)
{
int fIndex = 0;
string fExtension = fInfo.Extension;
string fRealName = UpfileName.Replace(fExtension, "");
do
{
fIndex++;
dbFileName = fRealName + "" + fIndex.ToString() + fExtension;
SaveLocation = Server.MapPath("~\\fileUpload\\notice\\") + dbFileName;
fInfo = new FileInfo(SaveLocation);
} while (fInfo.Exists);
}
FileUpload1.SaveAs(SaveLocation);
}
try
{
//[2]리플레이스 변환
strTitle = txtTitle.Text;
strContent = txtContent.Text
.Replace("\r\n", "<br />");
strps = txtps.Text;
strts1 = txtts1.Text;
strcs1 = txtcs1.Text;
strDead1 = txtDead1.Text;
strcode1 = txtcode1.Text;
strlang1 = txtlang1.Text;
strts02 = txtts02.Text;
strts03 = txtts03.Text;
strts04 = txtts04.Text;
strts05 = txtts05.Text;
strcs2 = txtcs2.Text;
strcs3 = txtcs3.Text;
strcs4 = txtcs4.Text;
strcs5 = txtcs5.Text;
strqty1 = txtqty1.Text;
strqty2 = txtqty2.Text;
strqty3 = txtqty3.Text;
strqty4 = txtqty4.Text;
strqty5 = txtqty5.Text;
strprice1 = txtprice1.Text;
strprice2 = txtprice2.Text;
strprice3 = txtprice3.Text;
strprice4 = txtprice4.Text;
strprice5 = txtprice5.Text;
strvos1 = txtvos1.Text;
strvos2 = txtvos2.Text;
strvos3 = txtvos3.Text;
strvos4 = txtvos4.Text;
strvos5 = txtvos5.Text;
strvat1 = txtvat1.Text;
strvat2 = txtvat2.Text;
strvat3 = txtvat3.Text;
strvat4 = txtvat4.Text;
strvat5 = txtvat5.Text;
using (Is.Notice.Bsl.Notice_RTx bsl = new Is.Notice.Bsl.Notice_RTx())
{
//[1]Excute
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString);
SqlCommand cmd = new SqlCommand("UP_ModifySCM_Order", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", strTitle);
cmd.Parameters.AddWithValue("@Content", strContent);
cmd.Parameters.AddWithValue("@code1", strcode1);
cmd.Parameters.AddWithValue("@upFileName", dbFileName);
cmd.Parameters.AddWithValue("@ps", strps);
cmd.Parameters.AddWithValue("@lang1", strlang1);
cmd.Parameters.AddWithValue("@ts1", strts1);
cmd.Parameters.AddWithValue("@cs1", strcs1);
cmd.Parameters.AddWithValue("@link1", strlink1);
cmd.Parameters.AddWithValue("@Dead1", strDead1);
cmd.Parameters.AddWithValue("@corp1", strcorp1);
cmd.Parameters.AddWithValue("@sec1", strsec1);
cmd.Parameters.AddWithValue("@tech1", strtech1);
cmd.Parameters.AddWithValue("@ts02", strts02);
cmd.Parameters.AddWithValue("@ts03", strts03);
cmd.Parameters.AddWithValue("@ts04", strts04);
cmd.Parameters.AddWithValue("@ts05", strts05);
cmd.Parameters.AddWithValue("@cs2", strcs2);
cmd.Parameters.AddWithValue("@cs3", strcs3);
cmd.Parameters.AddWithValue("@cs4", strcs4);
cmd.Parameters.AddWithValue("@cs5", strcs5);
cmd.Parameters.AddWithValue("@qty1", strqty1);
cmd.Parameters.AddWithValue("@qty2", strqty2);
cmd.Parameters.AddWithValue("@qty3", strqty3);
cmd.Parameters.AddWithValue("@qty4", strqty4);
cmd.Parameters.AddWithValue("@qty5", strqty5);
cmd.Parameters.AddWithValue("@price1", strprice1);
cmd.Parameters.AddWithValue("@price2", strprice2);
cmd.Parameters.AddWithValue("@price3", strprice3);
cmd.Parameters.AddWithValue("@price4", strprice4);
cmd.Parameters.AddWithValue("@price5", strprice5);
cmd.Parameters.AddWithValue("@vos1", strvos1);
cmd.Parameters.AddWithValue("@vos2", strvos2);
cmd.Parameters.AddWithValue("@vos3", strvos3);
cmd.Parameters.AddWithValue("@vos4", strvos4);
cmd.Parameters.AddWithValue("@vos5", strvos5);
cmd.Parameters.AddWithValue("@vat1", strvat1);
cmd.Parameters.AddWithValue("@vat2", strvat2);
cmd.Parameters.AddWithValue("@vat3", strvat3);
cmd.Parameters.AddWithValue("@vat4", strvat4);
cmd.Parameters.AddWithValue("@vat5", strvat5);
cmd.Parameters.AddWithValue("@SCM_NoticeID", Convert.ToInt32(Request["SCM_NoticeID"]));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//[2]리디렉트..수차후수정
Response.Write(strAlert);
}
catch (Exception err)
{
//[3]Exception
Response.Write(err.Source + " : " + err.Message);
}
}