public int UpdateSpecialCompanent2WorkFlowBySpecialDetailID(SpecialCompanent2WorkFlow obj) { string sql = @"UPDATE [BE_SpecialCompanent2WorkFlow] SET [SpecialID]=@SpecialID , [WorkFlowID]=@WorkFlowID , [Sequence]=@Sequence WHERE [SpecialDetailID]=@SpecialDetailID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSpecialID = new SqlParameter("SpecialID", Convert2DBnull(obj.SpecialID)); pSpecialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialID); SqlParameter pWorkFlowID = new SqlParameter("WorkFlowID", Convert2DBnull(obj.WorkFlowID)); pWorkFlowID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pWorkFlowID); SqlParameter pSequence = new SqlParameter("Sequence", Convert2DBnull(obj.Sequence)); pSequence.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pSequence); SqlParameter pSpecialDetailID = new SqlParameter("SpecialDetailID", Convert2DBnull(obj.SpecialDetailID)); pSpecialDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialDetailID); return(cmd.ExecuteNonQuery()); }
public int InsertSpecialCompanent2WorkFlow(SpecialCompanent2WorkFlow obj) { string sql = @"INSERT INTO[BE_SpecialCompanent2WorkFlow]([SpecialDetailID] , [SpecialID] , [WorkFlowID] , [Sequence] ) VALUES(@SpecialDetailID , @SpecialID , @WorkFlowID , @Sequence )" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSpecialDetailID = new SqlParameter("SpecialDetailID", Convert2DBnull(obj.SpecialDetailID)); pSpecialDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialDetailID); SqlParameter pSpecialID = new SqlParameter("SpecialID", Convert2DBnull(obj.SpecialID)); pSpecialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialID); SqlParameter pWorkFlowID = new SqlParameter("WorkFlowID", Convert2DBnull(obj.WorkFlowID)); pWorkFlowID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pWorkFlowID); SqlParameter pSequence = new SqlParameter("Sequence", Convert2DBnull(obj.Sequence)); pSequence.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pSequence); return(cmd.ExecuteNonQuery()); }
public List <SpecialCompanent2WorkFlow> LoadSpecialCompanent2WorkFlowsBySequence(int sequence) { string sql = @"SELECT [SpecialDetailID] , [SpecialID] , [WorkFlowID] , [Sequence] FROM [BE_SpecialCompanent2WorkFlow] WHERE [Sequence]=@Sequence" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSequence = new SqlParameter("Sequence", sequence); pSequence.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pSequence); List <SpecialCompanent2WorkFlow> ret = new List <SpecialCompanent2WorkFlow>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { SpecialCompanent2WorkFlow iret = new SpecialCompanent2WorkFlow(); if (!Convert.IsDBNull(dr["SpecialDetailID"])) { iret.SpecialDetailID = (Guid)dr["SpecialDetailID"]; } if (!Convert.IsDBNull(dr["SpecialID"])) { iret.SpecialID = (Guid)dr["SpecialID"]; } if (!Convert.IsDBNull(dr["WorkFlowID"])) { iret.WorkFlowID = (Guid)dr["WorkFlowID"]; } if (!Convert.IsDBNull(dr["Sequence"])) { iret.Sequence = (int)dr["Sequence"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int LoadSpecialCompanent2WorkFlowBySpecialDetailID(SpecialCompanent2WorkFlow obj) { string sql = @"SELECT [SpecialDetailID] , [SpecialID] , [WorkFlowID] , [Sequence] FROM [BE_SpecialCompanent2WorkFlow] WITH(NOLOCK) WHERE [SpecialDetailID]=@SpecialDetailID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSpecialDetailID = new SqlParameter("SpecialDetailID", Convert2DBnull(obj.SpecialDetailID)); pSpecialDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialDetailID); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { if (!Convert.IsDBNull(dr["SpecialDetailID"])) { obj.SpecialDetailID = (Guid)dr["SpecialDetailID"]; } if (!Convert.IsDBNull(dr["SpecialID"])) { obj.SpecialID = (Guid)dr["SpecialID"]; } if (!Convert.IsDBNull(dr["WorkFlowID"])) { obj.WorkFlowID = (Guid)dr["WorkFlowID"]; } if (!Convert.IsDBNull(dr["Sequence"])) { obj.Sequence = (int)dr["Sequence"]; } ret += 1; } } finally { dr.Close(); } return(ret); }