public StudCareRecordAddItemForm(List<string> itemList,DAO.CareRecordItemManager.ItemType itmType) { InitializeComponent(); this.MaximumSize = this.MinimumSize = this.Size; _itemList = itemList; _itemType = itmType; }
/// <summary> /// Método que lista todas os fornecedores. /// </summary> /// <param name="listSession">Sessão do Hibernate sendo utilizada.</param> /// <param name="todos">Se a listagem for de fornecedores ativos e inativos, coloque 'true'.</param> /// <param name="strings">Adicione Strings que serão postas na mesma coleção da consulta.</param> /// <returns>IList</returns> public static IList<Fornecedor> ListarGeral(ISession listSession, Boolean todos, params string[] strings) { try { IList<Fornecedor> ilista = null; if (todos) { ilista = new DAO<Fornecedor>(listSession).Listar(); } else { ilista = new DAO<Fornecedor>(listSession).ListarWhere("ativo", true); } for (var i = 0; i < strings.Count(); i++) { ilista.Insert(i, new Fornecedor {nome = strings[i], idFornecedor = i}); } return ilista; } catch (GenericADOException gae) { MessageLogs.GenericADOExceptionLog(gae); return null; } catch (TransactionException te) { MessageLogs.TransactionExceptionLog(te); return null; } }
public string login(DAO.Login aLogin) { try { { aSqlConnection.Open(); SqlCommand cmd = new SqlCommand("uspLogin",aSqlConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userName", aLogin.userName); cmd.Parameters.AddWithValue("@password", aLogin.password); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) { return "Yes"; } } } catch (Exception e) { throw new Exception(e.Message); } finally { if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open) { aSqlConnection.Close(); } } return "Sorry,try again"; }
/// <summary> /// 添加单条记录 /// </summary> /// <param name="myDAOOL">DAO.Outoflibrary</param> /// <returns>bool</returns> public bool AddOL_Singole(DAO.Outoflibrary myDAOOL) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into db_Storage ("); strSql.Append("ol_ckid,ol_gsid,ol_num,ol_quantity,ol_dw,ol_dj,ol_yshk,ol_sshk,ol_khid,ol_zd_mgid,ol_yh_mgid,ol_shy,ol_price,ol_date,ol_sh_mgid,ol_status,ol_note"); strSql.Append(")values("); strSql.Append("'" + myDAOOL.OLckid + "',"); strSql.Append("'" + myDAOOL.OLgsid + "',"); strSql.Append("'" + myDAOOL.OLnum + "',"); strSql.Append("" + myDAOOL.OLquantity + ","); strSql.Append("'" + myDAOOL.OLDW + "',"); strSql.Append("'" + myDAOOL.OLDJ + "',"); strSql.Append("'" + myDAOOL.OLYSHK + "',"); strSql.Append("'" + myDAOOL.OLSSHK + "',"); strSql.Append("'" + myDAOOL.OLKHID + "',"); strSql.Append("'" + myDAOOL.OLZDMGid + "',"); strSql.Append("'" + myDAOOL.OLYHMGid + "',"); strSql.Append("'" + myDAOOL.OLSHY + "',"); strSql.Append("'" + myDAOOL.OLprice + "',"); strSql.Append("'" + myDAOOL.OLdate + "',"); strSql.Append("'" + myDAOOL.OLSHMGid + "',"); strSql.Append("'" + myDAOOL.OLstatus + "',"); strSql.Append("'" + myDAOOL.OLnote + "')"); int count = DBHelperSQL.ExecuteSql(strSql.ToString()); //判断是否成功添加记录 if (count == 1) { return true; } else { return false; } }
internal string updatePassword(DAO.Login aLogin, string newPassword) { try { aSqlConnection.Open(); SqlCommand command = new SqlCommand("USPPasswordUpdation", aSqlConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@password", newPassword); command.Parameters.AddWithValue("@userName", aLogin.userName); int effectedRows = command.ExecuteNonQuery(); if (effectedRows > 0) { return "Password is updated"; } } catch (Exception e) { throw new Exception(e.Message); } finally { if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open) { aSqlConnection.Close(); } } return "Error while updating password."; }
public EstoqueForm() { InitializeComponent(); DAOEstoque = new DAOEstoque(listSession); DAOLoja = new DAO<Loja>(listSession); pesquisaEstoqueStrategy = new PesquisaEstoqueStrategy(new PesquisaEstoqueGeral(listSession)); }
//受理 protected void btnDeal_Click(object sender, EventArgs e) { TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon(); TPortalClass.JpAdver JpAdver = new TPortalClass.JpAdver(); string ls_tip = "受理成功!"; for (int i = 0; i < rptList.Items.Count; i++) { string id = ((HiddenField)rptList.Items[i].FindControl("hidId")).Value; CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { TPortalClass.DAO db = new DAO(); string sql = "update hy_help set hy_ifsh=1 where id=" + int.Parse(id) + ""; db.Execute(sql); } } string pageUrl = JpCommon.CombUrlTxt("list_help_sh.aspx", "page={0}&rnd={1}", "" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + ""); //写系统日志 string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } JpCommon.WriteLog(userip, "审核", "批量受理帮办记录", Session["uid"].ToString(), Session["uname"].ToString()); Response.Write("<script>alert('" + ls_tip + "');window.location='" + pageUrl + "';</script>"); }
/// <summary> /// 添加单条入库单记录 /// </summary> /// <param name="myDAOST"></param> /// <returns>bool</returns> public bool AddST_Singole(DAO.Storage myDAOST) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into db_Storage ("); strSql.Append("st_num,st_ckid,ST_gsid,st_rk_mgid,st_yh_mgid,st_khid,st_quantity,st_dw,st_dj,st_price,st_date,st_note,st_status"); strSql.Append(")values("); strSql.Append("'" + myDAOST.STnum + "',"); strSql.Append("'" + myDAOST.STckid + "',"); strSql.Append("'" + myDAOST.STgsid + "',"); strSql.Append("'" + myDAOST.STRK_MGid + "',"); strSql.Append("'" + myDAOST.STYH_MGid + "',"); strSql.Append("'" + myDAOST.STKHid + "',"); strSql.Append("'" + myDAOST.STquantity + "',"); strSql.Append("'" + myDAOST.STDW + "',"); strSql.Append("'" + myDAOST.STDJ + "',"); strSql.Append("'" + myDAOST.STprice + "',"); strSql.Append("'" + myDAOST.STdate + "',"); strSql.Append("'" + myDAOST.STnote + "',"); strSql.Append("'" + myDAOST.STstatus + "')"); int count = DBHelperSQL.ExecuteSql(strSql.ToString()); //判断是否成功添加记录 if (count == 1) { return true; } else { return false; } }
/// <summary> /// 取得新增的log字串 /// </summary> /// <param name="rec"></param> /// <param name="studentNumber"></param> /// <returns></returns> public string ComposeInsertLogString(DAO.ResultScoreRecord rec, string studentNumber) { StringBuilder sb = new StringBuilder(); sb.Append(Global._ColScholYear).Append("「").Append(rec.SchoolYear).Append("」"); sb.Append(Global._ColSemester).Append("「").Append(rec.Semester).Append("」"); sb.Append(Global._ColClubName).Append("「").Append(rec.ClubName).Append("」"); sb.Append(Global.NewLine); sb.Append(Global._ColStudentNumber).Append("「").Append(studentNumber).Append("」"); sb.Append(Global.NewLine); if (rec.ResultScore.HasValue) { sb.Append(Global._ColClubScore).Append("「").Append(rec.ResultScore.Value).Append("」"); sb.Append(Global.NewLine); } else { sb.Append(Global._ColClubScore).Append("「").Append("」"); sb.Append(Global.NewLine); } sb.Append(Global._ColCadreName).Append("「").Append(rec.CadreName).Append("」"); sb.Append(Global.NewLine); return sb.ToString(); }
public DatabaseHelper(DBConfig dbconfig) { this.dbconfig = dbconfig; RowsInsert = new ConcurrentQueue<String>(); this.msgInserting = ""; this.dao = getDataBaseDAO(); skip = true; databases.Add(mysql); }
/// <summary> /// 判断指定仓库的指定物品是否存在 /// </summary> /// <param name="myDAOSK">DAO.Stock</param> /// <returns>bool</returns> public bool equalsStock(DAO.Stock myDAOSK) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from db_stock where sk_ck_id=" + myDAOSK.SKCKid + " and sk_gs_id=" + myDAOSK.SKGSid); DataSet ds = DBHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count == 1) { return true; } else { return false; } }
protected void Page_Load(object sender, EventArgs e) { Response.CacheControl = "no-cache"; string ls_update = ""; string ls_filename = ""; string ls_path = ""; string ls_id = Request.Form["id"].ToString(); //string lshy_fatherfield = Request.Form["txtcurloginuserid"].ToString(); //string lshy_fatherid = Request.Form["fatherid"].ToString(); //string hy_userid = Request.Form["userid"].ToString(); //Request.Params["fatherid"].ToString()+"\\"+Request.Params["fatherfield"].ToString(); //string Datedir = DateTime.Now.ToString("yy-MM-dd"); //string updir = s_rpath + "\\" + Datedir; //string updir = s_rpath; if (Request.Files["file"].ContentLength > 0) { try { string updir = Server.MapPath("~/") + "upload\\original\\rytx\\"; DAO db = new DAO(); DataTable dt = new DataTable(); HttpPostedFile uploadFile = Request.Files["file"]; //if (uploadFile.ContentLength > 0) //{ if (!Directory.Exists(updir)) { Directory.CreateDirectory(updir); } //string extname = Path.GetExtension(uploadFile.FileName); //string filename = uploadFile.FileName; //lsfilename = filename; //lsurl = "fileatt\\" + filename; //存放的文件夹 //uploadFile.SaveAs(string.Format("{0}\\{1}", updir, filename)); ls_filename = ls_id + ".jpg"; uploadFile.SaveAs(updir + ls_filename); ls_path = "upload\\original\\rytx\\" + ls_filename; string sql_user = "******" + ls_path + "' "; sql_user += " where hy_id='" + ls_id + "'"; db.Execute(sql_user); //} } catch (Exception ex) { Response.Write("Message"+ ex.ToString()); } } }
public GerenciarPermissoesEmFormulario(Form formulario) { InitializeComponent(); this.formulario = formulario; DAOPermissoes = new DAO<Permissoes>(MySQLSession); DAOFormularioMySQL = new DAO<Formulario>(MySQLSession); DAOControlMySQL = new DAO<ControlTable>(MySQLSession); DAOControlSQLServer = new DAO<ControlTable>(SQLServerSession); DAOFormularioSQLServer = new DAO<Formulario>(SQLServerSession); }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOSK">DAO.Stock</param> /// <returns>bool</returns> public bool AddSK_bool(DAO.Stock myDAOSK) { DataSet ds = mySM.SelectStock(myDAOSK.SKCKid, myDAOSK.SKGSid); if (ds.Tables[0].Rows.Count > 0) { myDAOSK.SKquantity += int.Parse(ds.Tables[0].Rows[0]["sk_quantity"].ToString()); return mySM.UpdateSK(myDAOSK); } else { return mySM.AddSK(myDAOSK); } }
/// <summary> /// 學生個案會議 /// </summary> public StudCaseMeetingRecordForm(DAO.UDT_CounselCaseMeetingRecordDef CounselCaseMeetingRecord,accessType accType) { InitializeComponent(); _UDTTransfer = new DAO.UDTTransfer(); _CounselCaseMeetingRecord = CounselCaseMeetingRecord; _accessType = accType; _studRec = Student.SelectByID(CounselCaseMeetingRecord.StudentID.ToString()); _TeacherIDNameDict = Utility.GetCounselTeacherIDNameDict(CounselCaseMeetingRecord.StudentID.ToString ()); _TeacherNameIDDict = Utility.GetCounselTeacherNameIDDict(CounselCaseMeetingRecord.StudentID.ToString()); //if (_accessType == accessType.Insert) // _CounselCaseMeetingRecord.AuthorID = Utility.GetAuthorID(); _LogTransfer = new DAO.LogTransfer(); }
public Load(string name, ExtensionType extensionType, BasicType basicType, object value) { this.name = name; if (extensionType != ExtensionType.List) { throw new Exception("Not supported type"); } this.data = new List(basicType.ToString(), value); }
public AlteraPermissaoGerenciarPermissoes(ControlTable control) { InitializeComponent(); this.control = control; lblControleSendoAlterado.Text += this.control.nome; lblPermissaoAtual.Text += this.control.permissoes.nome; DAOPermissoesMySQL = new DAO<Permissoes>(MySQLSession); DAOControlMySQL = new DAO<ControlTable>(MySQLSession); DAOControlSQLServer = new DAO<ControlTable>(SQLServerSession); }
private ListViewItem ConvertToListViewItem(DAO.StudentVO rec) { ListViewItem item = new ListViewItem(); item.Tag = rec; // 學號 item.Text = rec.StudentNumber; // 班級 item.SubItems.Add(rec.ClassName); // 姓名 item.SubItems.Add(rec.StudentName); return item; }
public FrmFitnessRecord(DAO.StudentFitnessRecord rec, accessType actType) { InitializeComponent(); _studRec = Student.SelectByID(rec.StudentID); _fitnessRec = rec; _actType = actType; _LogTransfer = new Log.LogTransfer(); if(_actType == accessType.Edit) this.TitleText = _FrmTitleEdit; else this.TitleText = _FrmTitleAdd; }
public SetCounselTeacherForm(DAO.CounselTeacherRecord.CounselTeacherType Type,List<string> StudentIDList) { InitializeComponent(); _UDTTransfer = new DAO.UDTTransfer (); this.MaximumSize = this.MinimumSize = this.Size; _CounselTeacherType = Type; _StudentIDList = new List<int>(); _hasCounselStudent_List = new List<DAO.UDT_CounselStudent_ListDef>(); _StudentIDList = (from data in StudentIDList select int.Parse(data)).ToList(); if(StudentIDList.Count>0) _hasCounselStudent_List = _UDTTransfer.GetCounselStudentListIDs(StudentIDList); this.Text = "指定" + Type.ToString(); }
public StudCareRecordForm(DAO.UDT_CounselCareRecordDef CareRecordDef,accessType accType) { InitializeComponent(); this.MaximumSize = this.MinimumSize = this.Size; _accessType = accType; _CounselCareRecord = CareRecordDef; _itemListCategory = new List<string>(); _itemListOrigin = new List<string>(); _studRec = Student.SelectByID(_CounselCareRecord.StudentID.ToString()); _UDTTransfer = new DAO.UDTTransfer(); _LogTransfer = new DAO.LogTransfer(); //if (accType == accessType.Insert) // _CounselCareRecord.AuthorID = Utility.GetAuthorID(); }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOSK">DAO.Stock</param> /// <returns>string</returns> public string AddSK(DAO.Stock myDAOSK) { try { if (mySM.AddSK(myDAOSK)) { return "添加库存成功"; } else { return "添加库存失败"; } } catch//可以增加用户名不存在或密码错误 { return "添加库存异常"; } }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOCK">DAO.Cangku</param> /// <returns>bool 是否成功添加记录</returns> public string AddCK(DAO.Cangku myDAOCK) { try { if (myCKM.AddCK(myDAOCK)) { return "添加用户成功"; } else { return "添加用户失败"; } } catch//可以增加用户名不存在或密码错误 { return "添加用户异常"; } }
/// <summary> /// 添加多条记录 /// </summary> /// <param name="myDAOST">DAO.Storage[]</param> /// <returns>string</returns> public string AddST_More(DAO.Storage[] myDAOST) { try { if (myModel_SM.AddST_More(myDAOST)) { return "添加入库单成功"; } else { return "添加入库单失败"; } } catch { return "添加入库单异常"; } }
/// <summary> /// 添加记录 /// </summary> /// <param name="UserName">用户名</param> /// <param name="Userpassword">密码</param> /// <param name="Usertype">类别(职位)</param> /// <returns></returns> public String AddUser(DAO.User myDAOUser) { try { if (myUser.AddUser(myDAOUser)) { return "添加用户成功"; } else { return "添加用户失败"; } } catch//可以增加用户名不存在或密码错误 { return "添加用户异常"; } }
/// <summary> /// 添加单条记录 /// </summary> /// <param name="myDAOOL">DAO.Outoflibrary</param> /// <returns>string</returns> public string AddOL_Singole(DAO.Outoflibrary myDAOOL) { try { if (myOLM.AddOL_Singole(myDAOOL)) { return "添加出库单成功"; } else { return "添加出库单失败"; } } catch { return "添加出库单异常"; } }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOCK">DAO.Cangku</param> /// <returns>bool 是否成功添加记录</returns> public bool AddCK(DAO.Cangku myDAOCK) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into db_cangku ("); strSql.Append("ck_name,ck_type,ck_note"); strSql.Append(")values("); strSql.Append("'" + myDAOCK.CKname + "',"); strSql.Append("'" + myDAOCK.CKtype + "',"); strSql.Append("'" + myDAOCK.CKnote + "')"); int count = DBHelperSQL.ExecuteSql(strSql.ToString()); //判断是否成功添加记录 if (count == 1) { return true; } else { return false; } }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOSK">DAO.Stock</param> /// <returns>bool</returns> public bool AddSK(DAO.Stock myDAOSK) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into db_stock ("); strSql.Append("sk_ck_id,sk_gs_id,sk_quantity"); strSql.Append(")values("); strSql.Append("'" + myDAOSK.SKCKid + "',"); strSql.Append("'" + myDAOSK.SKGSid + "',"); strSql.Append("" + myDAOSK.SKquantity + ")"); int count = DBHelperSQL.ExecuteSql(strSql.ToString()); //判断是否成功添加记录 if (count == 1) { return true; } else { return false; } }
/// <summary> /// 添加记录 /// </summary> /// <param name="myDAOUser">DAO.User</param> /// <returns>bool 是否成功添加记录</returns> public bool AddUser(DAO.User myDAOUser) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DB_USER ("); strSql.Append("us_name,us_password,us_type"); strSql.Append(")values("); strSql.Append("'" + myDAOUser.Usname + "',"); strSql.Append("'" + myDAOUser.Uspassword + "',"); strSql.Append("'" + myDAOUser.Ustype + "')"); int count = DBHelperSQL.ExecuteSql(strSql.ToString()); //判断是否成功添加记录 if (count == 1) { return true;} else { return false; } }
public StudQuizDataForm(DAO.UDT_StudQuizDataDef sqd,EditMode editMode,string StudentID) { InitializeComponent(); _EditMode = editMode; _RowNameList = new List<string>(); _StudQuizData = sqd; _UDTTransfer = new DAO.UDTTransfer(); _AllQuiz = _UDTTransfer.GetAllQuizData(); _quizFieldNameList = new List<DAO.SortData1>(); _StudentID = StudentID; _LogTransfer = new DAO.LogTransfer(); // 將測驗名稱放入 List<string> nameList = (from data in _AllQuiz orderby data.QuizName select data.QuizName).ToList(); cbxQuizName.Items.AddRange(nameList.ToArray()); ReLoadQuizFieldNameList(); }
private void XuatBBLuong(object sender, WaitWindowEventArgs e) { string tenNVLapBieu = (string)e.Arguments[0]; string saveFileName = (string)e.Arguments[1]; var ngaydauthang = MyUtility.FirstDayOfMonth(m_Thang); var ngaycuoithang = MyUtility.LastDayOfMonth(m_Thang); //#region lấy dữ liệu kết lương để xuất var tableKetLuongThang = DAO.LayKetLuongThang(ngaydauthang); var tableThongsoKetluongThang = DAO.LayThongsoKetluongThang(ngaydauthang); var tableDSNVChiCongnhatThang = DAO.LayTableCongNhat(ngaydauthang); var tableTongLuongCongnhat = SqlDataAccessHelper.ExecuteQueryString( @"select CAST(SUM (SoNgayCong*DonGiaLuong) as float) from DSNVChiCongNhatThang where Thang=@Thang", new string[] { "@Thang" }, new object[] { ngaydauthang }); var tongLuongCongnhat = (tableTongLuongCongnhat.Rows[0][0] != DBNull.Value) ? (double)tableTongLuongCongnhat.Rows[0][0] : 0d; var tongLuongDieuchinh = (from DataRow row in tableKetLuongThang.Rows let luongdieuchinh = (row["LuongDieuChinh"] != DBNull.Value) ? (double)row["LuongDieuChinh"] : 0d select luongdieuchinh).Sum(); var tableKetcongNgay = DAO.LayKetcongNgay(ngaydauthang, ngaycuoithang); var tableKetcongCa = DAO.LayKetcongCa(ngaydauthang, ngaycuoithang); var tableXPVang = DAO.LayTableXPVang(ngaydauthang, ngaycuoithang); var tableNgayLe = DAO.DocNgayLe(ngaydauthang, ngaycuoithang); var dsnv = new List <cUserInfo>(); ChuanBiDuLieuXuatLuong(dsnv, ngaydauthang, ngaycuoithang, tableKetLuongThang, tableKetcongNgay, tableKetcongCa, tableXPVang, tableNgayLe, tableDSNVChiCongnhatThang); //#endregion //fortesting testing region [02] using (var p = new ExcelPackage()) { //1. xuat bb bang thong so san luong, don gia, he so pc #region lay thong so cac loai pc de ghi cot tieu de int pc30 = (int)tableThongsoKetluongThang.Rows[0]["HSPCDem"]; int pc50 = (int)tableThongsoKetluongThang.Rows[0]["HSPCTangCuong"]; int pctcc3 = (int)tableThongsoKetluongThang.Rows[0]["HSPCTangCuong_Dem"]; int pc100 = (int)tableThongsoKetluongThang.Rows[0]["HSPC200"]; int pc160 = (int)tableThongsoKetluongThang.Rows[0]["HSPC260"]; int pc200 = (int)tableThongsoKetluongThang.Rows[0]["HSPC300"]; int pc290 = (int)tableThongsoKetluongThang.Rows[0]["HSPC390"]; #endregion //2. xuat bb bang ket cong thang #region ghi sheet bang ket cong thang trinh ky p.Workbook.Worksheets.Add("BangKetCong"); var ws = p.Workbook.Worksheets["BangKetCong"]; ws.Name = "BangKetCong"; //Setting Sheet's name XL.ExportSheetBangKetcongThang(ws, ngaydauthang, ngaycuoithang, dsnv, string.Empty, string.Empty, pc30, pc50, pctcc3, pc100, pc160, pc200, pc290); #endregion //3. xuat bb chi tiết kết công #region ghi sheet chi tiết kết công p.Workbook.Worksheets.Add("ChiTietKetCong"); ws = p.Workbook.Worksheets["ChiTietKetCong"]; ws.Name = "ChiTietKetCong"; //Setting Sheet's name XL.ExportSheetBangChiTietKetCong(ws, ngaydauthang, ngaycuoithang, dsnv, pc30, pc50, pctcc3, pc100, pc160, pc200, pc290); #endregion //4. xuat bb bang luong cong nhat #region ghi sheet bang luong cong nhat p.Workbook.Worksheets.Add("BangLuongCongNhat"); ws = p.Workbook.Worksheets["BangLuongCongNhat"]; ws.Name = "BangLuongCongNhat"; XL.ExportSheetBangLuongCongNhat(ws, ngaydauthang, tableDSNVChiCongnhatThang); #endregion //5. xuat bb bang luong chinh thuc #region ghi sheet bảng lương p.Workbook.Worksheets.Add("BangLuong"); ws = p.Workbook.Worksheets["BangLuong"]; ws.Name = "BangLuong"; XL.ExportSheetBangLuong(ws, m_Thang, dsnv, tenNVLapBieu); #endregion //6. xuat bb bang tong hop so lieu giam doc ky duyet #region ghi sheet bảng tổng hợp số liệu p.Workbook.Worksheets.Add("BangTongHopChi"); ws = p.Workbook.Worksheets["BangTongHopChi"]; ws.Name = "BangTongHopChi"; XL.ExportSheetTongHopChi(ws, m_Thang, tableThongsoKetluongThang, tongLuongCongnhat, tongLuongDieuchinh); #endregion //7. xuat sheet thong ke sữa #region ghi sheet thống kê BD ĐH p.Workbook.Worksheets.Add("BangThongKeBoiDuongDocHai"); ws = p.Workbook.Worksheets["BangThongKeBoiDuongDocHai"]; ws.Name = "BangThongKeBoiDuongDocHai"; XL.ExportSheetBangThongKeSua(ws, ngaydauthang, ngaycuoithang, dsnv); #endregion Byte[] bytes = p.GetAsByteArray(); XL.XuatFileExcel(saveFileName, bytes, "frm4LuuHSPC XuatBBLuong"); } }
/// <summary> /// La méthode Init_Exemplaire initialise la liste des Exemplaires /// </summary> /// <param name="ex">Une liste d'exemplaires est passé en paramètre</param> public static void Init_Exemplaires(Exemplaires ex) { try { // On nettoie la collection d'exemplaires 28/03 ex.Clear(); String[] result = new String[7]; // La requète SQL 28/03 String strSql = "SELECT * FROM EXEMPLAIRE"; // On execute la requete DbDataReader sqlRdr = DAO.Execute_Query(strSql); // IDataReader a la place du DbDataReader (sans modif) ? // On lit toutes les colonnes de la ligne while (sqlRdr.Read()) { if (!sqlRdr.IsDBNull(0)) { result[0] = sqlRdr.GetInt32(0).ToString(); } else { result[0] = "0"; } if (!sqlRdr.IsDBNull(1)) { result[1] = sqlRdr.GetString(1); } else { result[1] = "<nc>"; } if (!sqlRdr.IsDBNull(2)) { result[2] = sqlRdr.GetString(2); } else { result[2] = "<nc>"; } if (!sqlRdr.IsDBNull(3)) { result[3] = sqlRdr.GetString(3); } else { result[3] = "<nc>"; } if (!sqlRdr.IsDBNull(4)) { result[4] = sqlRdr.GetString(4); } else { result[4] = "<nc>"; } if (!sqlRdr.IsDBNull(5)) { result[5] = sqlRdr.GetString(5); } else { result[5] = "<nc>"; } if (!sqlRdr.IsDBNull(6)) { result[6] = sqlRdr.GetBoolean(6).ToString(); } else { result[6] = "false"; } // On ajoute l'exemplaire dans la liste ex.Add(new Exemplaire(Convert.ToInt16(result[0]), result[1], result[2], result[3], result[4], result[5], Convert.ToBoolean(result[6]))); //nb_exemplaire += 1; } sqlRdr.Close(); // On ferme la requete sqlRdr = null; } catch (Exception) { // ==> S'il y a une erreur, la LISTE est vide } }
public DataTable GetDesignation() { return(DAO.GetTable(null, "SELECT * FROM dbo.Designation", CommandType.Text)); }
public DataTable GetUserByProvince(string province) { return(DAO.GetTable(null, "select * from UserTable where BranchCode > 990", CommandType.Text)); }
public static string RetornaDisparo(int idDisparo) { string consulta = string.Format("select * from dadosdisparos where idDisparo = {0} for xml auto", idDisparo.ToString()); return(DAO.retornaValor(ConfigurationManager.ConnectionStrings["Disparos"].ToString(), consulta)); }
internal static bool ConfirmarCadastroDisparo(int idDisparo) { string consulta = string.Format("update dadosdisparos set inserida = 1 where iddisparo = {0}", idDisparo.ToString()); return(DAO.execute(ConfigurationManager.ConnectionStrings["Disparos"].ToString(), consulta)); }
public Videojuegos() { InitializeComponent(); this.dao = new DAO(); }
//对话框载入 private void Form1_Load(object sender, EventArgs e) { connectionIP = IOUtil.get_config_by_key(ConfigKeys.KEY_CONNECTION_IP); if (connectionIP == "") { PCListForm pCListForm = new PCListForm(); if (pCListForm.ShowDialog() != DialogResult.OK) { this.Close(); return; } connectionIP = pCListForm.ip; IOUtil.set_config_by_key(ConfigKeys.KEY_CONNECTION_IP, connectionIP); } dao = new DAO(connectionString); if (!dao.check_net()) { BathClass.printErrorMsg("连接IP不对或者网络不通,请重试!"); this.Close(); return; } _options = dao.get_options(); m_company = _options.companyName; print_tech_msg = MConvert <bool> .ToTypeOrDefault(options.打印技师派遣单, false); user_card = MConvert <bool> .ToTypeOrDefault(options.启用员工服务卡, false); IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName()); foreach (var ip in ipe.AddressList) { m_ip = ip.ToString(); if (System.Text.RegularExpressions.Regex.IsMatch(m_ip, "[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}")) { break; } } setMax(); //dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 20); //dgv.RowsDefaultCellStyle.Font = new Font("宋体", 20); //dgv_show(); m_thread = new Thread(new ThreadStart(detect_msg)); m_thread.IsBackground = true; m_thread.Start(); m_thread_tech = new Thread(new ThreadStart(detect_tech_index)); m_thread_tech.IsBackground = true; m_thread_tech.Start(); clock_timer = new System.Timers.Timer(); clock_timer.Interval = 1000; clock_timer.Elapsed += new System.Timers.ElapsedEventHandler(clock_timer_Elapsed); clock_timer.Enabled = true; m_player = new SoundPlayer(); techId.Focus(); m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory)); m_thread_clearMemory.IsBackground = true; m_thread_clearMemory.Start(); SplitGender.SplitterDistance = SplitGender.Width * 2 / 3; create_tech_panel(); }
public MedidaServico() { dao = new DAO(); }
public override void UpdateMenu(string path) { while (true) { Console.Clear(); Console.WriteLine(path); Trip entity = null; Console.WriteLine("1 - Редактировать по ID -->"); Console.WriteLine("2 - Редактировать № -->"); Console.WriteLine("3 - Выход -->"); var consoleCommand = ReadIntValueFromConsole(); if (consoleCommand == 1) { Console.WriteLine("Введите Id --> "); var id = ReadIntValueFromConsole(); entity = DAO.GetInstance().Repository <Trip>().Find(id); if (entity == null) { Console.Write("Сущьность с Id = " + id + " не найденна!!!"); Console.ReadKey(); break; } } else if (consoleCommand == 2) { Console.WriteLine("Введите номер записи --> "); var pos = ReadIntValueFromConsole(); var list = DAO.GetInstance().Repository <Trip>().FindAll(); if (pos >= list.Count()) { Console.WriteLine("Вы ввели не корректный номер!!!"); Console.ReadKey(); break; } entity = list[pos]; } else if (consoleCommand == 3) { break; } if (entity == null) { break; } Console.WriteLine(entity.ToString()); Console.WriteLine(); Console.WriteLine("Введите номер порта отправки"); entity.PortFromId = ReadIntValueFromConsole(); Console.WriteLine("Введите номер порта прибытия"); entity.PortToId = ReadIntValueFromConsole(); Console.WriteLine("Введите номер корабля"); entity.ShipId = ReadIntValueFromConsole(); Console.WriteLine("Введите дату отправки"); entity.StartDate = ReadDateTimeFromConsole(); Console.WriteLine("Введите дату прибытия"); entity.EndDate = ReadDateTimeFromConsole(); try { DAO.GetInstance().Repository <Trip>().SaveChanges(); Console.WriteLine("Изменения внесены!!!"); } catch (Exception err) { Console.WriteLine("Ошибка при сохранении изменений"); } Console.ReadKey(); } }
/// <summary> /// 获取一个实例查询参数 /// </summary> /// <param name="paraName"></param> /// <param name="Value"></param> /// <returns></returns> public System.Data.IDataParameter GetParameter(string paraName, object Value) { return(DAO.GetParameter(paraName, Value)); }
/// <summary> /// 获取一个实例查询参数 /// </summary> /// <returns></returns> public System.Data.IDataParameter GetParameter() { return(DAO.GetParameter()); }
private void KetLuong(object sender, WaitWindowEventArgs e) { #region lấy thông tin từ csdl và khỏi tạo nv var ngaydauthang = MyUtility.FirstDayOfMonth(m_Thang); var ngaycuoithang = MyUtility.LastDayOfMonth(m_Thang); var tableDSNVChiCongnhatThang = DAO.LayTableCongNhat(ngaydauthang); var tableDSThuchiThang = DAO.LayDSThuchiThang(ngaydauthang); var tableKetcongNgay = DAO.LayKetcongNgay(ngaydauthang, ngaycuoithang); var tableKetcongCa = DAO.LayKetcongCa(ngaydauthang, ngaycuoithang); var tableXPVang = DAO.LayTableXPVang(ngaydauthang, ngaycuoithang); var tableNgayLe = DAO.DocNgayLe(ngaydauthang, ngaycuoithang); var dsnv = new List <cUserInfo>(); var dsphongban = new List <cPhongBan>(); XL.KhoiTaoDSPhongBan(dsphongban); // khởi tạo các phòng ban để cập nhật thông tin phòng ban cho nhân viên tính công XL.KhoiTaoDSNV_TinhLuong(dsnv, dsphongban); // khởi tạo tất cả nhân viên tính công, bao gồm cả công nhật ngày(nv chính thức) và công nhật tháng #endregion #region //load cong phu cap tung ngay cho tat ca nv, ke ca cong nhat, rieng truong hop cong nhat se xu ly ngay ben duoi foreach (var nv in dsnv) { nv.DSNgayCong = new List <cNgayCong>(); nv.DSVang = new List <cLoaiVang>(); for (DateTime indexNgay = ngaydauthang; indexNgay <= ngaycuoithang; indexNgay = indexNgay.AddDays(1d)) { XL.LoadNgayCong(nv.MaCC, nv.DSNgayCong, indexNgay, tableKetcongNgay, tableKetcongCa); } XL.LoadDSXPVang_Le(nv.MaCC, tableXPVang, tableNgayLe, nv.DSVang); //info trường hợp nhân viên công nhật sẽ được xử lý bên dưới XL.PhanPhoi_DSVang7(nv.DSVang, nv.DSNgayCong); XL.LoadThongtinLamViecCongNhat(nv.MaCC, ref nv.NgayBDCongnhat, ref nv.NgayKTCongnhat, ref nv.LoaiCN, nv.DSNgayCong, tableDSNVChiCongnhatThang); } #endregion //có được ds nhân viên với công, phụ cấp, các loại vắng, công ngày lễ --> bắt đầu tính lương #region lấy thông số để tính lương var sanluong01 = (int)(numSanLuong.Value); var dongia02 = (int)numDonGia.Value; var perTrichQuyLuong = (int)numTrichQuyLuong.Value; var sanluongGiacongNoiBo = (int)numSanluongGiacongNoibo.Value; var dongiaGiacongNoiBo = (int)numDongiaGiacongNoibo.Value; var sanluongGiacongNgoai = (int)numSanluongGiacongNgoai.Value; var dongiaGiacongNgoai = (int)numDongiaGiacongNgoai.Value; var mucLuongToithieu = (int)numLuongTT.Value; var DinhMuccomtrua = (int)numDinhMucComTrua.Value; double tongQuy100Per03 = Convert.ToDouble(sanluong01) * Convert.ToDouble(dongia02); double _80perQuy100_04 = tongQuy100Per03 * (perTrichQuyLuong / 100d); // ko cần round vì 220*0.8=176 chẵn #endregion // xác định công chuẩn của tháng var congChuanThang = XL.TinhCongChuanCuaThang(ngaydauthang); int temp = 0; #region // thống kê công, phụ cấp hàng ngày của từng nhân viên chính thức//trường hợp nhân viên vừa công nhật vừa chính thức thì chỉ thống kê ngày công sau ngày kết thúc công nhật foreach (var nv in dsnv) { // thống kê công và phụ cấp từng nv XL.ThongKeThang(ref nv.ThongKeThang, nv.DSNgayCong, nv.NgayBDCongnhat, nv.NgayKTCongnhat, nv.LoaiCN, out temp, out temp); // tính công chờ việc: 1.nv công nhật ko cv. 2. nv mới chính thức thì chỉ giữ công cv khai báo if (nv.LoaiCN == LoaiCongNhat.NVCongNhat) // nhân viên làm công nhật, công cv tự động, khai báo = 0 { nv.ThongKeThang.CongCV_Auto = 0f; nv.ThongKeThang.CongCV_KB = 0f; } else { if (nv.LoaiCN == LoaiCongNhat.NVChinhThuc) // nhân viên chính thức { nv.ThongKeThang.CongCV_Auto = congChuanThang - /*(nv.ThongKeThang.Cong + nv.ThongKeThang.Le + nv.ThongKeThang.Phep + //ver4.0.0.0*/ /*(nv.ThongKeThang.TongNgayLV + nv.ThongKeThang.Le + nv.ThongKeThang.Phep + //ver4.0.0.1*/ (nv.ThongKeThang.TongNgayLV4008 + nv.ThongKeThang.TongTruCongTreVR + nv.ThongKeThang.TongTruCongSomVR + nv.ThongKeThang.TreSom_KoDuBuCong //ver 4.0.0.8 + nv.ThongKeThang.Phep + nv.ThongKeThang.Le //ver4.0.0.8 + nv.ThongKeThang.BHXH + nv.ThongKeThang.H_CT_PT + nv.ThongKeThang.PTDT + nv.ThongKeThang.NghiRo + nv.ThongKeThang.CongCV_KB); //DANGLAM if (nv.ThongKeThang.CongCV_Auto < 0f) { nv.ThongKeThang.CongCV_Auto = 0f; } } else // nhân viên chính thức vừa công nhật thì công cv_auto =0, công cv khai báo ko đổi { nv.ThongKeThang.CongCV_Auto = 0f; } } nv.ThongKeThang.CongCV = nv.ThongKeThang.CongCV_Auto + nv.ThongKeThang.CongCV_KB; } #endregion #region // tính lương công nhật cho các nhân viên làm công nhật và tổng lương công nhật double TongLuongCongNhat_AllNV = 0d; foreach (DataRow row in tableDSNVChiCongnhatThang.Rows.Cast <DataRow>()) { // lấy thông tin var macc = (int)row["UserEnrollNumber"]; var dongiaLuong = (int)row["DonGiaLuong"]; var soNgayCong = (float)row["SoNgayCong"]; var TamUng = (double)row["TamUng"]; // xác định nhân viên var nv = dsnv.Find(o => o.MaCC == macc); if (nv == null) { continue; } nv.ThongKeThang.Cong_Congnhat = soNgayCong; nv.chiTietLuong.CongNhat = soNgayCong * dongiaLuong; //ko trừ tạm ứng, tạm ứng chỉ ở phần thực lãnh mới ghi TongLuongCongNhat_AllNV += nv.chiTietLuong.CongNhat; } #endregion #region //đọc danh sách thu chi cho từng nhân viên (lưu ý ko đọc phụ cấp của nhân viên công nhật foreach (DataRow row in tableDSThuchiThang.Rows.Cast <DataRow>()) { var macc = (int)row["UserEnrollNumber"]; // xác định nhân viên var nv = dsnv.Find(o => o.MaCC == macc); if (nv == null) { continue; } nv.chiTietLuong.KhauTru.TamUng = (double)row["TamUng"]; nv.chiTietLuong.LuongDieuChinh = (double)row["LuongDieuChinh"]; nv.chiTietLuong.MucDongBHXH = (float)row["MucDongBHXH"]; nv.chiTietLuong.KhauTru.ThuChiKhac = (double)row["ThuChiKhac"]; } #endregion #region // tính lương cho nv chính thức double tong_qlcb_2 = 0d, tong_SPLamRa_B2_2 = 0d, tongQuyLuongCV = 0d, tongQuyLuongNghiDinhCP = 0d, tongChiKhacTuQuyLuong = 0d, tongQuyLuongSP = 0d; foreach (var nv in dsnv.Where(o => o.LoaiCN != LoaiCongNhat.NVCongNhat)) { //if (Math.Abs(nv.ThongKeThang.Cong - 0f) < 0.01f) nv.ThongKeThang.CongCV = 0f; //fortesting nếu ko chấm công thì cũng ko có công cv XL.TinhLuongCoBan_CongVaPC_A202(nv.HeSo.LuongCB, mucLuongToithieu, nv.ThongKeThang.Cong, nv.ThongKeThang.PhuCaps._TongPC, nv.ThongKeThang.Phep, nv.ThongKeThang.H_CT_PT, nv.ThongKeThang.PTDT, nv.ThongKeThang.Le, nv.ThongKeThang.CongCV, //DANGLAM out nv.chiTietLuong.LCB_Theo.CongThucTe, out nv.chiTietLuong.LCB_Theo.CheDoNghi, out nv.chiTietLuong.LCB_Theo.CongCV, out nv.chiTietLuong.LCB_Theo.PhuCap); tongQuyLuongCV += nv.chiTietLuong.LCB_Theo.CongCV; //tongQuyLuongNghiDinhCP += nv.chiTietLuong.LCB_Theo.TongCong_CD_CV_PC; // yêu cầu cũ (T1/2015) là có lương chờ việc tongQuyLuongNghiDinhCP += nv.chiTietLuong.LCB_Theo.Cong_CD_PC; // yêu cầu mới (T8/2015) là tách lương chờ việc ra //ver4.0.0.7 tong_qlcb_2 += nv.chiTietLuong.LCB_Theo.TongCong_CD_CV_PC + nv.chiTietLuong.LuongDieuChinh; //yêu cầu mới (T8/2015) là tách lương chờ việc ra khỏi quỹ lương cơ bản đưa vào quỹ lương sản phẩm tong_qlcb_2 += nv.chiTietLuong.LCB_Theo.Cong_CD_PC + nv.chiTietLuong.LuongDieuChinh; //info tong_qlcb_2 bao gồm lương cb 1nv, bồi dưỡng ca 3 1nv, lương tháng trước 1 nv tongChiKhacTuQuyLuong += nv.chiTietLuong.KhauTru.ThuChiKhac; XL.TinhSPLamRa_CongVaPC_B102(nv.HeSo.LuongCV, nv.ThongKeThang.Cong, nv.ThongKeThang.PhuCaps._TongPC, nv.ThongKeThang.Phep, nv.ThongKeThang.H_CT_PT, nv.ThongKeThang.PTDT, nv.ThongKeThang.Le, //DANGLAM out nv.chiTietLuong.SPLamRa_Theo.CongThucTe, out nv.chiTietLuong.SPLamRa_Theo.CheDoNghi, out nv.chiTietLuong.SPLamRa_Theo.PhuCap); tong_SPLamRa_B2_2 += nv.chiTietLuong.SPLamRa_Theo.TongSPLamRa; // tính khấu trừ BHXH nv.chiTietLuong.KhauTru.BHXH = Convert.ToDouble(nv.HeSo.BHXH_YT_TN * mucLuongToithieu * (nv.chiTietLuong.MucDongBHXH / 100f)); // tính tiền cơm trưa var temp1 = DinhMuccomtrua - ((DinhMuccomtrua / congChuanThang) * nv.ThongKeThang.SoNgayNghiRO_NguyenNgay); nv.chiTietLuong.TienComTrua = (temp1 >= 0d) ? temp1 : 0d; } var chitienGiacongNoibo = Convert.ToDouble(sanluongGiacongNoiBo) * Convert.ToDouble(dongiaGiacongNoiBo); var chitienGiacongNgoai = Convert.ToDouble(sanluongGiacongNgoai) * Convert.ToDouble(dongiaGiacongNgoai); var tong_qlSP_A71_1_VaGiaCong = (_80perQuy100_04 + chitienGiacongNoibo + chitienGiacongNgoai) - tong_qlcb_2 - TongLuongCongNhat_AllNV; // yêu cầu mới (T8/2015) là tách lương chờ việc ra double giaTri_1SP_B3_1 = (Math.Abs(tong_SPLamRa_B2_2 - 0d) > 0.001d) ? (tong_qlSP_A71_1_VaGiaCong / tong_SPLamRa_B2_2) : 0d; // tính ra được 1 đơn vị sản phẩm có giá bao nhiêu //double tong0 = 0d, tong1 = 0d, tong2 = 0d, tong3 = 0d, tong4 = 0d, tong5 = 0d, tong6 = 0d, tong7 = 0d, tong8 = 0d, tong9 = 0d, tong10 = 0d, tong11 = 0d, tong12 = 0d, tong13 = 0d, tong14 = 0d, tong15 = 0d, tong16 = 0d, tong17 = 0d, tong18 = 0d, tong19 = 0d, tong20 = 0d, tong21 = 0d, tong22 = 0d, tong23 = 0d, tong24 = 0d, tong25 = 0d, tong26 = 0d, tong27 = 0d, tong28 = 0d, tong29 = 0d, tong30 = 0d, tong31 = 0d, tong32 = 0d, tong33 = 0d, tong34 = 0d, tong35 = 0d, tong36 = 0d; foreach (var nv in dsnv.Where(o => o.LoaiCN != LoaiCongNhat.NVCongNhat)) { nv.chiTietLuong.LSP_Theo.CongThucTe = nv.chiTietLuong.SPLamRa_Theo.CongThucTe * giaTri_1SP_B3_1; nv.chiTietLuong.LSP_Theo.CheDoNghi = nv.chiTietLuong.SPLamRa_Theo.CheDoNghi * giaTri_1SP_B3_1; nv.chiTietLuong.LSP_Theo.PhuCap = nv.chiTietLuong.SPLamRa_Theo.PhuCap * giaTri_1SP_B3_1; tongQuyLuongSP += nv.chiTietLuong.LSP_Theo.TongCong_CD_PC; //fortesting region [03] } #endregion //fortesting testing region [01] #region // cập nhật lương xuống csdl , trước khi cập nhật thì xoá lương cũ // cập nhật lương xuống csdl , trước khi cập nhật thì xoá lương cũ int kq1 = SqlDataAccessHelper.ExecNoneQueryString( "delete from KetLuongThang where Thang = @Thang", new string[] { "@Thang" }, new object[] { m_Thang }); //INFO LOG DO KẾT LƯƠNG THÁNG THỰC HIỆN foreach (var nv in dsnv.Where(o => o.LoaiCN != LoaiCongNhat.NVCongNhat)) { int kq = DAO.InsKetLuongThang(m_Thang, nv); //if (kq == 0) MessageBox.Show("Xảy ra lỗi tại vị trí NV: " + nv.MaCC + nv.TenNV);//fortesting } // sau khi cập nhật lương từng nhân viên thì cập nhật thông số kết lương tháng int kq2 = DAO.UpdInsThongsoKetluongThang(m_Thang, XL2.PC30, XL2.PC50, XL2.PCTCC3, XL2.PC100, XL2.PC160, XL2.PC200, XL2.PC290, sanluong01, dongia02, perTrichQuyLuong, sanluongGiacongNoiBo, dongiaGiacongNoiBo, sanluongGiacongNgoai, dongiaGiacongNgoai, mucLuongToithieu, /*donGiaBdCa3,*/ DinhMuccomtrua, tongQuyLuongCV, tongQuyLuongNghiDinhCP, tongChiKhacTuQuyLuong, tongQuyLuongSP, giaTri_1SP_B3_1); //ghi log string noidung = string.Format("Kết lương tháng [{0}]", m_Thang.ToString("MM/yyyy")); DAO.GhiNhatKyThaotac("Kết lương", noidung); #endregion }
public MainWindow() { InitializeComponent(); dao = DAO.Instance(); }
public GroupView() { InitializeComponent(); dao = new GroupDAO(); Initialize(""); }
/// <summary> /// Create view, populate customerList array /// </summary> public ViewAllCustomers() { this.InitializeComponent(); customerList = new ObservableCollection <Customer>(DAO.GetAllCustomer()); }
public ActionResult AddProduct(AdminProductModel product) { if (Session["important"] != null || Session["juststaff"] != null) { DAO dao = new DAO(); DescriptionModel desc = new DescriptionModel(); List <DescriptionModel> descList = new List <DescriptionModel>(); descList.Add(desc); product.Details = descList; /** * 1. Upload fileto images dir and generate file name * 2. Create new category with that imgUrl file name */ string defaultImgUrlPath = Server.MapPath("~/Content/Images/no_image.png"); string newImgUrlPath = ""; string fileName = ""; int count = 0; string ext; string extractedName; var validImageTypes = new string[] { "image/gif", "image/jpeg", "image/pjpeg", "image/png" }; // Upload the image if (product.Image != null && product.Image.ContentLength > 0) { if (!validImageTypes.Contains(product.Image.ContentType)) { ViewBag.Message = "ERROR: Unknown image type"; } else { // Create new category if (ModelState.IsValid) { try { fileName = Path.GetFileName(product.Image.FileName); // Change file name // Extract name/extension extractedName = fileName.Split('.')[0]; ext = fileName.Split('.')[1]; // Create new name+ext fileName = product.Name.ToLower() + "." + ext; // Save to DB count = dao.InsertProduct(product, fileName); } catch (Exception ex) { ViewBag.Status = "DB ERROR!" + ex.Message; } if (count == 1) { // Upload the file newImgUrlPath = Path.Combine(Server.MapPath("~/Content/Images/products/"), fileName); product.Image.SaveAs(newImgUrlPath); ModelState.Clear(); return(RedirectToAction("Index", "AdminProduct")); } else { ViewBag.Status = "ERROR! Product create fail"; } return(View()); // Display modal to say category created } else { ViewBag.Status = "ERROR! Model Invalid"; } } } else { // No image file uploaded ViewBag.Status = "ERROR: No image selected"; } return(View()); } else { return(RedirectToAction("Index", "Home")); } }
public ReportsForm() { InitializeComponent(); string[] contractor = DAO.getInstance().getNoteToComboBox("name_contr", "Contractor"); contractorComboBox.Items.AddRange(contractor); }
public ActionResult UpdateProduct(AdminProductModel product, string id) { if (Session["important"] != null || Session["juststaff"] != null) { DAO dao = new DAO(); /** * 1. Upload fileto images dir and generate file name * 2. Create new category with that imgUrl file name */ string defaultImgUrlPath = Server.MapPath("~/Content/Images/no_image.png"); string newImgUrlPath = ""; string fileName = ""; int count = 0; string ext; string extractedName; var validImageTypes = new string[] { "image/gif", "image/jpeg", "image/pjpeg", "image/png" }; // Upload the image if (product.Image != null && product.Image.ContentLength > 0) { if (!validImageTypes.Contains(product.Image.ContentType)) { ViewBag.Status = "ERROR: Unknown image type"; } else { // Create new category if (ModelState.IsValid) { try { fileName = Path.GetFileName(product.Image.FileName); // Change file name // Extract name/extension extractedName = fileName.Split('.')[0]; ext = fileName.Split('.')[1]; // Create new name+ext fileName = product.Name.ToLower() + "." + ext; // Update product in DB count = dao.UpdateProduct(product, fileName, id); } catch (Exception ex) { ViewBag.Status = "DB ERROR!" + ex.Message; } if (count == 1) { ModelState.Clear(); // Get full path newImgUrlPath = Path.Combine(Server.MapPath("~/Content/Images/products"), fileName); // Delete old image string fullPath = Server.MapPath("~/Content/Images/products/" + TempData["oldImage"].ToString()); if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } // Upload the file product.Image.SaveAs(newImgUrlPath); return(RedirectToAction("Index")); } else { ViewBag.Status = "ERROR! Product create fail"; } return(View()); // Display modal to say category created } else { ViewBag.Status = "ERROR! Model Invalid"; } } } else { // No image file uploaded ViewBag.Status = "ERROR: No image selected"; } return(View()); } else { return(RedirectToAction("Index", "Home")); } }
public PrioridadesController() { this.Dao = new DAO <Prioridade>(); }
public DataTable GetAllUser() { return(DAO.GetTable(null, "select * from UserTable", CommandType.Text)); }
public void findButtonClick(string value, DataGridView dataGridViewContract) { DAO.getInstance().findContractor(value, dataGridViewContract); }
public ListaAlunos() { InitializeComponent(); dao = new DAO(); CarregarGrid(); }
private void XuatBangChiTiet(object sender, WaitWindowEventArgs e) { string saveFileName = e.Arguments[0].ToString(); var dsnv = new List <cUserInfo>(); var ngaydauthang = MyUtility.FirstDayOfMonth(m_Thang); var ngaycuoithang = MyUtility.LastDayOfMonth(m_Thang); #region lấy dữ liệu kết lương để xuất var tableKetLuongThang = DAO.LayKetLuongThang(ngaydauthang); var tableThongsoKetluongThang = DAO.LayThongsoKetluongThang(ngaydauthang); var tableDSNVChiCongnhatThang = DAO.LayTableCongNhat(ngaydauthang); var tableTongLuongCongnhat = SqlDataAccessHelper.ExecuteQueryString( @"select CAST(SUM (SoNgayCong*DonGiaLuong) as float) from DSNVChiCongNhatThang where Thang=@Thang", new string[] { "@Thang" }, new object[] { ngaydauthang }); var tongLuongCongnhat = (tableTongLuongCongnhat.Rows[0][0] != DBNull.Value) ? (double)tableTongLuongCongnhat.Rows[0][0] : 0d; var tongLuongDieuchinh = (from DataRow row in tableKetLuongThang.Rows let luongdieuchinh = (row["LuongDieuChinh"] != DBNull.Value) ? (double)row["LuongDieuChinh"] : 0d select luongdieuchinh).Sum(); var tableKetcongNgay = DAO.LayKetcongNgay(ngaydauthang, ngaycuoithang); var tableKetcongCa = DAO.LayKetcongCa(ngaydauthang, ngaycuoithang); var tableXPVang = DAO.LayTableXPVang(ngaydauthang, ngaycuoithang); var tableNgayLe = DAO.DocNgayLe(ngaydauthang, ngaycuoithang); #endregion ChuanBiDuLieuXuatLuong(dsnv, ngaydauthang, ngaycuoithang, tableKetLuongThang, tableKetcongNgay, tableKetcongCa, tableXPVang, tableNgayLe, tableDSNVChiCongnhatThang); var @continue = true; FileInfo template, fileResult; try { template = new FileInfo(Settings.Default.pathReportChiTietLuong); } catch (Exception ex) { if (ex is System.Security.SecurityException || ex is UnauthorizedAccessException) { MessageBox.Show(string.Format(Resources.Text_KoCoQuyenTruyCapFileX, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else if (ex is NotSupportedException || ex is PathTooLongException) { MessageBox.Show(string.Format(Resources.Text_UnsupportedFile_PathTooLong, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else { MessageBox.Show(string.Format(Resources.Text_CoLoi), Resources.Caption_Loi); return; } } try { fileResult = new FileInfo(saveFileName); } catch (Exception ex) { if (ex is System.Security.SecurityException || ex is UnauthorizedAccessException) { MessageBox.Show(string.Format(Resources.Text_KoCoQuyenTruyCapFileX, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else if (ex is NotSupportedException || ex is PathTooLongException) { MessageBox.Show(string.Format(Resources.Text_UnsupportedFile_PathTooLong, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else { MessageBox.Show(string.Format(Resources.Text_CoLoi), Resources.Caption_Loi); return; } } try { using (var packageResult = new ExcelPackage(template)) { var workbook = packageResult.Workbook; #region ghi sheet thong so var ws = workbook.Worksheets["ThongSo"]; ws.Name = "ThongSo"; //Setting Sheet's name XL.ExportSheetThongSo1(ws, ngaydauthang, tableThongsoKetluongThang); #endregion #region ghi sheet chi tiết từng ngày công ws = workbook.Worksheets["BangChiTietNgayCong"]; ws.Name = "BangChiTietNgayCong"; //XL.ExportSheetChiTietNgayCong1(ws, dsnv); #endregion var ws_Template = workbook.Worksheets["BangChiTietLuong"]; XL.ExportSheetChiTietLuong1(ws_Template, dsnv); while (@continue) { try { packageResult.SaveAs(fileResult); @continue = false; } catch (Exception ex) { lg.Error(string.Format("[{0}]_[{1}]\n", this.Name, System.Reflection.MethodBase.GetCurrentMethod().Name), ex); if (ex is IOException) { MessageBox.Show(Resources.Text_FileDangMoBoiUngDungKhac, Resources.Caption_Loi); @continue = true; } else { MessageBox.Show(Resources.Text_CoLoi, Resources.Caption_Loi); @continue = false; } } } } } catch (Exception ex) { if (ex is System.Security.SecurityException || ex is UnauthorizedAccessException) { MessageBox.Show(string.Format(Resources.Text_KoCoQuyenTruyCapFileX, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else if (ex is NotSupportedException || ex is PathTooLongException) { MessageBox.Show(string.Format(Resources.Text_UnsupportedFile_PathTooLong, "mẫu xuất báo biểu"), Resources.Caption_Loi); return; } else if (ex is IOException) { MessageBox.Show(Resources.Text_FileDangMoBoiUngDungKhac, Resources.Caption_Loi); return; } else { MessageBox.Show(Resources.Text_CoLoi, Resources.Caption_Loi); return; } } }
////******************************************************* ////********** Les Fonctions ************* ////******************************************************* //********************************************************* //***** Initialisation de la liste des Interactions ******* //********************************************************* /// <summary> /// Initialisation de la liste des Interactions /// </summary> /// <param name="emp">Liste des Interactions</param> public static void Init_Interactions(Interactions inte) { //Connexion avec base de données try { inte.Clear(); String[] result = new String[7]; // Requête Sql String strSql = "Select * from INTERACTION"; //// Execution de la requete IDataReader sqlRdr = DAO.Execute_Query(strSql); while (sqlRdr.Read()) { if (!sqlRdr.IsDBNull(0)) { result[0] = sqlRdr.GetString(0); } else { result[0] = "<nc>"; } if (!sqlRdr.IsDBNull(1)) { result[1] = sqlRdr.GetString(1); } else { result[1] = "<nc>"; } if (!sqlRdr.IsDBNull(2)) { result[2] = sqlRdr.GetString(2); } else { result[2] = "<nc>"; } if (!sqlRdr.IsDBNull(3)) { result[3] = sqlRdr.GetString(3); } else { result[3] = "<nc>"; } // Décomposition des ID string[] temp = result[3].Split('-'); string s0 = temp[0].Trim(); string s1 = temp[1].Trim(); string s2 = temp[2].Trim(); // Conversion des ID en entier int etage = Convert.ToInt32(s0.Substring(s0.Length - 1, 1)); int allee = Convert.ToInt32(s1.Substring(s1.Length - 1, 1)); int rayon = Convert.ToInt32(s2.Substring(s2.Length - 1, 1)); // Ajout d'une interaction dans la liste //us.Add(new Interaction(result[0], result[1], result[2], etage, allee, rayon)); ///////////////////////////////////////// //nb_materiel += 1; } //Fermeture de la requête sqlRdr.Close(); sqlRdr = null; } catch (Exception ex) { // ==> Si erreur, la LISTE est vide } }
public void TestMethod6() { int n = DAO.ExeSql("insert into users (name,username,password,last_word4,last_word6) values('xxx','333','123',1,1)"); }
public IActionResult Index() { ViewBag.Counts = DAO.RetrieveCounts(); return(View(DAO.RetrieveApps())); }
public void deleteButtonClick(string nameContractor, string subdivision, string nameContract) { DAO.getInstance().deleteContract(nameContractor, subdivision, nameContract); }
public LoginView() { this.InitializeComponent(); DAO.InitializeDatabase(); InitString(); }
private void print_seat_bill(Seat seat) { DataGridView dgv = new DataGridView(); DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn(); col.HeaderText = "手牌号"; dgv.Columns.Add(col); DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn(); col1.HeaderText = "项目名称"; dgv.Columns.Add(col1); DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn(); col2.HeaderText = "技师"; dgv.Columns.Add(col2); DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn(); col3.HeaderText = "单价"; dgv.Columns.Add(col3); DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn(); col4.HeaderText = "数量"; dgv.Columns.Add(col4); DataGridViewTextBoxColumn col5 = new DataGridViewTextBoxColumn(); col5.HeaderText = "金额"; dgv.Columns.Add(col5); double money_pay = 0; var orders = db.Orders.Where(x => x.systemId == seat.systemId && !x.paid && x.deleteEmployee == null); foreach (var order in orders) { string[] row = new string[6]; row[0] = order.text; row[1] = order.menu; row[2] = order.technician; var menu = db.Menu.FirstOrDefault(x => x.name == order.menu); if (menu != null) { row[3] = menu.price.ToString(); } row[4] = order.number.ToString(); double money_tmp = 0; if (order.priceType == "每小时") { row[3] = order.money.ToString() + "/时"; money_tmp = Math.Ceiling((GeneralClass.Now - order.inputTime).TotalHours) * order.money; } else { money_tmp = order.money; } money_pay += money_tmp; row[5] = money_tmp.ToString(); dgv.Rows.Add(row); } List <string> printCols = new List <string>(); List <string> m_rooms = new List <string>(); printCols.Add("包厢"); printCols.Add("手牌"); printCols.Add("项目名称"); printCols.Add("技师"); printCols.Add("单价"); printCols.Add("数量"); printCols.Add("金额"); List <CSeat> seats = new List <CSeat>(); var dao = new DAO(LogIn.connectionString); seats.Add(dao.get_seat("text='" + seat.text + "'")); foreach (var s in seats) { m_rooms.Add(dao.get_seat_room(s.text)); } PrintSeatBill.Print_DataGridView(seats, m_rooms, null, "预打账单", dgv, printCols, money_pay.ToString(), LogIn.options.companyName); }