摘要：严谨！！！！DataSet ds = salarySum.GetDataSalarySum2(libUser.SelectedValue, dtpMonth.Value.Date); if (ds != null && ds.Tables.Count > 0) { 阅读全文

摘要：if (libUser.Items.Count > 0) { string _sUserList = string.Empty; foreach (object o in libUser.Items) { _sUserList += o.ToString().Split('|').GetValue(1).ToString() + ","; } _sUserList = _sUserLis... 阅读全文

摘要：1.//this.dgvEmployees.ColumnHeadersDefaultCellStyle.ForeColor = Color.Blue; //dgvEmployees.RowHeadersVisible = false;//列头影藏 //dgvEmployees.Columns["image_path"].Visible = false;//图片路径列隐藏 //dgvEmployees.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.A... 阅读全文

摘要：DECLARE @SQL VARCHAR(8000)SET @SQL = 'select overcode 'SELECT @SQL = @SQL + ' , max(case header when ''' + header + ''' then 1 else 0 end) [' + header + ']'FROM (SELECT DISTINCT header FROM overtime_detail) AS aSET @SQL = @SQL + ' from overtime_det 阅读全文

摘要：string TripCode = "BT"+DateTime.Now.ToString("yyyyMMddHHmmss");//出差单号 阅读全文