public ActionResult _SupplierInforPartial(ReportSearchViewModel model) { var SupInfo = new ReportSupInforViewModel(); try { using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.CommandText = "usp_ThongTinCongNoNhaCungCap"; cmd.Parameters.AddWithValue("@SupplierId", model.SupplierId); cmd.Parameters.AddWithValue("@FromDateSup", model.FromDateSup); cmd.Parameters.AddWithValue("@ToDateSup", model.ToDateSup); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { SupInfo = SingleViewSup(dr); } conn.Close(); return(PartialView(SupInfo)); } } } catch { return(PartialView(SupInfo)); } }
public ReportSupInforViewModel ListView(SqlDataReader s) { ReportSupInforViewModel ret = new ReportSupInforViewModel(); try { if (s["SupplierId"] != null) { ret.SupplierId = Int32.Parse(s["SupplierId"].ToString()); } if (s["SupplierName"] != null) { ret.SupplierName = s["SupplierName"].ToString(); } if (s["Phone"] != null) { ret.Phone = s["Phone"].ToString(); } if (s["Email"] != null) { ret.Email = s["Email"].ToString(); } if (s["SoDuNoDauKy"] != DBNull.Value) { ret.SoDuNoDauKy = decimal.Parse(s["SoDuNoDauKy"].ToString()); } if (s["SoDuNoCuoiKy"] != DBNull.Value) { ret.SoDuNoCuoiKy = decimal.Parse(s["SoDuNoCuoiKy"].ToString()); } } catch { } return(ret); }
public ReportSupInforViewModel SingleViewSup(SqlDataReader s) { ReportSupInforViewModel ret = new ReportSupInforViewModel(); try { if (s["SupplierName"] != null) { ret.SupplierName = s["SupplierName"].ToString(); } if (s["Phone"] != null) { ret.Phone = s["Phone"].ToString(); } if (s["Email"] != null) { ret.Email = s["Email"].ToString(); } if (s["Address"] != null) { ret.Address = s["Address"].ToString(); } if (s["ProvinceName"] != null) { ret.ProvinceName = s["ProvinceName"].ToString(); } if (s["DistrictName"] != null) { ret.DistrictName = s["DistrictName"].ToString(); } if (s["BankName"] != null) { ret.BankName = s["BankName"].ToString(); } if (s["BankAccountNumber"] != null) { ret.BankAccountNumber = s["BankAccountNumber"].ToString(); } if (s["BankOwner"] != null) { ret.BankOwner = s["BankOwner"].ToString(); } if (s["NoPhaiTra"] != DBNull.Value) { ret.NoPhaiTra = decimal.Parse(s["NoPhaiTra"].ToString()); } if (s["SoDuNoDauKy"] != DBNull.Value) { ret.SoDuNoDauKy = decimal.Parse(s["SoDuNoDauKy"].ToString()); } if (s["SoDuNoCuoiKy"] != DBNull.Value) { ret.SoDuNoCuoiKy = decimal.Parse(s["SoDuNoCuoiKy"].ToString()); } } catch { } return(ret); }