예제 #1
0
 /// <summary>
 /// 从datatable将数据导入
 /// 可用
 /// </summary>
 /// <param name="dataTable"></param>
 /// <returns></returns>
 public static int InsertIntoPropertyConstraintFromExcel(DataTable dataTable)
 {
     using (var context = new AnnonContext())
     {
         try
         {
             foreach (DataRow dataRow in dataTable.Rows)
             {
                 var propertyConstraint = new PropertyConstraint
                 {
                     PropertyID = Convert.ToInt32(dataRow["PropertyID"].ToString()),
                     PropertyValueIdRange = dataRow["PropertyValueIdRange"].ToString(),
                     InfluencedPtyID = Convert.ToInt32(dataRow["InfluencedPtyID"].ToString()),
                     InfluencedPtyValueIdRange = dataRow["InfluencedPtyValueIdRange"].ToString(),
                     ConstraintRules = dataRow["ConstraintRules"].ToString(),
                     InfluencedPtyDefaultValue = dataRow["InfluencedPtyDefaultValue"].ToString(),
                     DeviceID = Convert.ToInt32(dataRow["DeviceID"].ToString())
                 };
                 context.PropertyConstraints.Add(propertyConstraint);
             }
             return context.SaveChanges();
         }
         catch (Exception e)
         {
             return -1;
         }
     }
 }
예제 #2
0
 /// <summary>
 /// 插入属性约束
 /// 可用
 /// </summary>
 /// <param name="propertyID"></param>
 /// <param name="propertyValueRange"></param>
 /// <param name="influencedPtyID"></param>
 /// <param name="influencePtyValueRange"></param>
 /// <param name="constraintRules"></param>
 /// <param name="influencePtyDefaultValue"></param>
 /// <param name="deviceId"></param>
 /// <returns></returns>
 public static int InsertIntoPropertyConstraint(int propertyID, string propertyValueRange,
     int influencedPtyID, string influencePtyValueRange, string constraintRules, string influencePtyDefaultValue, int deviceId)
 {
     var propertyConstraint = new PropertyConstraint
     {
         PropertyID = propertyID,
         PropertyValueIdRange = propertyValueRange,
         InfluencedPtyID = influencedPtyID,
         InfluencedPtyValueIdRange = influencePtyValueRange,
         ConstraintRules = constraintRules,
         InfluencedPtyDefaultValue = influencePtyDefaultValue,
         DeviceID = deviceId
     };
     using (var context = new AnnonContext())
     {
         try
         {
             context.PropertyConstraints.Add(propertyConstraint);
             return context.SaveChanges();
         }
         catch (Exception e)
         {
             return -1;
         }
     }
 }