private void DataGridviewBind() { KouritenEntity obj = new KouritenEntity(); obj.KouritenCD = txtCD1.Text; obj.ChangeDate = Date_Access_Kouriten; obj.KouritenRyakuName = txtCD2.Text;//using tempory for assign data obj.KouritenName = txtName.Text; obj.KanaName = txtKanaName.Text; obj.TokuisakiCD = txtTokuisakiCD1.Text; obj.MailAddress = txtTokuisakiCD2.Text; obj.Juusho1 = txtTokuisakiName.Text; obj.Juusho2 = txtTokuisaki_Kana.Text; obj.Remarks = string.Empty; if (rdo_Date.Checked) { obj.Remarks = "RevisionDate"; } if (rdo_All.Checked) { obj.Remarks = "All"; } KouritenBL objMethod = new KouritenBL(); DataTable dt = objMethod.Kouriten_Search(obj); if (dt.Columns.Contains("CurrentDay")) { if (dt.Rows.Count > 0) { lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]); //dt.Columns.Remove("CurrentDay"); } else { txtCD1.Clear(); txtCD2.Clear(); txtName.Clear(); txtKanaName.Clear(); txtTokuisakiCD1.Clear(); txtTokuisakiCD2.Clear(); txtTokuisakiName.Clear(); txtTokuisaki_Kana.Clear(); txtCD1.Focus(); } } dt.Columns.Remove("CurrentDay"); gv_Kouriten.DataSource = dt; }
private void Access_DB_Object(KouritenEntity obj) { txtCD.Text = obj.KouritenCD; txtLong_Name.Text = obj.KouritenName; txtShort_Name.Text = obj.KouritenRyakuName; lbl_Name.Text = obj.KouritenRyakuName; txtYubin1.Text = obj.YuubinNO1; txtYubin2.Text = obj.YuubinNO2; txtAddress1.Text = obj.Juusho1; txtAddress2.Text = obj.Juusho2; txtPhone1_1.Text = obj.Tel11; txtPhone1_2.Text = obj.Tel12; txtPhone1_3.Text = obj.Tel13; txtPhone2_1.Text = obj.Tel21; txtPhone2_2.Text = obj.Tel22; txtPhone2_3.Text = obj.Tel23; YuuBinNO1 = txtYubin1.Text; YuuBinNO2 = txtYubin2.Text; Address1 = txtAddress1.Text; Address2 = txtAddress2.Text; }
private void Access_DB_Object(KouritenEntity Access_Kouriten_obj) { txtTokuisakiCD1.Text = Access_Kouriten_obj.TokuisakiCD; txtTokuisakiCD2.Text = Access_Kouriten_obj.TokuisakiCD; }
public string M_Kouriten_CUD(KouritenEntity obj) { CKMDL ckmdl = new CKMDL(); ckmdl.UseTran = true; obj.Sqlprms = new SqlParameter[34]; obj.Sqlprms[0] = new SqlParameter("@KouritenCD", SqlDbType.VarChar) { Value = obj.KouritenCD }; obj.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; obj.Sqlprms[2] = new SqlParameter("@ShokutiFLG", SqlDbType.VarChar) { Value = obj.ShokutiFLG }; obj.Sqlprms[3] = new SqlParameter("@KouritenName", SqlDbType.VarChar) { Value = obj.KouritenName }; obj.Sqlprms[4] = new SqlParameter("@KouritenRyakuName", SqlDbType.VarChar) { Value = obj.KouritenRyakuName }; obj.Sqlprms[5] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; obj.Sqlprms[6] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = obj.TokuisakiCD }; obj.Sqlprms[7] = new SqlParameter("@AliasKBN", SqlDbType.VarChar) { Value = obj.AliasKBN }; obj.Sqlprms[8] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar) { Value = obj.YuubinNO1 }; obj.Sqlprms[9] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar) { Value = obj.YuubinNO2 }; obj.Sqlprms[10] = new SqlParameter("@Juusho1", SqlDbType.VarChar) { Value = obj.Juusho1 }; obj.Sqlprms[11] = new SqlParameter("@Juusho2", SqlDbType.VarChar) { Value = obj.Juusho2 }; obj.Sqlprms[12] = new SqlParameter("@Tel11", SqlDbType.VarChar) { Value = obj.Tel11 }; obj.Sqlprms[13] = new SqlParameter("@Tel12", SqlDbType.VarChar) { Value = obj.Tel12 }; obj.Sqlprms[14] = new SqlParameter("@Tel13", SqlDbType.VarChar) { Value = obj.Tel13 }; obj.Sqlprms[15] = new SqlParameter("@Tel21", SqlDbType.VarChar) { Value = obj.Tel21 }; obj.Sqlprms[16] = new SqlParameter("@Tel22", SqlDbType.VarChar) { Value = obj.Tel22 }; obj.Sqlprms[17] = new SqlParameter("@Tel23", SqlDbType.VarChar) { Value = obj.Tel23 }; obj.Sqlprms[18] = new SqlParameter("@TantouBusho", SqlDbType.VarChar) { Value = obj.TantouBusho }; obj.Sqlprms[19] = new SqlParameter("@TantouYakushoku", SqlDbType.VarChar) { Value = obj.TantouYakushoku }; obj.Sqlprms[20] = new SqlParameter("@TantoushaName", SqlDbType.VarChar) { Value = obj.TantoushaName }; obj.Sqlprms[21] = new SqlParameter("@MailAddress", SqlDbType.VarChar) { Value = obj.MailAddress }; obj.Sqlprms[22] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; obj.Sqlprms[23] = new SqlParameter("@TorihikiKaisiDate", SqlDbType.VarChar) { Value = obj.TorihikiKaisiDate }; obj.Sqlprms[24] = new SqlParameter("@TorihikiShuuryouDate", SqlDbType.VarChar) { Value = obj.TorihikiShuuryouDate }; obj.Sqlprms[25] = new SqlParameter("@Remarks", SqlDbType.VarChar) { Value = obj.Remarks }; obj.Sqlprms[26] = new SqlParameter("@KensakuHyouziJun", SqlDbType.VarChar) { Value = obj.KensakuHyouziJun }; obj.Sqlprms[27] = new SqlParameter("@UsedFlg", SqlDbType.VarChar) { Value = obj.UsedFlg }; obj.Sqlprms[28] = new SqlParameter("@InsertOperator", SqlDbType.VarChar) { Value = obj.InsertOperator }; obj.Sqlprms[29] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar) { Value = obj.UpdateOperator }; obj.Sqlprms[30] = new SqlParameter("@Mode", SqlDbType.VarChar) { Value = obj.Mode }; obj.Sqlprms[31] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = obj.ProgramID }; obj.Sqlprms[32] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = obj.PC }; obj.Sqlprms[33] = new SqlParameter("@KeyItem", SqlDbType.VarChar) { Value = obj.KeyItem }; return(ckmdl.InsertUpdateDeleteData("M_Kouriten_CUD", GetConnectionString(), obj.Sqlprms)); }