private SoukoEntity GetSouko()
{
SoukoEntity soukoEntity = new SoukoEntity();
soukoEntity.SoukoCD = txtSouko.Text.ToString();
soukoEntity.SoukoName = txtSoukoName.Text.ToString();
soukoEntity.KanaName = txtKanaName.Text.ToString();
int int_val = 0;
int.TryParse(txtSearch.Text, NumberStyles.Any, CultureInfo.CurrentCulture, out int_val);
soukoEntity.KensakuHyouziJun = int_val.ToString();
soukoEntity.YuubinNO1 = txtYubin1.Text.ToString();
soukoEntity.YuubinNO2 = txtYubin2.Text.ToString();
soukoEntity.Juusho1 = txtAddress1.Text.ToString();
soukoEntity.Juusho2 = txtAddress2.Text.ToString();
soukoEntity.Tel11 = txtPhone1_1.Text.ToString();
soukoEntity.Tel12 = txtPhone1_2.Text.ToString();
soukoEntity.Tel13 = txtPhone1_3.Text.ToString();
soukoEntity.Tel21 = txtPhone2_1.Text.ToString();
soukoEntity.Tel22 = txtPhone2_2.Text.ToString();
soukoEntity.Tel23 = txtPhone2_3.Text.ToString();
soukoEntity.Remarks = txtRemark.Text.ToString();
soukoEntity.Mode = cboMode.SelectedIndex.ToString();
soukoEntity.InsertOperator = base_Entity.OperatorCD;
soukoEntity.UpdateOperator = base_Entity.OperatorCD;
soukoEntity.KeyItem = txtSouko.Text;
soukoEntity.PC = base_Entity.PC;
soukoEntity.ProgramID = base_Entity.ProgramID;
soukoEntity.UsedFlg = 0;
return(soukoEntity);
}
public DataTable Souko_Search(SoukoEntity soukoEntity)
{
CKMDL ckmdl = new CKMDL();
soukoEntity.Sqlprms = new SqlParameter[4];
soukoEntity.Sqlprms[0] = new SqlParameter("@SoukoCD1", SqlDbType.VarChar)
{
Value = soukoEntity.SoukoCD
};
soukoEntity.Sqlprms[1] = new SqlParameter("@SoukoCD2", SqlDbType.VarChar)
{
Value = soukoEntity.Tel11
};
soukoEntity.Sqlprms[2] = new SqlParameter("@SoukoName", SqlDbType.VarChar)
{
Value = soukoEntity.SoukoName
};
soukoEntity.Sqlprms[3] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = soukoEntity.KanaName
};
DataTable dt = ckmdl.SelectDatatable("Souko_Search", GetConnectionString(), soukoEntity.Sqlprms);
return(dt);
}
private void DoDelete(SoukoEntity soukoDelete)
{
SoukoBL souko = new SoukoBL();
string return_Bl = souko.M_Souko_CUD(soukoDelete);
if (return_Bl == "true")
{
bbl.ShowMessage("I101");
}
}
private void initScr()
{
SoukoBL soukoBL = new SoukoBL();
SoukoEntity soukoEntity = new SoukoEntity();
soukoEntity = soukoBL.GetSoukoEntity(soukoEntity);
txtSoukoCD.Text = soukoEntity.SoukoCD;
lblSoukoName.Text = soukoEntity.SoukoName;
chkSeasonSS.Checked = true; //HET
chkSeasonFW.Checked = true; //HET
}
public SoukoEntity GetSoukoEntity(SoukoEntity soukoEntity)
{
soukoEntity.Sqlprms = new SqlParameter[0];
DataTable dtSouko = ckmdl.SelectDatatable("M_Souko_Select", GetConnectionString(), soukoEntity.Sqlprms);
if (dtSouko.Rows.Count > 0)
{
soukoEntity.SoukoCD = dtSouko.Rows[0]["SoukoCD"].ToString();
soukoEntity.SoukoName = dtSouko.Rows[0]["SoukoName"].ToString();
}
return(soukoEntity);
}
private void GridViewBind()
{
SoukoBL bl = new SoukoBL();
SoukoEntity soukoEntity = new SoukoEntity();
soukoEntity.SoukoCD = txtSouko1.Text;
soukoEntity.Tel11 = txtSouko2.Text; //for temp value
soukoEntity.SoukoName = txtSoukoName.Text;
soukoEntity.KanaName = txtKanaName.Text;
DataTable dt = bl.Souko_Search(soukoEntity);
gvSouko.DataSource = dt;
if(dt.Rows.Count == 0) //HET
{
ClearSession();
}
}
private void DBProcess()
{
SoukoEntity soukoEntity = GetSouko();
if (cboMode.SelectedValue.Equals("1"))
{
soukoEntity.Mode = "New";
DoInsert(soukoEntity);
}
else if (cboMode.SelectedValue.Equals("2"))
{
soukoEntity.Mode = "Update";
DoUpdate(soukoEntity);
}
else if (cboMode.SelectedValue.Equals("3"))
{
soukoEntity.Mode = "Delete";
DoDelete(soukoEntity);
}
}
public string M_Souko_CUD(SoukoEntity soukoEntity)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
soukoEntity.Sqlprms = new SqlParameter[22];
soukoEntity.Sqlprms[0] = new SqlParameter("@SoukoCD", SqlDbType.VarChar)
{
Value = soukoEntity.SoukoCD
};
soukoEntity.Sqlprms[1] = new SqlParameter("@SoukoName", SqlDbType.VarChar)
{
Value = soukoEntity.SoukoName
};
soukoEntity.Sqlprms[2] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = soukoEntity.KanaName
};
soukoEntity.Sqlprms[3] = new SqlParameter("@KensakuHyouziJun", SqlDbType.VarChar)
{
Value = soukoEntity.KensakuHyouziJun
};
soukoEntity.Sqlprms[4] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar)
{
Value = soukoEntity.YuubinNO1
};
soukoEntity.Sqlprms[5] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar)
{
Value = soukoEntity.YuubinNO2
};
soukoEntity.Sqlprms[6] = new SqlParameter("@Juusho1", SqlDbType.VarChar)
{
Value = soukoEntity.Juusho1
};
soukoEntity.Sqlprms[7] = new SqlParameter("@Juusho2", SqlDbType.VarChar)
{
Value = soukoEntity.Juusho2
};
soukoEntity.Sqlprms[8] = new SqlParameter("@Tel11", SqlDbType.VarChar)
{
Value = soukoEntity.Tel11
};
soukoEntity.Sqlprms[9] = new SqlParameter("@Tel12", SqlDbType.VarChar)
{
Value = soukoEntity.Tel12
};
soukoEntity.Sqlprms[10] = new SqlParameter("@Tel13", SqlDbType.VarChar)
{
Value = soukoEntity.Tel13
};
soukoEntity.Sqlprms[11] = new SqlParameter("@Tel21", SqlDbType.VarChar)
{
Value = soukoEntity.Tel21
};
soukoEntity.Sqlprms[12] = new SqlParameter("@Tel22", SqlDbType.VarChar)
{
Value = soukoEntity.Tel22
};
soukoEntity.Sqlprms[13] = new SqlParameter("@Tel23", SqlDbType.VarChar)
{
Value = soukoEntity.Tel23
};
soukoEntity.Sqlprms[14] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = soukoEntity.Remarks
};
soukoEntity.Sqlprms[15] = new SqlParameter("@InsertOperator", SqlDbType.VarChar)
{
Value = soukoEntity.InsertOperator
};
soukoEntity.Sqlprms[16] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar)
{
Value = soukoEntity.UpdateOperator
};
soukoEntity.Sqlprms[17] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = soukoEntity.Mode
};
soukoEntity.Sqlprms[18] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = soukoEntity.ProgramID
};
soukoEntity.Sqlprms[19] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = soukoEntity.PC
};
soukoEntity.Sqlprms[20] = new SqlParameter("@KeyItem", SqlDbType.VarChar)
{
Value = soukoEntity.KeyItem
};
soukoEntity.Sqlprms[21] = new SqlParameter("@UsedFlg", SqlDbType.VarChar)
{
Value = soukoEntity.UsedFlg
};
return(ckmdl.InsertUpdateDeleteData("M_Souko_CUD", GetConnectionString(), soukoEntity.Sqlprms));
}
