public static int Insert(TongHopDanhGiaCaNhanThangInfo _tongHopDanhGiaCaNhanThangInfo) { SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("TongHopDanhGiaCaNhanThang_Insert", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@BoPhan", _tongHopDanhGiaCaNhanThangInfo.BoPhan); dbCmd.Parameters.Add("@HoTen", _tongHopDanhGiaCaNhanThangInfo.HoTen); dbCmd.Parameters.Add("@KPI", _tongHopDanhGiaCaNhanThangInfo.KPI); dbCmd.Parameters.Add("@DiemDanhGiaDonVi", _tongHopDanhGiaCaNhanThangInfo.DiemDanhGiaDonVi); dbCmd.Parameters.Add("@LoiNhuanCongTy", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanCongTy); dbCmd.Parameters.Add("@LoiNhuanBoPhan", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanBoPhan); dbCmd.Parameters.Add("@QuanLyCongViecVaPhoiHop", _tongHopDanhGiaCaNhanThangInfo.QuanLyCongViecVaPhoiHop); dbCmd.Parameters.Add("@KyLuatCaNhan", _tongHopDanhGiaCaNhanThangInfo.KyLuatCaNhan); dbCmd.Parameters.Add("@DiemThuong", _tongHopDanhGiaCaNhanThangInfo.DiemThuong); dbCmd.Parameters.Add("@MucDoHoanThanh", _tongHopDanhGiaCaNhanThangInfo.MucDoHoanThanh); dbCmd.Parameters.Add("@XepLoai", _tongHopDanhGiaCaNhanThangInfo.XepLoai); dbCmd.Parameters.Add("@HeSoLuongMem", _tongHopDanhGiaCaNhanThangInfo.HeSoLuongMem); dbCmd.Parameters.Add("@Thang", _tongHopDanhGiaCaNhanThangInfo.Thang); dbCmd.Parameters.Add("@Nam", _tongHopDanhGiaCaNhanThangInfo.Nam); dbCmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; try { dbConn.Open(); dbCmd.ExecuteNonQuery(); return((int)dbCmd.Parameters["@RETURN_VALUE"].Value); } finally { dbConn.Close(); } }
public static void Update(TongHopDanhGiaCaNhanThangInfo _tongHopDanhGiaCaNhanThangInfo) { SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("TongHopDanhGiaCaNhanThang_Update", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@ID", _tongHopDanhGiaCaNhanThangInfo.ID); dbCmd.Parameters.Add("@BoPhan", _tongHopDanhGiaCaNhanThangInfo.BoPhan); dbCmd.Parameters.Add("@HoTen", _tongHopDanhGiaCaNhanThangInfo.HoTen); dbCmd.Parameters.Add("@KPI", _tongHopDanhGiaCaNhanThangInfo.KPI); dbCmd.Parameters.Add("@DiemDanhGiaDonVi", _tongHopDanhGiaCaNhanThangInfo.DiemDanhGiaDonVi); dbCmd.Parameters.Add("@LoiNhuanCongTy", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanCongTy); dbCmd.Parameters.Add("@LoiNhuanBoPhan", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanBoPhan); dbCmd.Parameters.Add("@QuanLyCongViecVaPhoiHop", _tongHopDanhGiaCaNhanThangInfo.QuanLyCongViecVaPhoiHop); dbCmd.Parameters.Add("@KyLuatCaNhan", _tongHopDanhGiaCaNhanThangInfo.KyLuatCaNhan); dbCmd.Parameters.Add("@DiemThuong", _tongHopDanhGiaCaNhanThangInfo.DiemThuong); dbCmd.Parameters.Add("@MucDoHoanThanh", _tongHopDanhGiaCaNhanThangInfo.MucDoHoanThanh); dbCmd.Parameters.Add("@XepLoai", _tongHopDanhGiaCaNhanThangInfo.XepLoai); dbCmd.Parameters.Add("@HeSoLuongMem", _tongHopDanhGiaCaNhanThangInfo.HeSoLuongMem); dbCmd.Parameters.Add("@Thang", _tongHopDanhGiaCaNhanThangInfo.Thang); dbCmd.Parameters.Add("@Year", _tongHopDanhGiaCaNhanThangInfo.Nam); try { dbConn.Open(); dbCmd.ExecuteNonQuery(); } finally { dbConn.Close(); } }
public static TongHopDanhGiaCaNhanThangInfo GetInfo(int _iD) { TongHopDanhGiaCaNhanThangInfo retVal = null; SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("TongHopDanhGiaCaNhanThang_GetInfo", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@ID", _iD); try { dbConn.Open(); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.Read()) { retVal = new TongHopDanhGiaCaNhanThangInfo(); retVal.ID = Convert.ToInt32(dr["ID"]); retVal.BoPhan = Convert.ToString(dr["BoPhan"]); retVal.HoTen = Convert.ToString(dr["HoTen"]); retVal.KPI = Convert.ToDouble(dr["KPI"]); retVal.DiemDanhGiaDonVi = Convert.ToDouble(dr["DiemDanhGiaDonVi"]); retVal.LoiNhuanCongTy = Convert.ToDouble(dr["LoiNhuanCongTy"]); retVal.LoiNhuanBoPhan = Convert.ToDouble(dr["LoiNhuanBoPhan"]); retVal.QuanLyCongViecVaPhoiHop = Convert.ToDouble(dr["QuanLyCongViecVaPhoiHop"]); retVal.KyLuatCaNhan = Convert.ToDouble(dr["KyLuatCaNhan"]); retVal.DiemThuong = Convert.ToDouble(dr["DiemThuong"]); retVal.MucDoHoanThanh = Convert.ToDouble(dr["MucDoHoanThanh"]); retVal.XepLoai = Convert.ToString(dr["XepLoai"]); retVal.HeSoLuongMem = Convert.ToDouble(dr["HeSoLuongMem"]); retVal.Thang = Convert.ToInt32(dr["Thang"]); retVal.Nam = Convert.ToInt32(dr["Nam"]); } if (dr != null) { dr.Close(); } } finally { dbConn.Close(); } return(retVal); }
protected void btnSearch_Click(object sender, EventArgs e) { if (fileImport.HasFile) { if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"))) { Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")); } string date = DateTime.Now.ToString("yyyyMMddHHmmss"); string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"; if (File.Exists(path)) { File.Delete(path); } fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"); if (File.Exists(path)) { DataTable returnTable = ImportExcelToDataTable.ConvertCSVtoDataTable(path); if (returnTable != null && returnTable.Rows.Count > 0) { for (int i = 0; i < returnTable.Rows.Count; i++) { try { DataRow row = returnTable.Rows[i]; #region Import TongHopDanhGiaCaNhanThangInfo info = new TongHopDanhGiaCaNhanThangInfo(); info.BoPhan = row[0].ToString(); info.HoTen = row[1].ToString(); info.KPI = ConvertUtility.ToDouble(row[2].ToString().Replace(".", ",")) * 100; info.DiemDanhGiaDonVi = ConvertUtility.ToDouble(row[3].ToString().Replace(".", ",")) * 100; info.LoiNhuanCongTy = ConvertUtility.ToDouble(row[4].ToString().Replace(".", ",")) * 100; info.LoiNhuanBoPhan = ConvertUtility.ToDouble(row[5].ToString().Replace(".", ",")) * 100; info.QuanLyCongViecVaPhoiHop = ConvertUtility.ToDouble(row[6].ToString().Replace(".", ",")) * 100; info.KyLuatCaNhan = ConvertUtility.ToDouble(row[7].ToString().Replace(".", ",")) * 100; info.DiemThuong = ConvertUtility.ToDouble(row[8].ToString().Replace(".", ",")); info.MucDoHoanThanh = ConvertUtility.ToDouble(row[9].ToString().Replace(".", ",")) * 100; info.XepLoai = row[10].ToString(); info.HeSoLuongMem = ConvertUtility.ToDouble(row[11].ToString().Replace(".", ",")) * 100; info.Nam = ConvertUtility.ToInt32(dropNam.SelectedValue); info.Thang = ConvertUtility.ToInt32(dropThang.SelectedValue); TongHopDanhGiaCaNhanThangController.Insert(info); #endregion } catch { continue; } } lblUpdateStatus.Text = "Bạn đã import thành công file \"" + fileImport.FileName + "\""; } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } }
public static TongHopDanhGiaCaNhanThangInfo GetInfo(int _iD) { TongHopDanhGiaCaNhanThangInfo retVal = null; SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("TongHopDanhGiaCaNhanThang_GetInfo", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@ID", _iD); try { dbConn.Open(); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.Read()) { retVal = new TongHopDanhGiaCaNhanThangInfo(); retVal.ID = Convert.ToInt32(dr["ID"]); retVal.BoPhan = Convert.ToString(dr["BoPhan"]); retVal.HoTen = Convert.ToString(dr["HoTen"]); retVal.KPI = Convert.ToDouble(dr["KPI"]); retVal.DiemDanhGiaDonVi = Convert.ToDouble(dr["DiemDanhGiaDonVi"]); retVal.LoiNhuanCongTy = Convert.ToDouble(dr["LoiNhuanCongTy"]); retVal.LoiNhuanBoPhan = Convert.ToDouble(dr["LoiNhuanBoPhan"]); retVal.QuanLyCongViecVaPhoiHop = Convert.ToDouble(dr["QuanLyCongViecVaPhoiHop"]); retVal.KyLuatCaNhan = Convert.ToDouble(dr["KyLuatCaNhan"]); retVal.DiemThuong = Convert.ToDouble(dr["DiemThuong"]); retVal.MucDoHoanThanh = Convert.ToDouble(dr["MucDoHoanThanh"]); retVal.XepLoai = Convert.ToString(dr["XepLoai"]); retVal.HeSoLuongMem = Convert.ToDouble(dr["HeSoLuongMem"]); retVal.Thang = Convert.ToInt32(dr["Thang"]); retVal.Nam = Convert.ToInt32(dr["Nam"]); } if (dr != null) dr.Close(); } finally { dbConn.Close(); } return retVal; }
public static int Insert(TongHopDanhGiaCaNhanThangInfo _tongHopDanhGiaCaNhanThangInfo) { SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("TongHopDanhGiaCaNhanThang_Insert", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@BoPhan", _tongHopDanhGiaCaNhanThangInfo.BoPhan); dbCmd.Parameters.Add("@HoTen", _tongHopDanhGiaCaNhanThangInfo.HoTen); dbCmd.Parameters.Add("@KPI", _tongHopDanhGiaCaNhanThangInfo.KPI); dbCmd.Parameters.Add("@DiemDanhGiaDonVi", _tongHopDanhGiaCaNhanThangInfo.DiemDanhGiaDonVi); dbCmd.Parameters.Add("@LoiNhuanCongTy", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanCongTy); dbCmd.Parameters.Add("@LoiNhuanBoPhan", _tongHopDanhGiaCaNhanThangInfo.LoiNhuanBoPhan); dbCmd.Parameters.Add("@QuanLyCongViecVaPhoiHop", _tongHopDanhGiaCaNhanThangInfo.QuanLyCongViecVaPhoiHop); dbCmd.Parameters.Add("@KyLuatCaNhan", _tongHopDanhGiaCaNhanThangInfo.KyLuatCaNhan); dbCmd.Parameters.Add("@DiemThuong", _tongHopDanhGiaCaNhanThangInfo.DiemThuong); dbCmd.Parameters.Add("@MucDoHoanThanh", _tongHopDanhGiaCaNhanThangInfo.MucDoHoanThanh); dbCmd.Parameters.Add("@XepLoai", _tongHopDanhGiaCaNhanThangInfo.XepLoai); dbCmd.Parameters.Add("@HeSoLuongMem", _tongHopDanhGiaCaNhanThangInfo.HeSoLuongMem); dbCmd.Parameters.Add("@Thang", _tongHopDanhGiaCaNhanThangInfo.Thang); dbCmd.Parameters.Add("@Nam", _tongHopDanhGiaCaNhanThangInfo.Nam); dbCmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; try { dbConn.Open(); dbCmd.ExecuteNonQuery(); return (int)dbCmd.Parameters["@RETURN_VALUE"].Value; } finally { dbConn.Close(); } }