private void btCreate_Click(object sender, EventArgs e)
{
try
{
List <string[]> rceDetail = new List <string[]>();
string id = DvItem.Rows[0].Cells[1].Value.ToString();
id = id.Substring(0, 3);
Received received = new Received();
DataTable dt = new DataTable();
DataTable companydt = new DataTable();
MySqlDataAdapter da = received.limitPrice(id);
MySqlDataAdapter company = received.componyName((DvItem.Rows[0].Cells[1]).Value.ToString());
company.Fill(companydt);
String companyName = companydt.Rows[0][0].ToString();
da.Fill(dt);
string lbprice = LbPrice.Text.ToString();
Regex re = new Regex(@"[^\-*0-9]");
string price = re.Replace(lbprice, "");
Console.WriteLine(price);
Console.WriteLine(int.Parse(price));
Console.WriteLine(int.Parse(dt.Rows[0][0].ToString()));
if (int.Parse(price) < int.Parse(dt.Rows[0][0].ToString()))
{
Dictionary <string, string> replaceKeywordDic = new Dictionary <string, string>();
Dictionary <string, bool> areacutKeywordDic = new Dictionary <string, bool>();
DateTime now = DateTime.Now;
int month = now.Month;
int day = now.Day;
int year = now.Year;
replaceKeywordDic.Add("total", String.Format("{0:#,0}", int.Parse(price)) + "円");
replaceKeywordDic.Add("COMPANY_NAME", companyName);
replaceKeywordDic.Add("MONTH", month.ToString());
replaceKeywordDic.Add("YEAR", year.ToString());
replaceKeywordDic.Add("DAY", day.ToString());
replaceKeywordDic.Add("ODERID", (DvItem.Rows[0].Cells[1]).Value.ToString());
int j = 0;
for (int i = 0; j < 10; j++)
{
for (; i < DvItem.Rows.Count; i++)
{
if (DvItem.Rows[i].Cells[0].Value == null)
{
continue;
}
if ((bool)DvItem.Rows[i].Cells[0].Value)
{
string[] rce = new string[7];
string work = DvItem.Rows[i].Cells[8].Value.ToString();
if (DvItem.Rows[i].Cells["trade_flg"].Value.ToString() == "U")
{
work = "-" + work;
}
rce[0] = DvItem.Rows[i].Cells[2].Value.ToString();
rce[1] = DvItem.Rows[i].Cells[3].Value.ToString();
rce[2] = DvItem.Rows[i].Cells[4].Value.ToString();
rce[3] = DvItem.Rows[i].Cells[5].Value.ToString();
rce[4] = DvItem.Rows[i].Cells[6].Value.ToString();
rce[5] = DvItem.Rows[i].Cells[7].Value.ToString();
rce[6] = work;
rceDetail.Add(rce);
replaceKeywordDic.Add("CAR" + j, DvItem.Rows[i].Cells[4].Value.ToString());
replaceKeywordDic.Add("year" + j, DvItem.Rows[i].Cells[3].Value.ToString());
replaceKeywordDic.Add("medel" + j, DvItem.Rows[i].Cells[5].Value.ToString());
replaceKeywordDic.Add("grade" + j, DvItem.Rows[i].Cells[6].Value.ToString());
replaceKeywordDic.Add("price" + j, String.Format("{0:#,0}", System.Math.Abs(Convert.ToInt32(DvItem.Rows[i].Cells[8].Value.ToString()))) + "円");
j++;
}
}
replaceKeywordDic.Add("CAR" + j, "");
replaceKeywordDic.Add("year" + j, "");
replaceKeywordDic.Add("medel" + j, "");
replaceKeywordDic.Add("grade" + j, "");
replaceKeywordDic.Add("price" + j, "");
}
areacutKeywordDic.Add("USE_X86", true);
areacutKeywordDic.Add("USE_SPARC", false);
EditWord editWord = new EditWord();
editWord.DocFile = Path.path + "\\word\\受注書\\" + (DvItem.Rows[0].Cells[1]).Value.ToString() + "oder.doc";
String pdfPath = Path.path + "\\pdf\\受注書\\" + (DvItem.Rows[0].Cells[1]).Value.ToString() + "oder.pdf";
editWord.TmpFile = Path.path + "\\tmp\\oder.doc"; //テンプレファイル
editWord.Edit(replaceKeywordDic, areacutKeywordDic);
editWord.pdf(editWord.DocFile, pdfPath);
received.rceInsert((DvItem.Rows[0].Cells[1]).Value.ToString(), pdfPath, rceDetail);
MessageBox.Show("受注書が作成されました", "確認", MessageBoxButtons.OK);
DataTable tb = new DataTable();
DvItem.DataSource = tb;
DvItem.Columns.Clear();
LbPrice.Text = "合計0円";
}
else
{
MessageBox.Show("売掛金が不足しています。", "エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public AuctionSelectSell()
{
InitializeComponent();
DataGridViewComboBoxColumn auctionCom = new DataGridViewComboBoxColumn();
DataGridViewTextBoxColumn dateCom = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn numCom = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn quote_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn quote_detail_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn model_year = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn car_name = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn model = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn grade = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn remarks = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn quote_price = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn sales_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn purchase_order_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn listing_slip_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn buy_progress_flg = new DataGridViewTextBoxColumn();
quote_id.DataPropertyName = "rce_order_id";
quote_id.Name = "rce_order_id";
quote_detail_id.DataPropertyName = "rce_order_detail_id";
quote_detail_id.Name = "rce_order_detail_id";
model_year.DataPropertyName = "model_year";
model_year.Name = "model_year";
car_name.DataPropertyName = "car_name";
model.DataPropertyName = "model";
grade.DataPropertyName = "grade";
remarks.DataPropertyName = "remarks";
quote_price.DataPropertyName = "quote_price";
sales_id.DataPropertyName = "sales_id";
purchase_order_id.DataPropertyName = "purchase_order_id";
listing_slip_id.DataPropertyName = "listing_slip_id";
buy_progress_flg.DataPropertyName = "buy_progress_flag";
quote_price.HeaderText = "見積もり金額";
remarks.HeaderText = "メモ";
grade.HeaderText = "グレード";
model.HeaderText = "モデル";
car_name.HeaderText = "車名";
model_year.HeaderText = "型年";
quote_detail_id.HeaderText = "見積詳細ID";
quote_id.HeaderText = "見積ID";
sales_id.HeaderText = "売上ID";
purchase_order_id.HeaderText = "発注書ID";
listing_slip_id.HeaderText = "出品ID";
buy_progress_flg.HeaderText = "購入状態";
Auction auction = new Auction();
string[] auctionName = auction.auctionNameGet();
for (int i = 0; i < auctionName.Length; i++)
{
auctionCom.Items.Add(auctionName[i]);
}
dvAuction.Columns.Insert(0, auctionCom);
dvAuction.Columns.Insert(1, numCom);
dvAuction.Columns.Insert(2, dateCom);
dvAuction.Columns.Insert(3, quote_id);
dvAuction.Columns.Insert(4, quote_detail_id);
dvAuction.Columns.Insert(5, quote_price);
dvAuction.Columns.Insert(6, car_name);
dvAuction.Columns.Insert(7, grade);
dvAuction.Columns.Insert(8, model);
dvAuction.Columns.Insert(9, model_year);
dvAuction.Columns.Insert(10, remarks);
dvAuction.Columns.Insert(11, sales_id);
dvAuction.Columns.Insert(12, purchase_order_id);
dvAuction.Columns.Insert(13, listing_slip_id);
dvAuction.Columns.Insert(14, buy_progress_flg);
auctionCom.HeaderText = "オークション会場";
auctionCom.DataPropertyName = "auction";
auctionCom.Name = "auction";
dateCom.HeaderText = "オークション日";
dateCom.DataPropertyName = "auction_date";
dateCom.Name = "auction_date";
numCom.HeaderText = "出品番号";
numCom.DataPropertyName = "auction_no";
numCom.Name = "auction_no";
string id = "1";
Received received = new Received();
MySqlDataAdapter da = received.orderDetail(id);
DataTable dt = new DataTable();
da.Fill(dt);
dvAuction.DataSource = dt;
dvAuction.AllowUserToAddRows = false;
}
private void search_Click(object sender, EventArgs e)
{
EstimateSharch estimate = new EstimateSharch();
estimate.ShowDialog();
string ids = estimate.Ids;
Received receive = new Received();
MySqlDataAdapter item = receive.QuiteItem(ids);
if (item != null)
{
DvItem.Columns.Clear();
LbPrice.Text = "合計0円";
DataGridViewCheckBoxColumn check = new DataGridViewCheckBoxColumn();
DataGridViewTextBoxColumn quote_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn quote_detail_id = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn model_year = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn car_name = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn model = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn grade = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn remarks = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn quote_price = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn trade_flg = new DataGridViewTextBoxColumn();
trade_flg.DataPropertyName = "trade_flg";
trade_flg.Name = "trade_flg";
quote_id.DataPropertyName = "quote_id";
quote_detail_id.DataPropertyName = "quote_detail_id";
model_year.DataPropertyName = "model_year";
car_name.DataPropertyName = "car_name";
model.DataPropertyName = "model";
grade.DataPropertyName = "grade";
remarks.DataPropertyName = "remarks";
quote_price.DataPropertyName = "abs(`quote_price`)";
quote_price.Name = "abs(`quote_price`)";
quote_price.HeaderText = "見積もり金額";
remarks.HeaderText = "メモ";
grade.HeaderText = "グレード";
model.HeaderText = "モデル";
car_name.HeaderText = "車名";
model_year.HeaderText = "型年";
quote_detail_id.HeaderText = "見積詳細ID";
quote_id.HeaderText = "見積ID";
trade_flg.HeaderText = "売買フラグ";
check.DataPropertyName = "select";
check.HeaderText = "選択";
DvItem.Columns.Insert(0, check);
DvItem.Columns.Insert(1, quote_id);
DvItem.Columns.Insert(2, quote_detail_id);
DvItem.Columns.Insert(3, quote_price);
DvItem.Columns.Insert(4, car_name);
DvItem.Columns.Insert(5, grade);
DvItem.Columns.Insert(6, model);
DvItem.Columns.Insert(7, model_year);
DvItem.Columns.Insert(8, remarks);
DvItem.Columns.Insert(9, trade_flg);
DataTable dt = new DataTable();
item.Fill(dt);
DvItem.DataSource = dt;
}
DvItem.AllowUserToAddRows = false;
}
