示例#1
0
        public static string WorkoutDeltaStringForUpdate(FinanceAccountExtLoanViewModel oldAcnt,
                                                         FinanceAccountExtLoanViewModel newAcnt)
        {
            var diffs = WorkoutDeltaForUpdate(oldAcnt, newAcnt);

            List <String> listHeaderSqls = new List <string>();

            foreach (var diff in diffs)
            {
                var dbfield = newAcnt.GetDBFieldName(diff.Key);

                if (diff.Value is DateTime)
                {
                    listHeaderSqls.Add("[" + dbfield + "] = '" + ((DateTime)diff.Value).ToString("yyyy-MM-dd") + "'");
                }
                else if (diff.Value is Boolean)
                {
                    listHeaderSqls.Add("[" + dbfield + "] = " + (((Boolean)diff.Value) ? "1" : "NULL"));
                }
                else if (diff.Value is String)
                {
                    if (String.IsNullOrEmpty((string)diff.Value))
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = NULL");
                    }
                    else
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = N'" + diff.Value + "'");
                    }
                }
                else if (diff.Value is Decimal)
                {
                    if (Decimal.Compare((Decimal)diff.Value, 0) == 0)
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = NULL");
                    }
                    else
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = " + diff.Value.ToString());
                    }
                }
                else if (diff.Value is Boolean)
                {
                    if ((bool)diff.Value)
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = 1");
                    }
                    else
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = 0");
                    }
                }
                else
                {
                    if (diff.Value == null)
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = NULL");
                    }
                    else
                    {
                        listHeaderSqls.Add("[" + dbfield + "] = " + diff.Value.ToString());
                    }
                }
            }

            return(listHeaderSqls.Count == 0 ?
                   String.Empty :
                   (@"UPDATE [dbo].[t_fin_account_ext_loan] SET " + string.Join(",", listHeaderSqls)
                    + " WHERE [ACCOUNTID] = " + oldAcnt.AccountID.ToString()));
        }
示例#2
0
        public static Dictionary <String, Object> WorkoutDeltaForUpdate(FinanceAccountExtLoanViewModel oldAcnt,
                                                                        FinanceAccountExtLoanViewModel newAcnt)
        {
            Dictionary <String, Object> dictDelta = new Dictionary <string, object>();

            if (oldAcnt == null || newAcnt == null || Object.ReferenceEquals(oldAcnt, newAcnt) ||
                oldAcnt.AccountID != newAcnt.AccountID)
            {
                throw new ArgumentException("Invalid inputted parameter Or AccountID change is not allowed");
            }
            if (!oldAcnt.IsValid() || !newAcnt.IsValid())
            {
                throw new Exception("Account info is invalid");
            }

            Type t = typeof(FinanceAccountExtLoanViewModel);

            PropertyInfo[] listProperties       = t.GetProperties();
            var            listSortedProperties = listProperties.OrderBy(o => o.Name);

            foreach (PropertyInfo item in listSortedProperties)
            {
                if (item.Name == "LoanTmpDocs")
                {
                    continue;
                }

                object oldValue = item.GetValue(oldAcnt, null);
                object newValue = item.GetValue(newAcnt, null);
                if (item.PropertyType == typeof(Nullable <Decimal>))
                {
                    if (Nullable.Compare <Decimal>(oldValue as Nullable <Decimal>, newValue as Nullable <Decimal>) != 0)
                    {
                        if (newValue != null)
                        {
                            dictDelta.Add(item.Name, (newValue as Nullable <Decimal>).Value);
                        }
                        else
                        {
                            dictDelta.Add(item.Name, null);
                        }
                    }
                }
                else if (item.PropertyType == typeof(Nullable <DateTime>))
                {
                    if (Nullable.Compare <DateTime>(oldValue as Nullable <DateTime>, newValue as Nullable <DateTime>) != 0)
                    {
                        if (newValue != null)
                        {
                            dictDelta.Add(item.Name, (newValue as Nullable <DateTime>).Value);
                        }
                        else
                        {
                            dictDelta.Add(item.Name, null);
                        }
                    }
                }
                else if (item.PropertyType == typeof(Nullable <Boolean>))
                {
                    if (Nullable.Compare <Boolean>(oldValue as Nullable <Boolean>, newValue as Nullable <Boolean>) != 0)
                    {
                        if (newValue != null)
                        {
                            dictDelta.Add(item.Name, (newValue as Nullable <Boolean>).Value ? 1 : 0);
                        }
                        else
                        {
                            dictDelta.Add(item.Name, null);
                        }
                    }
                }
                else if (item.PropertyType == typeof(Nullable <Int32>))
                {
                    if (Nullable.Compare <Int32>(oldValue as Nullable <Int32>, newValue as Nullable <Int32>) != 0)
                    {
                        if (newValue != null)
                        {
                            dictDelta.Add(item.Name, (newValue as Nullable <Int32>).Value);
                        }
                        else
                        {
                            dictDelta.Add(item.Name, null);
                        }
                    }
                }
                else if (item.PropertyType == typeof(Nullable <Int16>))
                {
                    if (Nullable.Compare <Int16>(oldValue as Nullable <Int16>, newValue as Nullable <Int16>) != 0)
                    {
                        if (newValue != null)
                        {
                            dictDelta.Add(item.Name, (newValue as Nullable <Int16>).Value);
                        }
                        else
                        {
                            dictDelta.Add(item.Name, null);
                        }
                    }
                }
                else if (item.PropertyType == typeof(Decimal))
                {
                    if (Decimal.Compare((Decimal)oldValue, (Decimal)newValue) != 0)
                    {
                        dictDelta.Add(item.Name, newValue);
                    }
                }
                else if (item.PropertyType == typeof(String))
                {
                    if (String.CompareOrdinal((string)oldValue, (string)newValue) != 0)
                    {
                        dictDelta.Add(item.Name, newValue);
                    }
                }
                else if (item.PropertyType == typeof(DateTime))
                {
                    if (DateTime.Compare(((DateTime)oldValue).Date, ((DateTime)newValue).Date) != 0)
                    {
                        dictDelta.Add(item.Name, newValue);
                    }
                }
                else
                {
                    if (!Object.Equals(oldValue, newValue))
                    {
                        dictDelta.Add(item.Name, newValue);
                    }
                }
            }

            return(dictDelta);
        }