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