public bool Delete(DieuKien dieukien) { string query = "DELETE FROM DieuKien" + " WHERE MaHP=@MaHP or MaHPDK=@MaHPDK"; SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@MaHP", SqlDbType.VarChar); sqlParameters[0].Value = dieukien.MaHP; sqlParameters[1] = new SqlParameter("@MaHPDK", SqlDbType.VarChar); sqlParameters[1].Value = dieukien.MaHPDK; return(executeDeleteQuery(query, sqlParameters)); }
public override FrameworkElement CreateCellEditElement(Telerik.Windows.Controls.GridView.GridViewCell cell, object dataItem) { try { cmbCommon = new RadComboBox(); if (!dataItem.IsNullOrEmpty()) { PropertyInfo property = null; object oObject = dataItem; if (!DieuKienDataMember.IsNullOrEmptyOrSpace()) { foreach (string str in DieuKienDataMember.Split('.').ToList()) { property = oObject.GetType().GetProperty(str); if (property != null) { DieuKien = property.GetValue(oObject, null).ToString(); oObject = property.GetValue(oObject, null); } } } if (!sTruyVan.Equals("")) { List <string> lstDieuKien = new List <string>(); lstDieuKien.Add(DieuKien.ToString()); lstComboBox = new List <AutoCompleteEntry>(); KhoiTaoGiaTriComboBox(ref lstComboBox, ref cmbCommon, sTruyVan, lstDieuKien); } if (!GiaTriDataMember.IsNullOrEmptyOrSpace()) { this.SetBinding(GiaTriProperty, CreateValueBinding(dataItem)); } if (!GiaTri.IsNullOrEmptyOrSpace()) { cmbCommon.SelectedIndex = lstComboBox.IndexOf(lstComboBox.FirstOrDefault(i => i.KeywordStrings.First().Equals(GiaTri))); } else { cmbCommon.SelectedIndex = -1; } } cmbCommon.Tag = lstComboBox; cmbCommon.IsEnabled = true; cmbCommon.SelectionChanged += new SelectionChangedEventHandler(cmbCommon_SelectionChanged); } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } cellEdit = cell; return(cmbCommon as FrameworkElement); }
public override FrameworkElement CreateCellEditElement(Telerik.Windows.Controls.GridView.GridViewCell cell, object dataItem) { try { cmbCommon = new RadComboBox(); if (lstComboBox != null || lstComboBox.Count > 0) { new AutoComboBox().GenAutoComboBox(ref lstComboBox, ref cmbCommon, null, null, giaTri); } else { if (!dataItem.IsNullOrEmpty()) { PropertyInfo property = null; if (!DieuKienDataMember.IsNullOrEmptyOrSpace()) { property = dataItem.GetType().GetProperty(DieuKienDataMember); if (property != null) { DieuKien = property.GetValue(dataItem, null).ToString(); } } property = dataItem.GetType().GetProperty(GiaTriDataMember); if (property != null) { GiaTri = property.GetValue(dataItem, null).ToString(); lstComboBox = new List <AutoCompleteEntry>(); List <string> lstDieuKien = new List <string>(); lstDieuKien.Add(DieuKien.ToString()); if (!sTruyVan.Equals("")) { KhoiTaoGiaTriComboBox(ref lstComboBox, ref cmbCommon, sTruyVan, lstDieuKien); } cmbCommon.SelectedIndex = lstComboBox.IndexOf(lstComboBox.FirstOrDefault(i => i.KeywordStrings.First().Equals(GiaTri))); cmbCommon.Tag = lstComboBox; } } } cmbCommon.IsEnabled = true; cmbCommon.IsEditable = true; cmbCommon.SelectionChanged += new SelectionChangedEventHandler(cmbCommon_SelectionChanged); } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } cellEdit = cell; return(cmbCommon as FrameworkElement); }
public bool Insert(DieuKien dieukien) { string query = "INSERT INTO DieuKien (MaHP,LoaiDK,MaHPDK) " + "VALUES (@MaHP,@LoaiDK,@MaHPDK)"; SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@MaHP", SqlDbType.VarChar); sqlParameters[0].Value = dieukien.MaHP; sqlParameters[1] = new SqlParameter("@LoaiDK", SqlDbType.NVarChar); sqlParameters[1].Value = dieukien.LoaiDK; sqlParameters[2] = new SqlParameter("@MaHPDK", SqlDbType.VarChar); sqlParameters[2].Value = dieukien.MaHPDK; return(executeInsertQuery(query, sqlParameters)); }
public bool Update(DieuKien dieukien) { string query = "UPDATE DieuKien" + " SET LoaiDK=@LoaiDK" + " WHERE MaHP=@MaHP AND MaHPDK=@MaHPDK"; SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@MaHP", SqlDbType.VarChar); sqlParameters[0].Value = dieukien.MaHP; sqlParameters[1] = new SqlParameter("@LoaiDK", SqlDbType.NVarChar); sqlParameters[1].Value = dieukien.LoaiDK; sqlParameters[2] = new SqlParameter("@MaHPDK", SqlDbType.VarChar); sqlParameters[2].Value = dieukien.MaHPDK; return(executeUpdateQuery(query, sqlParameters)); }
private bool IsValidDK_PT(object value, ValidationContext obj) { bool pt = true; bool dk = true; if (PhuongThuc != null) { pt = PropertyContainsValue(obj.ObjectInstance, _phuongthuc_prop, PhuongThuc); } if (DieuKien != null) { dk = PropertyContainsValue(obj.ObjectInstance, _dieukien_prop, DieuKien.ToString()); } return(pt && dk); }
public void InitData() { string v_strScript = ""; StringBuilder v_st = new StringBuilder(); string v_strGridHeader = "", v_strGridBody = "", v_strGridFooter = ""; int v_iReturnCol = 0; if (MaTruyVan.Length > 0) { List <string> v_lstDieuKien = new List <string>(); if (DieuKien.Length > 0) { string[] v_arr = DieuKien.Split("|".ToCharArray()); for (int i = 0; i < v_arr.GetLength(0); i++) { v_lstDieuKien.Add(v_arr[i]); } } DataTable v_dt = TruyVanController.GetPopupData(MaTruyVan, v_lstDieuKien); if (null != v_dt) { //Build header v_strGridHeader = "<table id=\"grdPopup\" class=\"display\" cellspacing=\"0\" border=\"0\" width=\"100%\">\r\n"; v_strGridHeader += " <thead>\r\n"; v_strGridHeader += " <tr>\r\n"; for (int i = 0; i < v_dt.Columns.Count; i++) { v_strGridHeader += " <th>" + LanguageEngine.Instance().GetContent(LanguageType.TypeUI, v_dt.Columns[i].Caption) + "</th>\r\n"; if (v_dt.Columns[i].ExtendedProperties["width"].ToString() == "0") { v_st.AppendLine(" table.column(" + i.ToString() + ").visible(false);"); } if (v_dt.Columns[i].ColumnName.ToUpper().Trim() == ReturnKey.ToUpper().Trim()) { v_iReturnCol = i; } } v_strGridHeader += " </tr>\r\n"; v_strGridHeader += " </thead>\r\n"; v_strGridFooter = "</table>"; //Build body v_strGridBody = "<tbody>\r\n"; for (int i = 0; i < v_dt.Rows.Count; i++) { v_strGridBody += " <tr>\r\n"; for (int j = 0; j < v_dt.Columns.Count; j++) { if (v_dt.Columns[j].DataType == typeof(DateTime)) { v_strGridBody += " <td>" + ((DateTime)v_dt.Rows[i][j]).ToString("dd/MM/yyyy") + "</td>\r\n"; } else if ((v_dt.Columns[j].DataType == typeof(Int32)) || (v_dt.Columns[j].DataType == typeof(Int64)) || (v_dt.Columns[j].DataType == typeof(Decimal)) || (v_dt.Columns[j].DataType == typeof(float))) { v_strGridBody += " <td>" + (Convert.ToDecimal(v_dt.Rows[i][j])).ToString("###,###,##0.##") + "</td>\r\n"; } else { if (!v_dt.Columns[j].ColumnName.Contains("KEY")) { v_strGridBody += " <td>" + LanguageEngine.Instance().GetContent(LanguageType.TypeUI, v_dt.Rows[i][j].ToString()) + "</td>\r\n"; } else { v_strGridBody += " <td>" + v_dt.Rows[i][j].ToString() + "</td>\r\n"; } } } v_strGridBody += " </tr>\r\n"; } v_strGridBody += "/<tbody>\r\n"; //Build script v_strScript = "<script type = \"text/javascript\">\r\n" + "$(function() {\r\n" + " var table = $(\"#grdPopup\").DataTable({\r\n" + " \"bInfo\": false,\r\n" + " \"pageLength\": 10,\r\n" + " \"dom\": '<\"top\"i>rt<\"bottom\"flp><\"clear\">'\r\n" + " });\r\n" + v_st.ToString() + "\r\n" + " $('#grdPopup tbody').on('dblclick', 'tr', function() {\r\n" + " if ($(this).hasClass('selected')) {\r\n" + " $(this).removeClass('selected');\r\n" + " }\r\n" + " else {\r\n" + " table.$('tr.selected').removeClass('selected');\r\n" + " $(this).addClass('selected');\r\n" + " opener.setSearchResult(targetField,table.row(this).data()[" + v_iReturnCol.ToString() + "]);\r\n" + " window.close();\r\n" + " }\r\n" + " });\r\n" + "});\r\n" + " </script>\r\n"; mv_strConent = v_strScript + v_strGridHeader + v_strGridBody + v_strGridFooter; } } }
public bool Sua(DieuKien dieuKien) { bool result = false; return(result); }