Exemple #1
0
        public Boolean UpdateModuleConfigInfo(Guid moduleID, String json, Boolean isActive, Int32 deviceType)
        {
            List <JZTestConfig> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestConfig> >(json);
            Boolean             flag = true;

            if (list != null)
            {
                IDbConnection DbConnection = GetConntion();
                Yqun.Data.DataBase.Transaction Transaction = new Yqun.Data.DataBase.Transaction(DbConnection);

                try
                {
                    Int32  active = isActive ? 1 : 0;
                    String sql    = String.Format(@"Delete dbo.sys_module_config WHERE ModuleID='{0}' ", moduleID);
                    flag = flag && (ExcuteCommand(sql) == 1);
                    sql  = String.Format("UPDATE dbo.sys_module SET DeviceType={0} WHERE ID='{1}'", deviceType, moduleID);
                    flag = flag && (ExcuteCommand(sql) == 1);
                    foreach (var item in list)
                    {
                        String config = Newtonsoft.Json.JsonConvert.SerializeObject(item.Config);
                        flag = flag && SaveModuleConfig(moduleID, item.SerialNumber, config, active);
                    }
                    if (flag)
                    {
                        Transaction.Commit();
                    }
                    else
                    {
                        Transaction.Rollback();
                    }
                }
                catch (Exception ex)
                {
                    Transaction.Rollback();
                    logger.Error("update module config error: " + ex.Message);
                }
            }

            return(flag);
        }
Exemple #2
0
        public Boolean SaveLineFormula(Guid moduleID, Dictionary <string, JZFormulaData> CrossSheetFormulaCache)
        {
            IDbConnection DbConnection = GetConntion();

            Yqun.Data.DataBase.Transaction Transaction = new Yqun.Data.DataBase.Transaction(DbConnection);
            Boolean noError = true;
            String  sql     = "DELETE FROM dbo.sys_line_formulas WHERE ModuleID='" + moduleID + "' ";

            try
            {
                Int32 result = ExcuteCommand(sql);
                if (result == -1)
                {
                    noError = false;
                }
                sql = @"INSERT INTO dbo.sys_line_formulas
                                    ( ID ,
                                      ModuleID ,
                                      SheetID ,
                                      RowIndex ,
                                      ColumnIndex ,
                                      Formula ,
                                      CreatedUser ,
                                      CreatedTime ,
                                      LastEditedUser ,
                                      LasteditedTime ,
                                      IsActive
                                    )
                            VALUES  ( NEWID() ,
                                      '{0}' ,
                                      '{1}' ,
                                      {2} ,
                                      {3} ,
                                      '{4}' ,
                                      '{5}' ,
                                      GETDATE() ,
                                      '{6}' ,
                                      GETDATE() ,
                                      1
                                    )";
                foreach (JZFormulaData item in CrossSheetFormulaCache.Values)
                {
                    result = ExcuteCommand(String.Format(sql, item.ModelIndex, item.SheetIndex, item.RowIndex, item.ColumnIndex,
                                                         item.Formula.Replace("'", "''"),
                                                         Yqun.Common.ContextCache.ApplicationContext.Current.UserName,
                                                         Yqun.Common.ContextCache.ApplicationContext.Current.UserName));
                    if (result == -1)
                    {
                        noError = false;
                    }
                }
                if (noError)
                {
                    Transaction.Commit();
                }
                else
                {
                    Transaction.Rollback();
                }
            }
            catch (Exception ex)
            {
                Transaction.Rollback();
                logger.Error("SaveLineFormula error: " + moduleID + ", error content is: " + ex.Message);
            }
            return(noError);
        }