public int delete(int id)
{
BasicInfoEntity entity = new BasicInfoEntity();
string delQuery = "delete from " + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(id);
return(provider.delete(delQuery));
}
public int getId(string englishName)
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_ENGLISHNAME + "=" + RMX_TOOLS.data.Config.provider.getSQLString(englishName);
load(entity, cond);
return(int.Parse(entity.Tables[entity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_ID].ToString()));
}
public BasicInfoList()
{
InitializeComponent();
_basicInfoEntity = new BasicInfoEntity();
_basicInfoBl = new BasicInfoBL();
_gridTools = new GridTools();
fillGrid();
}
public BasicInfoEntity getRoots()
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_PARENT_ID + " is null AND ID > 0";
load(entity, cond);
return(entity);
}
public BasicInfoEntity getByEnglishName(string englishName)
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_ENGLISHNAME + "=" + data.Config.provider.getSQLString(englishName);
load(entity, cond);
return(entity);
}
public string getCustomData(string englishName)
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_ENGLISHNAME + "=" + RMX_TOOLS.data.Config.provider.getSQLString(englishName);
load(entity, cond);
return(entity.Tables[entity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_CUSTOMFIELD].ToString());
}
public BasicInfoEntity get()
{
BasicInfoEntity entity = new BasicInfoEntity();
// string cond = "ACTIVE = 1";
load(entity);
return(entity);
}
public int updateCustomData(int id, string customData)
{
BasicInfoEntity entity = new BasicInfoEntity();
string q = "UPDATE " + entity.TableName + " SET " +
BasicInfoEntity.FIELD_CUSTOMFIELD + "=" + dp.getSQLString(customData) + " WHERE " +
BasicInfoEntity.FIELD_ID + "=" + dp.getSQLString(id);
return(provider.executeNonQuery(q));
}
public BasicInfoEntity get(int id)
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_ID + "=" + RMX_TOOLS.data.Config.provider.getSQLString(id);
load(entity, cond);
return(entity);
}
public BasicInfoEntity getByParentId(int parentId, bool showInactives)
{
BasicInfoEntity entity = new BasicInfoEntity();
string cond = BasicInfoEntity.FIELD_PARENT_ID + "=" + data.Config.provider.getSQLString(parentId);
if (!showInactives)
{
cond += " AND " + BasicInfoEntity.FIELD_ACTIVE + " = " + 1;
}
load(entity, cond);
return(entity);
}
private void fillGrid(int parentId)
{
System.Collections.Hashtable hash = new Hashtable();
//hash.Add("colorField", InsuranceTypeData.INSURANCETYPECOLOR_FIELD);
if (parentId < 0)
{
_basicInfoEntity = _basicInfoBl.getRoots();
}
else
{
_basicInfoEntity = _basicInfoBl.getByParentId(parentId, true);
}
_gridTools.bindDataToGrid(dataGridView1, _basicInfoEntity, new GridTools.changingRow(_gridTools.changeColor), hash);
}
public void intiForm()
{
if (Constants.DELETE_MODE.Equals(Mode))
{
pnlContainer.Visible = false;
btnSave.Visible = false;
if (Id < 0)
{
return;
}
_entity = _basicInfoBL.get(_id);
string s = _entity.get(BasicInfoEntity.FIELD_USERCANCHANGE).ToString();
bool b = false;
if (s != null && s.Length > 0)
{
b = Boolean.Parse(s);
}
if (b)
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "امکان حذف این مورد وجود ندارد";
return;
}
doDelete();
return;
}
if (_entity != null)
{
_id = int.Parse(_entity.get(BasicInfoEntity.FIELD_ID).ToString());
_mode = RMX_TOOLS.global.Constants.EDIT_MODE;
}
else if (_id > 0)
{
_mode = RMX_TOOLS.global.Constants.EDIT_MODE;
_entity = _basicInfoBL.get(_id);
loadForm();
}
else
{
_mode = RMX_TOOLS.global.Constants.ADD_MODE;
_entity = new BasicInfoEntity();
}
}
public void load()
{
int biId = _basicInfoBL.getId(_engName);
BasicInfoEntity entity = _basicInfoBL.getByParentId(biId);
CheckBox cb;
for (int i = 0; i < entity.Tables[entity.FilledTableName].Rows.Count; i++)
{
string desc = entity.get(i, BasicInfoEntity.FIELD_DESCRIPTION).ToString();
int id = int.Parse(entity.get(i, BasicInfoEntity.FIELD_ID).ToString());
cb = new CheckBox();
cb.Checked = false;
cb.Tag = id;
cb.Text = desc;
cb.Height = 20;
cb.Width = flowLayoutPanel1.Width - 5;
flowLayoutPanel1.Controls.Add(cb);
}
}
public static void fillCheckBoxList(CheckedListBox cmb, string englishName, int defaultItemId)
{
BasicInfoEntity entity = _basicInfoBL.getByEnglishName(englishName);
fillCheckBoxList(cmb, int.Parse(entity.get(BasicInfoEntity.FIELD_ID).ToString()), defaultItemId);
}
/*public BasicInfoEntity get(int id)
* {
* BasicInfoEntity entity = new BasicInfoEntity();
* string cond = BasicInfoEntity.FIELD_ID + "=" + dp.getSQLString(id);
* dp.loadToDataSet(BasicInfoEntity.TABLE, entity, "");
* return entity;
* }
*/
public int add(BasicInfoEntity basicInfoEntity)
{
return(dp.add(basicInfoEntity));
}
public int add(BasicInfoEntity entity)
{
return(_basicInfoDA.add(entity));
}
public int update(BasicInfoEntity entity)
{
return(_basicInfoDA.update(entity));
}
public static void fillComboBox(ComboBox cmb, int parentId, int defaultItemId)
{
BasicInfoEntity parentEntity = _basicInfoBL.get(parentId);
Boolean containsUnknown = false;
string c = parentEntity.get(BasicInfoEntity.FIELD_CONTAINUNKNOWN).ToString();
if (c != null && c.Trim().Length > 0)
{
containsUnknown = Boolean.Parse(c);
}
BasicInfoEntity entity = _basicInfoBL.getByParentId(parentId);
var dataSource = new List <ComboBoxItem>();
try
{
cmb.Items.Clear();
}
catch (Exception ex) { }
if (containsUnknown == true)
{
AddUnKnown(dataSource);
}
for (int i = 0; i < entity.Tables[entity.FilledTableName].Rows.Count; i++)
{
string id = entity.Tables[entity.FilledTableName].Rows[i][BasicInfoEntity.FIELD_ID].ToString();
string desc = entity.Tables[entity.FilledTableName].Rows[i][BasicInfoEntity.FIELD_DESCRIPTION].ToString();
string customData = "";
if (entity.Tables[entity.FilledTableName].Rows[i][BasicInfoEntity.FIELD_CUSTOMFIELD] != null)
{
customData = entity.Tables[entity.FilledTableName].Rows[i][BasicInfoEntity.FIELD_CUSTOMFIELD].ToString();
}
dataSource.Add(new ComboBoxItem(desc, id, customData));
}
// is inActive? or not
BasicInfoEntity niEntity = _basicInfoBL.get(defaultItemId);
if (niEntity.Tables[niEntity.FilledTableName].Rows.Count > 0)
{
bool isActive = bool.Parse(niEntity.Tables[niEntity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_ACTIVE].ToString());;
if (isActive == false)
{
string id = niEntity.Tables[niEntity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_ID].ToString();
string desc = niEntity.Tables[niEntity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_DESCRIPTION].ToString();
string customData = "";
if (niEntity.Tables[niEntity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_CUSTOMFIELD] != null)
{
customData = niEntity.Tables[entity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_CUSTOMFIELD].ToString();
}
dataSource.Add(new ComboBoxItem(desc, id, customData));
}
}
cmb.DataSource = dataSource;
cmb.DisplayMember = "Text";
cmb.ValueMember = "Value";
for (int i = 0; i < cmb.Items.Count; i++)
{
if (((ComboBoxItem)cmb.Items[i]).Value.Equals(defaultItemId.ToString()))
{
cmb.SelectedIndex = i;
break;
}
}
}
public static int getId(string englishName)
{
BasicInfoEntity entity = _basicInfoBL.getByEnglishName(englishName);
return(int.Parse(entity.Tables[entity.FilledTableName].Rows[0][BasicInfoEntity.FIELD_ID].ToString()));
}