private void Form매입등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(inputRmGrid);
ComInfo.gridHeaderSet(inputGrid);
init_ComboBox();
StringBuilder sb = new StringBuilder();
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
end_date.Text = DateTime.Today.ToString("yyyy-MM-dd");
sb.AppendLine("WHERE A.BUY_DATE >= '" + start_date.Text.ToString() + "' and A.BUY_DATE <= '" + end_date.Text.ToString() + "' ");
SalesGrid(inputGrid, sb.ToString()); //날짜, 거래처명 or 상품명
//SalesMain();
//SalesDetail();
}
private void frmHACCP기준등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataChkGrid);
HACCP_list();
init_ComboBox();
}
private void frm원자재투입현황_Load(object sender, EventArgs e)
{
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
ComInfo.gridHeaderSet(rawOutGrid);
init_ComboBox();
}
private void frm공정코드등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataFlowGrid);
btnDelete.Enabled = false;
init_ComboBox();
flow_list();
}
private void frm씨지엠출고지시현황_Load(object sender, EventArgs e)
{
//input_list(tdInputGrid, "where convert(varchar(10), Z.INTIME, 120) = convert(varchar(10), getDate(), 120) ");
//input_list(inputGrid, "where Z.INPUT_DATE >= '" + start_date.Text.ToString() + "' and Z.INPUT_DATE <= '" + end_date.Text.ToString() + "'");
ComInfo.gridHeaderSet(inputGrid);
ComInfo.gridHeaderSet(ProductGrid);
ComInfo.gridHeaderSet(InputTempGrid);
DataGridViewCellStyle cellStyle = new DataGridViewCellStyle();
cellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
cellStyle.BackColor = Color.FromArgb(210, 219, 254);
DataGridViewCellStyle cellStyle2 = new DataGridViewCellStyle();
cellStyle2.Alignment = DataGridViewContentAlignment.MiddleCenter;
cellStyle2.BackColor = Color.FromArgb(227, 210, 254);
btnSave.Enabled = false;
for (int i = 0; i < 8; i++)
{
ProductGrid.Columns[i].HeaderCell.Style = cellStyle;
}
for (int i = 8; i < 10; i++)
{
ProductGrid.Columns[i].HeaderCell.Style = cellStyle2;
}
lbl_usual.BackColor = Color.FromArgb(97, 143, 253);
lbl_plan.BackColor = Color.FromArgb(148, 97, 253);
input_list("WHERE 1=1");
txt_approval_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
private void frm원자재등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataRawCdGrid);
init_ComboBox();
raw_list();
}
private void frm작업일보관리2_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
ComInfo.gridHeaderSet(MadeGrid);
ComInfo.gridHeaderSet(ToipGrid);
}
private void frmBack_Load(object sender, EventArgs e)
{
notice_ExpertDate(sender, e);
string today = DateTime.Today.AddMonths(0).ToString("yyyy-MM-dd");
Srch_by_LotNo("L" + today.Replace("-", "").Substring(2));
ComInfo.gridHeaderSet(MadeGrid);
updateList(sender, e);
notice_ExpertDate(sender, e);
timer = new Timer();
timer.Enabled = true;
timer.Interval = 1000;
timer.Tick += new EventHandler(twin);
timer.Start();
timer2 = new Timer();
timer2.Enabled = true;
timer2.Interval = 60000;
timer2.Tick += new EventHandler(notice_ExpertDate);
timer2.Tick += new EventHandler(updateList);
timer2.Start();
}
public static bool p_Isdel = true; // 삭제 권한
private void frm제품출고원장_Load(object sender, EventArgs e)
{
addButton(txtType, 0);
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
if (Common.p_strUserAdmin != "5")
{
DataTable dtcheck = wnDm.fn_auth_check(lbl_title.Tag.ToString().Split('$')[0], lbl_title.Tag.ToString().Split('$')[1]);
p_IsAuth = dtcheck.Rows[0]["auth_yn"].ToString() == "Y" ? true : false;
p_Isrgstr = dtcheck.Rows[0]["rgstr_yn"].ToString() == "Y" ? true : false;
p_Isdel = dtcheck.Rows[0]["del_yn"].ToString() == "Y" ? true : false;
try
{
if (!p_IsAuth)
{
this.BeginInvoke(new MethodInvoker(Close));
/// MessageBox.Show("권한이없습니다.");
}
}
catch (Exception ex)
{
}
}
cboType.SelectedIndex = 0;
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
GridList();
ComInfo.gridHeaderSet(itemOutGrid);
}
private void frm생산계획등록_Load(object sender, EventArgs e)
{
//DateTime today = DateTime.Today.AddMonths(-1);
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
itemPlanGridAdd();
plan_list(planGrid, "where A.PLAN_DATE >= '" + start_date.Text.ToString() + "' and A.PLAN_DATE <= '" + end_date.Text.ToString() + "'");
del_planGrid.AllowUserToAddRows = false;
del_planGrid.Columns.Add("PLAN_DATE", "PLAN_DATE");
del_planGrid.Columns.Add("PLAN_CD", "PLAN_CD");
del_planGrid.Columns.Add("SEQ", "SEQ");
del_HalfGrid.AllowUserToAddRows = false;
del_HalfGrid.Columns.Add("PLAN_DATE", "PLAN_DATE");
del_HalfGrid.Columns.Add("PLAN_CD", "PLAN_CD");
del_HalfGrid.Columns.Add("SEQ", "SEQ");
pHalfGrid.AllowUserToAddRows = false;
for (int i = 0; i < itemHalfGrid.Columns.Count; i++)
{
pHalfGrid.Columns.Add(itemHalfGrid.Columns[i].Name.ToString(), itemHalfGrid.Columns[i].Name.ToString());
}
pHalfGrid.Columns.Add("F_LEVEL", "F_LEVEL");
pHalfGrid.Columns.Add("TOP_ITEM_CD", "TOP_ITEM_CD");
ComInfo.gridHeaderSet(itemPlanGrid);
ComInfo.gridHeaderSet(planGrid);
}
private void pop계산서매출검색_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(GridRecord);
start_date.Text = DateTime.Now.ToString().Substring(0, 8) + "01";
lbl_cust_nm.Text = sName;
ComInfo cominfo = new ComInfo();
wnGConstant wConst = new wnGConstant();
string sqlQuery = "";
cmb_vat_cd.ValueMember = "코드";
cmb_vat_cd.DisplayMember = "명칭";
sqlQuery = cominfo.queryVatAll();
wConst.ComboBox_Read_NoBlank(cmb_vat_cd, sqlQuery);
cmb_vat_cd.SelectedValue = sVatCd;
rsTable.Columns.Add("매출일자");
rsTable.Columns.Add("번호");
rsTable.Columns.Add("순번");
rsTable.Columns.Add("부가세구분");
rsTable.Columns.Add("상품명");
rsTable.Columns.Add("규격");
rsTable.Columns.Add("총수량");
rsTable.Columns.Add("단가");
rsTable.Columns.Add("금액");
rsTable.Columns.Add("상품코드");
rsTable.Columns.Add("상품구분");
bindData("where B.CUST_CD = '" + sCode + "' and A.SALES_DATE >= '" + start_date.Text + "' and A.SALES_DATE <= '" + end_date.Text + "' and A.ESCALATION_YN = 'N' ");
}
private void frm지육산출물등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(sourceRawGrid);
ComInfo.gridHeaderSet(dataItemGrid);
init_ComboBox();
item_list();
}
private void frm거래처등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataCustGrid);
init_ComboBox();
cust_list();
resetSetting();
}
private void frm원자재재고현황_Load(object sender, EventArgs e)
{
init_ComboBox();
grdCellSetting();
grdListPrint();
ComInfo.gridHeaderSet(rawStockGrid);
ComInfo.gridHeaderSet(rawDetailGrid);
}
private void frm매입처원장_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(inputRmGrid);
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
grdCellSetting();
init_ComboBox();
}
private void frm지육입고및공정_Load(object sender, EventArgs e)
{
lbl_input_gbn.Text = "";
input_list(tdInputGrid, "where convert(varchar(10), A.INTIME, 120) = convert(varchar(10), getDate(), 120) ");
init_ComboBox();
ComInfo.gridHeaderSet(tdInputGrid);
ComInfo.gridHeaderSet(inputGrid);
ComInfo.gridHeaderSet(sourceRawGrid);
}
private void frmHACCP등록_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(ccpChkGrid);
ComInfo.gridHeaderSet(dataCcpGrid);
get_user_nm();
getHaccpGrid();
resetSetting();
input_list(dataCcpGrid, "where A.INPUT_DATE >= '" + start_date.Text.ToString() + "' and A.INPUT_DATE <= '" + end_date.Text.ToString() + "'");
}
private void frm일일매입원장_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
ComInfo.gridHeaderSet(inputRmGrid);
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
grdCellSetting();
}
private void frm사용자관리_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataUserGrid);
ComInfo.gridHeaderSet(dataDeptGrid);
ComInfo.gridHeaderSet(dataPosGrid);
btnDelete.Enabled = false;
init_ComboBox();
user_list();
//this.dtp거래개시일.Text = DateTime.Parse(dt.Rows[0]["REG_DATE"].ToString().Trim().Replace(" ", "")).ToString("yyyy-MM-dd");
}
private void frmHACCP관련파일관리_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(HaccpGrid1);
ComInfo.gridHeaderSet(HaccpGrid2);
ComInfo.gridHeaderSet(HaccpGrid3);
txt_staff_cd.Text = Common.p_strStaffNo;
txt_staff_nm.Text = Common.p_strUserName;
txt_lower_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
resetSetting();
initComboBox();
fn_insert_list("where STAFF_CD = '" + txt_staff_cd.Text + "' and INPUT_DATE >= '" + txt_lower_date.Text + "' and INPUT_DATE <= '" + txt_upper_date.Text + "' "
+ ((txt_docs_srch.Text == null || txt_docs_srch.Text.ToString().Equals("")) ? "" : "and FNAME like '%" + txt_docs_srch.Text.ToString() + "%' "));
}
private void frm수금등록_Load(object sender, EventArgs e)
{
string sqlQuery = "";
//납품처리방법
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = new 스마트팩토리.Model.Query.scQuery().queryTSCode("910");
wConst.ComboBox_Read_NoBlank(cmb_gubun, sqlQuery);
grdSooLoad();
ComInfo.gridHeaderSet(grd_soo);
ComInfo.gridHeaderSet(collectGrid);
}
private void frm기초코드조회_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(tsGrid);
wnDm wDm = new wnDm();
DataTable dt = wDm.fn_tscode_list();
for (int i = 0; i < dt.Rows.Count; i++)
{
tsGrid.Rows.Add();
tsGrid.Rows[i].Cells["L_CODE"].Value = dt.Rows[i]["L_CODE"].ToString();
tsGrid.Rows[i].Cells["S_CODE"].Value = dt.Rows[i]["S_CODE"].ToString();
tsGrid.Rows[i].Cells["ORD"].Value = dt.Rows[i]["ORD"].ToString();
tsGrid.Rows[i].Cells["S_CODE_NM"].Value = dt.Rows[i]["S_CODE_NM"].ToString();
}
}
private void frm단가관리_Load(object sender, EventArgs e)
{
//dt = new MES.Model.Query.scQuery().selectPriceInfoSearch();
//grdLoad(dt);
string sqlQuery = "";
cbo_cust.ValueMember = "코드";
cbo_cust.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustSell();
wConst.ComboBox_Read_NoBlank(cbo_cust, sqlQuery);
//cbo_cust.SelectedIndex = 0;
ComInfo.gridHeaderSet(grd_ucost);
}
private void frm주문서등록_Load(object sender, EventArgs e)
{
//DateTime today = DateTime.Today.AddMonths(-1);
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
req_date.Text = DateTime.Today.AddDays(7).ToString("yyyy-MM-dd");
txt_jumun_date.Text = DateTime.Today.ToString("yyyy-MM-dd");
del_jumunGrid.Columns.Add("JUMUN_DATE");
del_jumunGrid.Columns.Add("JUMUN_CD");
del_jumunGrid.Columns.Add("SEQ");
ComInfo.gridHeaderSet(itemJumunGrid);
ComInfo.gridHeaderSet(JumunGrid);
jumun_list();
}
private void pop계산서수금검색_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(GridRecord);
start_date.Text = DateTime.Now.ToString().Substring(0, 8) + "01";
lbl_cust_nm.Text = sName;
ComInfo cominfo = new ComInfo();
wnGConstant wConst = new wnGConstant();
string sqlQuery = "";
rsTable.Columns.Add("수금일자");
rsTable.Columns.Add("번호");
rsTable.Columns.Add("수금액");
rsTable.Columns.Add("할인액");
rsTable.Columns.Add("합계금액");
rsTable.Columns.Add("비고");
rsTable.Columns.Add("구분");
bindData("where A.CUST_CD = '" + sCode + "' and A.SOO_DATE >= '" + start_date.Text + "' and A.SOO_DATE <= '" + end_date.Text + "' ");
}
private void frm씨지엠출고지시_Load(object sender, EventArgs e)
{
//input_list(tdInputGrid, "where convert(varchar(10), Z.INTIME, 120) = convert(varchar(10), getDate(), 120) ");
//input_list(inputGrid, "where Z.INPUT_DATE >= '" + start_date.Text.ToString() + "' and Z.INPUT_DATE <= '" + end_date.Text.ToString() + "'");
ComInfo.gridHeaderSet(inputGrid);
ComInfo.gridHeaderSet(ProductGrid);
ComInfo.gridHeaderSet(InputTempGrid);
DataGridViewCellStyle cellStyle = new DataGridViewCellStyle();
cellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
cellStyle.BackColor = Color.FromArgb(210, 219, 254);
DataGridViewCellStyle cellStyle2 = new DataGridViewCellStyle();
cellStyle2.Alignment = DataGridViewContentAlignment.MiddleCenter;
cellStyle2.BackColor = Color.FromArgb(227, 210, 254);
for (int i = 0; i < 8; i++)
{
ProductGrid.Columns[i].HeaderCell.Style = cellStyle;
}
for (int i = 8; i < 11; i++)
{
ProductGrid.Columns[i].HeaderCell.Style = cellStyle2;
}
lbl_usual.BackColor = Color.FromArgb(97, 143, 253);
lbl_plan.BackColor = Color.FromArgb(148, 97, 253);
ProductGrid.Columns["BTN_INPUT"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
input_list("WHERE 1=1 AND A.COMPLETE_YN = 'N' ");
del_inputTable.Columns.Add("JISI_DATE");
del_inputTable.Columns.Add("JISI_CD");
del_inputTable.Columns.Add("JISI_SEQ");
}
private void frm지출등록_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
init_ComboBox();
del_srchGrid.AllowUserToAddRows = false;
del_inputGrid.Columns.Add("PAY_DATE");
del_inputGrid.Columns.Add("PAY_CD");
del_inputGrid.Columns.Add("SEQ");
txt_instaff.Text = Common.p_strUserName;
resetSetting();
ComInfo.gridHeaderSet(dgv_main);
ComInfo.gridHeaderSet(dgv_srch);
ComInfo.gridHeaderSet(dgv_staff);
}
private void frm견적서등록_Load(object sender, EventArgs e)
{
//DateTime today = DateTime.Today.AddMonths(-1);
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
itemEstimateGridAdd();
esti_list(estiGrid, "where A.ESTI_DATE >= '" + start_date.Text.ToString() + "' and A.ESTI_DATE <= '" + end_date.Text.ToString() + "'");
del_estiGrid.Columns.Add("ESTI_DATE");
del_estiGrid.Columns.Add("ESTI_CD");
del_estiGrid.Columns.Add("SEQ");
ComInfo.gridHeaderSet(itemEstimateGrid);
ComInfo.gridHeaderSet(estiGrid);
TotalSumGrid.Rows.Add();
}
private void frm수금등록_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
string sqlQuery = "";
ComInfo comInfo = new ComInfo();
//납품처리방법
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.querySooGubun();
wConst.ComboBox_Read_NoBlank(cmb_gubun, sqlQuery);
grdSooLoad();
ComInfo.gridHeaderSet(grd_soo);
ComInfo.gridHeaderSet(collectGrid);
}
private void frm제품재고현황_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(dataItemGrid);
ComInfo.gridHeaderSet(ItemDetailGrid);
}