public bool Update(Ext.Net.Component wrapperComponent, string tableName, string primaryKeyValue)
{
try
{
string sql = "update " + tableName + " set {0} where #### = N'" + primaryKeyValue + "'";
GetChildControl(wrapperComponent);
sql = string.Format(sql, UpdateQuery.Remove(UpdateQuery.LastIndexOf(",")));
return(DataController.DataHandler.GetInstance().ExecuteNonQuery("DAL_Update", "@sqlQuery", "@tableName", "@primaryKeyValue", sql, tableName, primaryKeyValue) > 0);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Tiến hành insert một bản ghi vào CSDL
/// </summary>
/// <param name="wrapperComponent">container chứa các control</param>
/// <param name="tableName">Tên bảng muốn insert</param>
/// <returns></returns>
///
public bool Add(Ext.Net.Component wrapperComponent, string tableName)
{
try
{
string sql = "insert into " + tableName + "({0}) values({1})";
GetChildControl(wrapperComponent);
// sql = string.Format(sql, ColumnName.Remove(ColumnName.LastIndexOf(",")), ValueList.Remove(ValueList.LastIndexOf(",")));
return(DataController.DataHandler.GetInstance().ExecuteNonQuery(string.Format(sql, ColumnName.Remove(ColumnName.LastIndexOf(",")), ValueList.Remove(ValueList.LastIndexOf(",")))) > 0);
}
catch (Exception ex)
{
throw ex;
}
}
public void GetChildControl(Ext.Net.Component wrapperComponent)
{
switch (wrapperComponent.ToString())
{
case "Ext.Net.Window":
Ext.Net.Window window = (Ext.Net.Window)wrapperComponent;
GenSql(window.Items);
break;
case "Ext.Net.Container":
Ext.Net.Container ctainer = (Ext.Net.Container)wrapperComponent;
GenSql(ctainer.Items);
break;
case "Ext.Net.FieldSet":
Ext.Net.FieldSet fs = (Ext.Net.FieldSet)wrapperComponent;
GenSql(fs.Items);
break;
default:
break;
}
}
public bool Add(Ext.Net.Component wrapperComponent, string tableName, string[] parameters, string [] values)
{
try
{
string sql = "insert into " + tableName + "({0}) values({1})";
for (int i = 0; i < parameters.Count(); i++)
{
if (!string.IsNullOrEmpty(parameters[i]))
{
ColumnName += "[" + parameters[i] + "],";
ValueList += "N'" + values[i] + "',";
UpdateQuery += "[" + parameters[i] + "] = N'" + values[i] + "',";
}
}
GetChildControl(wrapperComponent);
// sql = string.Format(sql, ColumnName.Remove(ColumnName.LastIndexOf(",")), ValueList.Remove(ValueList.LastIndexOf(",")));
return(DataController.DataHandler.GetInstance().ExecuteNonQuery(string.Format(sql, ColumnName.Remove(ColumnName.LastIndexOf(",")), ValueList.Remove(ValueList.LastIndexOf(",")))) > 0);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Lấy fieldname và giá trị
/// </summary>
/// <param name="control"></param>
/// <param name="value"></param>
/// <returns></returns>
private string GetFieldName(Ext.Net.Component control, ref object value)
{
switch (control.ToString())
{
case "Ext.Net.TextField":
Ext.Net.TextField txtControl = (Ext.Net.TextField)control;
value = txtControl.Text;
if (!txtControl.ID.Contains("_"))
{
return("");
}
else
{
return(txtControl.ID.Substring(txtControl.ID.IndexOf("_") + 1));
}
case "Ext.Net.Hidden":
Ext.Net.Hidden hdfControl = (Ext.Net.Hidden)control;
value = hdfControl.Text;
if (!hdfControl.ID.Contains("_"))
{
return("");
}
else
{
return(hdfControl.ID.Substring(hdfControl.ID.IndexOf("_") + 1));
}
case "Ext.Net.Checkbox":
Ext.Net.Checkbox chk = (Ext.Net.Checkbox)control;
value = chk.Checked == true ? 1 : 0;
if (!chk.ID.Contains("_"))
{
return("");
}
else
{
return(chk.ID.Substring(chk.ID.IndexOf("_") + 1));
}
case "Ext.Net.DateField":
Ext.Net.DateField dfDate = (Ext.Net.DateField)control;
if (!SoftCore.Util.GetInstance().IsDateNull(dfDate.SelectedDate))
{
value = dfDate.SelectedDate.Month + "/" + dfDate.SelectedDate.Day + "/" + dfDate.SelectedDate.Year;
}
else
{
value = "";
}
if (!dfDate.ID.Contains("_"))
{
return("");
}
else
{
return(dfDate.ID.Substring(dfDate.ID.IndexOf("_") + 1));
}
case "Ext.Net.NumberField":
Ext.Net.NumberField nbf = (Ext.Net.NumberField)control;
value = nbf.Text;
if (!nbf.ID.Contains("_"))
{
return("");
}
else
{
return(nbf.ID.Substring(nbf.ID.IndexOf("_") + 1));
}
case "Ext.Net.ComboBox":
Ext.Net.ComboBox cbBox = (Ext.Net.ComboBox)control;
value = cbBox.SelectedItem.Value;
if (!cbBox.ID.Contains("_"))
{
return("");
}
else
{
return(cbBox.ID.Substring(cbBox.ID.IndexOf("_") + 1));
}
case "Ext.Net.SpinnerField":
Ext.Net.SpinnerField spinnerField = (Ext.Net.SpinnerField)control;
value = spinnerField.Text;
if (!spinnerField.ID.Contains("_"))
{
return("");
}
else
{
return(spinnerField.ID.Substring(spinnerField.ID.IndexOf("_") + 1));
}
case "Ext.Net.TextArea":
Ext.Net.TextArea txtArea = (Ext.Net.TextArea)control;
value = txtArea.Text;
if (!txtArea.ID.Contains("_"))
{
return("");
}
else
{
return(txtArea.ID.Substring(txtArea.ID.IndexOf("_") + 1));
}
case "Ext.Net.Container":
Ext.Net.Container cContainer = (Ext.Net.Container)control;
GetChildControl(cContainer);
break;
case "Ext.Net.FieldSet":
Ext.Net.FieldSet fieldSet = (Ext.Net.FieldSet)control;
GetChildControl(fieldSet);
break;
case "Ext.Net.HtmlEditor":
Ext.Net.HtmlEditor htmlEditor = (Ext.Net.HtmlEditor)control;
value = htmlEditor.Text;
if (!htmlEditor.ID.Contains("_"))
{
return("");
}
else
{
return(htmlEditor.ID.Substring(htmlEditor.ID.IndexOf("_") + 1));
}
}
return("");
}
public void AddControlToSouth(Ext.Net.Component control, bool collapsiable)
{
borderLayout.South.Split = true;
borderLayout.South.Collapsible = collapsiable;
borderLayout.South.Items.Add(control);
}
/// <summary>
/// add control vào west layout
/// </summary>
/// <param name="control"></param>
public void AddControlToWest(Ext.Net.Component control)
{
borderLayout.West.Split = true;
borderLayout.West.Collapsible = true;
borderLayout.West.Items.Add(control);
}
/// <summary>
///
/// </summary>
public Component.Builder Component(Component component)
{
return(new Component.Builder(component));
}
