示例#1
0
文件: Tree.cs 项目: yarivat/Admin
        public void Rename(string key, string name, BeforeEditEventHandler bfEdit, BeforeEditInDatabaseEventHandler bfDbEdit, AfterEditEventHandler afEdit, AfterEditEventHandler afEditAndCommit)
        {
            //string sql = "UPDATE {0} SET [{1}] = '{2}') WHERE [{3}]='{4}'";
            //string query = string.Format(sql,view.DataTable.TableName, view.DisplayColumn, name, view.PrimaryKeyFileds[0].DatabaseNames,key);

            Dictionary <string, object> values = new Dictionary <string, object>();

            //values.Add(view.PrimaryKeyFileds[0].Name, key);
            values.Add(view.DisplayColumn, name);

            DataAccess.SqlAccess da = new DataAccess.SqlAccess();

            da.Edit(view, values, key, bfEdit, bfDbEdit, afEdit, afEditAndCommit);
        }
示例#2
0
        public static void AssignToParent(this View view, string newParent, string[] pks, BeforeEditEventHandler beforeEditCallback, BeforeEditInDatabaseEventHandler beforeEditInDatabaseEventHandler, AfterEditEventHandler afterEditBeforeCommitCallback, AfterEditEventHandler afterEditAfterCommitCallback)
        {
            if (!view.AllowEdit)
            {
                throw new AccessViolationException();
            }

            ICopyPaste assignCommand = GetCopyPaste(view);

            try
            {
                foreach (string pk in pks)
                {
                    Dictionary <string, object> values = new Dictionary <string, object>();

                    values.Add(view.TreeRelatedFieldName, newParent);

                    assignCommand.Edit(view, values, pk, beforeEditCallback, beforeEditInDatabaseEventHandler, afterEditBeforeCommitCallback, afterEditAfterCommitCallback);
                }
            }
            catch (Exception exeption)
            {
                assignCommand.PasteCommit(true);
                throw new DuradosException(exeption.Message);
            }
            finally
            {
                try
                {
                    assignCommand.CloseConnections();
                }
                catch { }
            }

            assignCommand.PasteCommit(false);
        }
示例#3
0
 public static void Edit(this View view, Dictionary <string, object> values, string pk, BeforeEditEventHandler beforeEditCallback, BeforeEditInDatabaseEventHandler beforeEditInDatabaseEventHandler, AfterEditEventHandler afterEditBeforeCommitCallback, AfterEditEventHandler afterEditAfterCommitCallback)
 {
     if (!view.AllowEdit)
     {
         throw new AccessViolationException();
     }
     GetDataTableAccess(view).Edit(view, values, pk, beforeEditCallback, beforeEditInDatabaseEventHandler, afterEditBeforeCommitCallback, afterEditAfterCommitCallback);
 }
示例#4
0
        public void EditField(View view, string fieldName, object fieldValue, string pk, BeforeEditEventHandler beforeEditCallback, BeforeEditInDatabaseEventHandler beforeEditInDatabaseCallback, AfterEditEventHandler afterEditBeforeCommitCallback, AfterEditEventHandler afterEditAfterCommitCallback)
        {
            Dictionary <string, object> values = new Dictionary <string, object>();

            values.Add(fieldName, LocalizeValue(view, fieldName, fieldValue));

            view.Edit(values, pk, beforeEditCallback, beforeEditInDatabaseCallback, afterEditBeforeCommitCallback, afterEditAfterCommitCallback);
        }
示例#5
0
        public void CopyPasteView(View view, Json.CopyPaste jsonView, BeforeEditEventHandler beforeEditCallback, BeforeEditInDatabaseEventHandler beforeEditInDatabaseCallback, AfterEditEventHandler afterEditBeforeCommitCallback, AfterEditEventHandler afterEditAfterCommitCallback)
        {
            string pk = "";

            int RowsNumber = jsonView.GetRowsNumber();

            ICopyPaste cpCommand = view.GetCopyPaste();

            try
            {
                int multi        = 1;
                int newRownumber = 0;

                int valuesCount = jsonView.Source.FieldsValues.Count;

                if (RowsNumber > valuesCount && RowsNumber % valuesCount == 0)
                {
                    multi      = (int)(RowsNumber / valuesCount);
                    RowsNumber = valuesCount;
                }
                else if (RowsNumber != valuesCount)
                {
                    throw new DuradosException("Rows number do not match Source data selected");
                }

                for (int m = 1; m <= multi; m++)
                {
                    for (int r = 0; r < RowsNumber; r++)
                    {
                        int names = jsonView.Source.FieldsNames.Count;

                        if (names != jsonView.Source.FieldsValues[r].Count)
                        {
                            throw new DuradosException("Source values do not match Source Fields Names");
                        }

                        Dictionary <string, object> values = new Dictionary <string, object>();

                        object value;

                        for (int i = 0; i < names; i++)
                        {
                            value = LocalizeValue(view, jsonView.Source.FieldsNames[i], jsonView.Source.FieldsValues[r][i]);
                            values.Add(jsonView.Source.FieldsNames[i], value);
                        }

                        pk = jsonView.Destination.RowsPKs[newRownumber + r];

                        cpCommand.Edit(view, values, pk, beforeEditCallback, beforeEditInDatabaseCallback, afterEditBeforeCommitCallback, afterEditAfterCommitCallback);
                    }

                    newRownumber += RowsNumber;
                }

                cpCommand.PasteCommit(false);
            }
            catch (Exception exeption)
            {
                cpCommand.PasteCommit(true);
                throw new DuradosException(exeption.Message); //"Error while processing data, Paste operation cancelled!");
            }
            finally
            {
                try
                {
                    cpCommand.CloseConnections();
                }
                catch { }
            }
        }
示例#6
0
        public void EditRow(View view, Json.View jsonView, string pk, bool ignoreNull, BeforeEditEventHandler beforeEditCallback, BeforeEditInDatabaseEventHandler beforeEditInDatabaseCallback, AfterEditEventHandler afterEditBeforeCommitCallback, AfterEditEventHandler afterEditAfterCommitCallback)
        {
            Dictionary <string, object> values = new Dictionary <string, object>();

            foreach (Json.Field jsonField in jsonView.Fields.Values)
            {
                if (!(ignoreNull && !jsonField.Refresh && (jsonField.Value == null || jsonField.Value.ToString() == string.Empty || jsonField.Value.Equals(false))))
                {
                    object value;
                    if (view.Fields.ContainsKey(jsonField.Name))
                    {
                        if (view.Fields[jsonField.Name].FieldType == FieldType.Column && ((ColumnField)view.Fields[jsonField.Name]).DataColumn.DataType.Equals(typeof(byte[])))
                        {
                            value = ((ColumnField)view.Fields[jsonField.Name]).ConvertFromString(jsonField.Value.ToString());
                        }
                        else
                        {
                            value = LocalizeValue(view, jsonField.Name, jsonField.Value);
                        }
                        values.Add(jsonField.Name, value);
                    }
                    else
                    {
                        values.Add(jsonField.Name, jsonField.Value);
                    }
                }
            }
            view.Edit(values, pk, beforeEditCallback, beforeEditInDatabaseCallback, afterEditBeforeCommitCallback, afterEditAfterCommitCallback);
        }