예제 #1
0
 private int RunCommandWithTransatcion(VSM.Entities.BuWFRelationship ent, string vSql, IDbTransaction TRANS)
 {
     if (null == TRANS)
     {
         MySqlParameter[] paras = new MySqlParameter[ent.Column.Count];
         for (int i = 0; i < ent.Column.Count; i++)
         {
             paras[i] = new MySqlParameter();
             paras[i].ParameterName = ent.Column[i].FieldName;
             paras[i].DbType        = ent.Column[i].FieldType;
             paras[i].Value         = ent.Column[i].FieldValue;
         }
         return(DataBaseManage.ExecuteSql(vSql, paras));
     }
     else
     {
         System.Data.IDbCommand CM = TRANS.Connection.CreateCommand();
         CM.CommandText = vSql;
         CM.CommandType = CommandType.Text;
         CM.Transaction = TRANS;
         GetEntityDeleteParameter(CM, ent);
         try
         {
             return(CM.ExecuteNonQuery());
         }
         catch (System.Exception e)
         {
             if (isDebug)
             {
                 throw new Exception(e.Message);
             }
             return(0);
         }
     }
 }
예제 #2
0
 /// <summary>
 /// 得到列表
 /// </summary>
 /// <param name="ent"></param>
 /// <returns></returns>
 public List<BuWFRelationship> GetBuWFRelationshipList(string Where)
 {
     List<BuWFRelationship> list = new List<BuWFRelationship>();
     using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where))
     {
         while (reader.Read())
         {
            BuWFRelationship ent = new BuWFRelationship();
             SetEnt(ent, reader);
             list.Add(ent);
         }
     }
     return list;
 }
예제 #3
0
 /// <summary>
 /// 根据RelationshipId得到 BuWFRelationship 实体
 /// </summary>
 /// <param name="ent"></param>
 /// <returns></returns>
 public BuWFRelationship GetBuWFRelationship(int RelationshipId)
 {
     BuWFRelationship ent = null;
     string sql = DalSql;
     sql = sql + " And  RelationshipId";
     MySqlParameter[] paras = new MySqlParameter[]
     {
         new MySqlParameter("RelationshipId",RelationshipId)
     };
     using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
     {
         if (reader.Read())
         {
             ent = new BuWFRelationship();
             SetEnt(ent, reader);
         }
        		}
     return ent;
 }
예제 #4
0
 public void SetEnt(BuWFRelationship ent, IDataReader dr)
 {
     ent.RelationshipId = MyConvert.ToInt(dr["RelationshipId"]);
     ent.WorkflowGUID = MyConvert.ToString(dr["WorkflowGUID"]);
     ent.LastProcessId = MyConvert.ToInt(dr["LastProcessId"]);
     ent.CurProcessId = MyConvert.ToInt(dr["CurProcessId"]);
     ent.NextProcessId = MyConvert.ToInt(dr["NextProcessId"]);
     ent.ApprovePostId = MyConvert.ToInt(dr["ApprovePostId"]);
     ent.ApprovePostName = MyConvert.ToString(dr["ApprovePostName"]);
     ent.Enable = MyConvert.ToInt(dr["Enable"]);
 }