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));
}
