public TheCustomCheckDetailObj GetTheCustomCheckDetail(int TheCustomCheck)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("OGetTheCustomCheckDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TheCustomCheck", SqlDbType.Int);
cmd.Parameters["@TheCustomCheck"].Value = TheCustomCheck;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
obj.CurrentCustomDetailObj.CompanyName = Convert.ToString(reader["CompanyName"]);
obj.CurrentCustomDetailObj.CompanyPart = Convert.ToString(reader["CompanyPart"]);
obj.CurrentCustomDetailObj.CompanyWebsite = Convert.ToString(reader["CompanyWebsite"]);
obj.CurrentCustomDetailObj.CustomName = Convert.ToString(reader["CustomName"]);
obj.CurrentCustomDetailObj.CustomCellphone = Convert.ToString(reader["CustomCellphone"]);
obj.CurrentCustomDetailObj.CustomPhone = Convert.ToString(reader["CustomPhone"]);
obj.CurrentCustomDetailObj.CustomFenji = Convert.ToString(reader["CustomFenji"]);
obj.CurrentCustomDetailObj.QQorMSN = Convert.ToString(reader["QQorMSN"]);
obj.CurrentCustomDetailObj.Email = Convert.ToString(reader["Email"]);
obj.CurrentCustomDetailObj.BusinessID = Convert.ToInt32(reader["BusinessID"]);
obj.CurrentCustomDetailObj.ProvinceID = Convert.ToInt32(reader["ProvinceID"]);
obj.CurrentCustomDetailObj.CountryID = Convert.ToInt32(reader["CountryID"]);
obj.CurrentCustomDetailObj.CityID = Convert.ToInt32(reader["CityID"]);
obj.CurrentCustomDetailObj.Address = Convert.ToString(reader["Address"]);
obj.CurrentCustomDetailObj.PS = Convert.ToString(reader["PS"]);
obj.InCheckCustomDetailObj.CompanyName = Convert.ToString(reader["OldCompanyName"]);
obj.InCheckCustomDetailObj.CompanyPart = Convert.ToString(reader["OldCompanyPart"]);
obj.InCheckCustomDetailObj.CompanyWebsite = Convert.ToString(reader["OldCompanyWebsite"]);
obj.InCheckCustomDetailObj.CustomName = Convert.ToString(reader["OldCustomName"]);
obj.InCheckCustomDetailObj.CustomCellphone = Convert.ToString(reader["OldCustomCellphone"]);
obj.InCheckCustomDetailObj.CustomPhone = Convert.ToString(reader["OldCustomPhone"]);
obj.InCheckCustomDetailObj.CustomFenji = Convert.ToString(reader["OldCustomFenji"]);
obj.InCheckCustomDetailObj.QQorMSN = Convert.ToString(reader["OldQQorMSN"]);
obj.InCheckCustomDetailObj.Email = Convert.ToString(reader["OldEmail"]);
obj.InCheckCustomDetailObj.BusinessID = Convert.ToInt32(reader["OldBusinessID"]);
obj.InCheckCustomDetailObj.ProvinceID = Convert.ToInt32(reader["OldProvinceID"]);
obj.InCheckCustomDetailObj.CountryID = Convert.ToInt32(reader["OldCountryID"]);
obj.InCheckCustomDetailObj.CityID = Convert.ToInt32(reader["OldCityID"]);
obj.InCheckCustomDetailObj.Address = Convert.ToString(reader["OldAddress"]);
obj.InCheckCustomDetailObj.PS = Convert.ToString(reader["OldPS"]);
}
reader.Close();
con.Close();
return obj;
}
}