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);
}
